DBA Data[Home] [Help]

APPS.PAY_US_1099R_UDFS dependencies on PER_ALL_ASSIGNMENTS_F

Line 681: from per_all_assignments_f paa

677:
678: cursor get_person_id (c_assignment_id number , c_effective_date date ) /* 8219772 */
679: is
680: select distinct paa.person_id
681: from per_all_assignments_f paa
682: where paa.assignment_id = c_assignment_id
683: and c_effective_date between paa.effective_start_date and paa.effective_end_date ;
684:
685: BEGIN