APPS.PAY_ES_TWR_CALC_PKG dependencies on PER_ALL_PEOPLE_F

Line 91: ,per_all_people_f pap

87: ,NVL(pcr.cont_information1,'N') fiscal_dependent
88: ,NVL(pcr.cont_information2,'N') single_parent
89: ,pcr.date_start date_start
90: FROM per_contact_relationships pcr
91: ,per_all_people_f pap
92: ,per_All_assignments_f paaf
93: WHERE paaf.assignment_id = passignment_id
94: AND pcr.person_id = paaf.person_id
95: AND pap.person_id = pcr.contact_person_id

Line 359: FROM per_all_people_f pap

355: CURSOR c_marital_status IS
356: SELECT pap.marital_status
357: ,pap.person_id
358: ,paaf.assignment_number
359: FROM per_all_people_f pap
360: ,per_all_assignments_f paaf
361: WHERE paaf.assignment_id = passignment_id
362: AND pap.person_id = paaf.person_id
363: AND peffective_date BETWEEN pap.effective_start_date

Line 368: l_marital_status per_all_people_f.marital_status%TYPE;

364: AND pap.effective_end_date
365: AND peffective_date BETWEEN paaf.effective_start_date
366: AND paaf.effective_end_date;
367: --
368: l_marital_status per_all_people_f.marital_status%TYPE;
369: l_person_id per_all_people_f.person_id%TYPE;
370: l_fiscal_dependent per_contact_relationships.cont_information1%TYPE;
371: l_marital_status_desc VARCHAR2(80);
372: --

Line 369: l_person_id per_all_people_f.person_id%TYPE;

365: AND peffective_date BETWEEN paaf.effective_start_date
366: AND paaf.effective_end_date;
367: --
368: l_marital_status per_all_people_f.marital_status%TYPE;
369: l_person_id per_all_people_f.person_id%TYPE;
370: l_fiscal_dependent per_contact_relationships.cont_information1%TYPE;
371: l_marital_status_desc VARCHAR2(80);
372: --
373: BEGIN

Line 446: lperson_id per_all_people_f.person_id%TYPE;

442: WHERE paaf.assignment_id = passignment_id
443: AND peffective_date BETWEEN paaf.effective_start_date
444: AND paaf.effective_end_date;
445: --
446: lperson_id per_all_people_f.person_id%TYPE;
447: ldisabled VARCHAR2(1);
448: BEGIN
449: --
450: OPEN c_get_person_id;

Line 1006: FROM per_all_people_f pap

1002: --
1003: CURSOR csr_get_emp_name(C_payroll_action_id NUMBER
1004: ,c_effective_date DATE) IS
1005: SELECT pap.full_name
1006: FROM per_all_people_f pap
1007: ,per_All_assignments_f paaf
1008: ,pay_assignment_actions paa
1009: WHERE paa.payroll_action_id = c_payroll_action_id
1010: AND paa.assignment_id = paaf.assignment_id

Line 1018: l_name per_all_people_f.full_name%TYPE;

1014: AND pap.effective_end_date
1015: AND c_effective_date BETWEEN paaf.effective_start_date
1016: AND paaf.effective_end_date;
1017: --
1018: l_name per_all_people_f.full_name%TYPE;
1019: BEGIN
1020: --
1021: l_name := ' ';
1022: IF p_action_type = 'Q' THEN

Line 1127: FROM per_all_people_f pap

1123: ,pap.person_id
1124: ,paaf.assignment_number
1125: ,hr_general.decode_lookup('MAR_STATUS',pap.marital_status) marital_status
1126: ,floor(months_between(c_effective_date,pap.date_of_birth)/12) Age
1127: FROM per_all_people_f pap
1128: ,per_all_assignments_f paaf
1129: WHERE pap.person_id = paaf.person_id
1130: AND paaf.assignment_id = c_assignment_id
1131: AND c_effective_date BETWEEN pap.effective_start_date AND pap.effective_end_date