DBA Data[Home] [Help]

APPS.PAY_ZA_EOY_VAL dependencies on PER_ASSIGNMENTS_F

Line 720: from per_assignments_f paf2

716: AND asgn2.assignment_id = paa.assignment_id
717: AND per.person_id = asgn2.person_id
718: AND asgn2.effective_start_date =
719: ( select max(paf2.effective_start_date)
720: from per_assignments_f paf2
721: where paf2.effective_start_date <= ppa.effective_date
722: and paf2.assignment_id = asgn2.assignment_id
723: )
724: AND per.effective_start_date =