APPS.PER_GB_TAX_BEN_PKG dependencies on PER_ALL_PEOPLE_F

Line 1484: v_empl_nr per_all_people_f.employee_number%TYPE,

1480: AND paa.business_group_id = v_bg_id
1481: AND paa.primary_flag = 'Y';
1482:
1483: CURSOR csr_empl_nr (
1484: v_empl_nr per_all_people_f.employee_number%TYPE,
1485: v_bg_id per_all_assignments_f.business_group_id%TYPE,
1486: v_effective_date DATE
1487: )
1488: IS

Line 1492: per_all_people_f pap,

1488: IS
1489: SELECT paa.assignment_number, paa.assignment_id, pos.date_start,
1490: pos.final_process_date
1491: FROM per_all_assignments_f paa,
1492: per_all_people_f pap,
1493: per_periods_of_service pos
1494: WHERE pap.employee_number = v_empl_nr
1495: AND pap.person_id = paa.person_id
1496: AND paa.period_of_service_id = pos.period_of_service_id

Line 1505: v_ni_nr per_all_people_f.national_identifier%TYPE,

1501: AND paa.business_group_id = v_bg_id
1502: AND paa.primary_flag = 'Y';
1503:
1504: CURSOR csr_ni_nr (
1505: v_ni_nr per_all_people_f.national_identifier%TYPE,
1506: v_bg_id per_all_assignments_f.business_group_id%TYPE,
1507: v_effective_date DATE
1508: )
1509: IS

Line 1513: FROM per_all_people_f pap,

1509: IS
1510: SELECT /*+ ORDERED use_nl(pap paa pos) */
1511: paa.assignment_number, paa.assignment_id, pos.date_start,
1512: pos.final_process_date
1513: FROM per_all_people_f pap,
1514: per_all_assignments_f paa,
1515: per_periods_of_service pos
1516: WHERE pap.national_identifier = v_ni_nr
1517: AND pap.business_group_id = v_bg_id