DBA Data[Home] [Help]

APPS.PAY_FR_DUCS dependencies on PER_ALL_PEOPLE_F

Line 1010: FROM per_all_people_f per

1006: and paa.assignment_id=pac.assignment_id;
1007:
1008: CURSOR cur_sex(l_person_id number) IS
1009: SELECT per.sex
1010: FROM per_all_people_f per
1011: WHERE per.person_id = l_person_id;
1012:
1013: CURSOR cur_asg_count IS
1014: SELECT count(distinct pac.assignment_id),