Group Build Effective Sequence

Is there any way to have group build interact will all effective sequences? It always adds criteria to get the max effective sequence for an emplid, empl_rcd, effdt.

WHERE (JOB.EMPLID = PERSON.EMPLID AND JOB.EMPLID = PER_ORG_ASGN.EMPLID AND

      JOB.EMPL_RCD = PER_ORG_ASGN.EMPL_RCD AND

      JOB.EFFSEQ = (SELECT MAX(EFFSEQ)

                       FROM PS_JOB

                      WHERE JOB.EMPLID = EMPLID

                        AND JOB.EMPL_RCD = EMPL_RCD

                        AND JOB.EFFDT = EFFDT))

Thanks,

Gil