APPS.PAY_CN_AUDIT_XMLGEN dependencies on PER_ALL_PEOPLE_F

Line 884: FROM per_all_people_f ppf,

880: from pay_all_payrolls_f pap
881: where pap.payroll_id = p_payroll_id
882: AND g_end_date BETWEEN pap.effective_start_date AND pap.effective_end_date) pname,
883: (SELECT ppf.employee_number
884: FROM per_all_people_f ppf,
885: per_all_assignments_f paf
886: WHERE paf.person_id = ppf.person_id
887: AND paf.assignment_id = p_assignment_id
888: AND p_date_earned BETWEEN ppf.effective_start_date and ppf.effective_end_date

Line 926: FROM per_all_people_f ppf,

922: from pay_all_payrolls_f pap
923: where pap.payroll_id = p_payroll_id
924: AND g_end_date BETWEEN pap.effective_start_date AND pap.effective_end_date) pname,
925: (SELECT ppf.employee_number
926: FROM per_all_people_f ppf,
927: per_all_assignments_f paf
928: WHERE paf.person_id = ppf.person_id
929: AND paf.assignment_id = p_assignment_id
930: AND p_date_earned BETWEEN ppf.effective_start_date and ppf.effective_end_date

Line 977: FROM per_all_people_f ppf,

973: from pay_all_payrolls_f pap
974: where pap.payroll_id = p_payroll_id
975: AND g_end_date BETWEEN pap.effective_start_date AND pap.effective_end_date) pname,
976: (SELECT ppf.employee_number
977: FROM per_all_people_f ppf,
978: per_all_assignments_f paf
979: WHERE paf.person_id = ppf.person_id
980: AND paf.assignment_id = p_assignment_id
981: AND p_date_earned BETWEEN ppf.effective_start_date and ppf.effective_end_date

Line 1280: FROM per_all_people_f

1276:
1277: CURSOR c_employee_number
1278: IS
1279: SELECT employee_number
1280: FROM per_all_people_f
1281: WHERE person_id = p_person_id
1282: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1283:
1284: l_emp_num per_all_people_f.employee_number%TYPE;

Line 1284: l_emp_num per_all_people_f.employee_number%TYPE;

1280: FROM per_all_people_f
1281: WHERE person_id = p_person_id
1282: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1283:
1284: l_emp_num per_all_people_f.employee_number%TYPE;
1285:
1286: BEGIN
1287:
1288: IF g_debug THEN

Line 1318: FROM per_all_people_f

1314:
1315: CURSOR c_employee_name
1316: IS
1317: SELECT full_name
1318: FROM per_all_people_f
1319: WHERE person_id = p_person_id
1320: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1321:
1322: l_emp_name VARCHAR2(1000);