APPS.PAY_KR_BEE_UPLOAD dependencies on PER_PEOPLE_F

Line 1617: v_empl_nr per_people_f.employee_number%TYPE,

1613: AND paa.business_group_id = v_bg_id
1614: AND paa.primary_flag = 'Y';
1615:
1616: CURSOR csr_empl_nr (
1617: v_empl_nr per_people_f.employee_number%TYPE,
1618: v_bg_id per_assignments_f.business_group_id%TYPE,
1619: v_effective_date DATE
1620: )
1621: IS

Line 1627: per_people_f pap,

1623: paa.assignment_id,
1624: pos.date_start,
1625: pos.final_process_date
1626: FROM per_assignments_f paa,
1627: per_people_f pap,
1628: per_periods_of_service pos
1629: WHERE pap.employee_number = v_empl_nr
1630: AND pap.person_id = paa.person_id
1631: AND paa.period_of_service_id = pos.period_of_service_id

Line 1640: v_ni_nr per_people_f.national_identifier%TYPE,

1636: AND paa.business_group_id = v_bg_id
1637: AND paa.primary_flag = 'Y';
1638:
1639: CURSOR csr_ni_nr (
1640: v_ni_nr per_people_f.national_identifier%TYPE,
1641: v_bg_id per_assignments_f.business_group_id%TYPE,
1642: v_effective_date DATE
1643: )
1644: IS

Line 1650: per_people_f pap,

1646: paa.assignment_id,
1647: pos.date_start,
1648: pos.final_process_date
1649: FROM per_assignments_f paa,
1650: per_people_f pap,
1651: per_periods_of_service pos
1652: WHERE pap.national_identifier = v_ni_nr
1653: AND pap.person_id = paa.person_id
1654: AND paa.period_of_service_id = pos.period_of_service_id