APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PER_ALL_PEOPLE_F

Line 81: FROM per_all_people_f pap

77: ,p_degree OUT NOCOPY NUMBER) AS
78: --
79: CURSOR csr_get_disability_degree IS
80: SELECT pdf.degree
81: FROM per_all_people_f pap
82: ,per_disabilities_f pdf
83: ,per_all_assignments_f paa
84: WHERE pap.person_id = pdf.person_id
85: AND pap.person_id = paa.person_id

Line 406: FROM per_all_people_f pap

402: ,RPAD(pap.per_information1,20,' ') second_last_name
403: ,RPAD(pap.first_name,15,' ') name
404: /* Reserved flag is left blank */
405: ,paa.assignment_id assignment_id
406: FROM per_all_people_f pap
407: ,(SELECT DISTINCT asg_run.assignment_id assignment_id, asg_run.person_id person_id
408: FROM per_assignment_extra_info asg_extra
409: ,per_all_assignments_f asg_run
410: WHERE asg_extra.aei_information_category = 'ES_SS_REP'

Line 571: ,per_all_people_f pap

567: ,c_business_group_id NUMBER
568: ,c_reporting_date DATE) IS
569: SELECT region_2
570: FROM per_addresses pas
571: ,per_all_people_f pap
572: ,per_all_assignments_f paa
573: WHERE paa.person_id = pap.person_id
574: AND pas.person_id = pap.person_id
575: AND paa.assignment_id = c_assignment_id

Line 589: l_replace_person_id per_all_people_f.person_id%TYPE;

585: l_unused_number NUMBER;
586: l_action_info_id pay_action_information.action_information_id%TYPE;
587: l_ovn pay_action_information.object_version_number%TYPE;
588: l_contract_start_date DATE;
589: l_replace_person_id per_all_people_f.person_id%TYPE;
590: l_replacement_reason_code per_contracts_f.ctr_information7%TYPE;
591: l_ss_identifier pay_element_entry_values_f.screen_entry_value%TYPE;
592: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
593: l_relationship_type pay_element_entry_values_f.screen_entry_value%TYPE;

Line 759: ,per_all_people_f pap

755: ,paa.soft_coding_keyflex_id
756: ,paa.employee_category employee_category
757: ,paa.collective_agreement_id
758: FROM per_all_assignments_f paa
759: ,per_all_people_f pap
760: WHERE paa.assignment_id = c_assignment_id
761: AND paa.person_id = pap.person_id
762: AND paa.effective_start_date = fnd_date.canonical_to_date(c_effective_start_date)
763: AND paa.effective_start_date BETWEEN pap.effective_start_date

Line 830: l_date_of_birth per_all_people_f.date_of_birth%TYPE;

826: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;
827: l_employee_category VARCHAR2(30);
828: l_collective_agreement NUMBER;
829: l_disability_degree NUMBER;
830: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
831: l_sex per_all_people_f.sex%TYPE;
832: l_system_status per_assignment_status_types.per_system_status%TYPE;
833: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
834: l_contract_key pay_element_entry_values_f.screen_entry_value%TYPE;

Line 831: l_sex per_all_people_f.sex%TYPE;

827: l_employee_category VARCHAR2(30);
828: l_collective_agreement NUMBER;
829: l_disability_degree NUMBER;
830: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
831: l_sex per_all_people_f.sex%TYPE;
832: l_system_status per_assignment_status_types.per_system_status%TYPE;
833: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
834: l_contract_key pay_element_entry_values_f.screen_entry_value%TYPE;
835: --

Line 980: ,per_all_people_f pap

976: ,paa.effective_start_date actual_date
977: ,pap.date_of_birth date_of_birth
978: ,pap.sex sex
979: from per_all_assignments_f paa
980: ,per_all_people_f pap
981: ,per_assignment_status_types pas
982: where paa.assignment_id = '||p_assignment_id||'
983: and paa.person_id = pap.person_id
984: and paa.assignment_status_type_id = pas.assignment_status_type_id

Line 1012: ,per_all_people_f pap

1008: ,pay_input_values_f piv
1009: ,pay_element_types_f pet
1010: ,pay_element_entries_f pee
1011: ,per_all_assignments_f paa
1012: ,per_all_people_f pap
1013: where pev.element_entry_id = pee.element_entry_id
1014: and paa.person_id = pap.person_id
1015: and paa.assignment_id = pee.assignment_id
1016: and pee.assignment_id = '||p_assignment_id||'

Line 1051: ,per_all_people_f pap

1047: ,paa.effective_start_date actual_date
1048: ,pap.date_of_birth date_of_birth
1049: ,pap.sex sex
1050: from per_all_assignments_f paa
1051: ,per_all_people_f pap
1052: ,hr_soft_coding_keyflex sck
1053: where paa.assignment_id = '||p_assignment_id||'
1054: and paa.person_id = pap.person_id
1055: and paa.soft_coding_keyflex_id = sck.soft_coding_keyflex_id

Line 1078: ,per_all_people_f pap

1074: ,pps.actual_termination_date actual_date
1075: ,pap.date_of_birth date_of_birth
1076: ,pap.sex sex
1077: from per_all_assignments_f paa
1078: ,per_all_people_f pap
1079: ,per_periods_of_service pps
1080: where paa.assignment_id = '||p_assignment_id||'
1081: and paa.person_id = pap.person_id
1082: and pps.person_id = pap.person_id

Line 1111: ,per_all_people_f pap

1107: ,pay_input_values_f piv
1108: ,pay_element_types_f pet
1109: ,pay_element_entries_f pee
1110: ,per_all_assignments_f paa
1111: ,per_all_people_f pap
1112: where pev.element_entry_id = pee.element_entry_id
1113: and paa.person_id = pap.person_id
1114: and paa.assignment_id = pee.assignment_id
1115: and pee.assignment_id = '||p_assignment_id||'

Line 1204: l_date_of_birth per_all_people_f.date_of_birth%TYPE;

1200: l_unused_value pay_action_information.action_information4%TYPE;
1201: l_unused_number NUMBER;
1202: l_value pay_action_information.action_information4%TYPE;
1203: l_actual_date DATE;
1204: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
1205: l_sex per_all_people_f.sex%TYPE;
1206: --
1207: get_csr_event_values csr_event_values;
1208: --

Line 1205: l_sex per_all_people_f.sex%TYPE;

1201: l_unused_number NUMBER;
1202: l_value pay_action_information.action_information4%TYPE;
1203: l_actual_date DATE;
1204: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
1205: l_sex per_all_people_f.sex%TYPE;
1206: --
1207: get_csr_event_values csr_event_values;
1208: --
1209: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;