APPS.PAY_SG_AWCAP_ARCHIVE dependencies on PER_PEOPLE_F

Line 18: person_id per_people_f.person_id%type,

14: report_category pay_payroll_actions.report_category%TYPE,
15: business_group_id number,
16: effective_date date,
17: retain_archive_data char(1),
18: person_id per_people_f.person_id%type,
19: basis_year varchar2(4),
20: legal_entity_id number ,
21: Start_date date ,
22: End_date date );

Line 75: per_people_f pap

71: l_proc_name varchar2(100);
72: c_range_cursor constant varchar2(3000) :=
73: ' select distinct pap.person_id
74: from pay_payroll_actions ppa,
75: per_people_f pap
76: where ppa.payroll_action_id = :payroll_action_id
77: and pap.business_group_id = ppa.business_group_id
78: order by pap.person_id ' ;
79: begin

Line 254: (c_person_id per_people_f.person_id%type)

250: and pps.person_id = paa.person_id
251: order by pps.date_start desc;
252: --
253: cursor c_employee_details
254: (c_person_id per_people_f.person_id%type)
255: is
256: select substr(pap.per_information1,1,50) legal_name, --Legal Name
257: pap.employee_number employee_number, --Employee Number
258: nvl(pap.per_information14,pap.national_identifier) cpf_number, --CPF Number/National Identifier

Line 261: from per_people_f pap,

257: pap.employee_number employee_number, --Employee Number
258: nvl(pap.per_information14,pap.national_identifier) cpf_number, --CPF Number/National Identifier
259: pap.person_id person_id, --Person ID
260: nvl(addr.telephone_number_1,nvl(addr.telephone_number_2,addr.telephone_number_3)) telephone_number
261: from per_people_f pap,
262: per_addresses addr
263: where pap.person_id = c_person_id
264: and addr.person_id (+)= pap.person_id
265: and addr.primary_flag (+)= 'Y'

Line 268: from per_people_f people1

264: and addr.person_id (+)= pap.person_id
265: and addr.primary_flag (+)= 'Y'
266: and pap.effective_start_date = (
267: select max(people1.effective_start_date)
268: from per_people_f people1
269: where people1.person_id = pap.person_id);
270: --
271: cursor month_year_action_sequence ( c_person_id per_all_people_f.person_id%type,
272: c_business_group_id hr_organization_units.business_group_id%type,