APPS.PAY_GB_PAYE_SYNC dependencies on PER_ALL_PEOPLE_F

Line 17: l_person_id per_all_people_f.person_id%type := -1;

13: IS
14:
15: l_count number;
16:
17: l_person_id per_all_people_f.person_id%type := -1;
18: l_tax_code_id pay_input_values_f.input_value_id%type;
19: l_ele_type_id pay_element_types_f.element_type_id%type;
20: l_tax_basis_id pay_input_values_f.input_value_id%type;
21:

Line 23: l_last_person_id per_all_people_f.person_id%type := -1;

19: l_ele_type_id pay_element_types_f.element_type_id%type;
20: l_tax_basis_id pay_input_values_f.input_value_id%type;
21:
22: l_sft_coding_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
23: l_last_person_id per_all_people_f.person_id%type := -1;
24:
25: l_last_cpe_st_date date;
26:
27: l_curr_cpe_start_date date;

Line 89: FROM per_all_people_f papf

85: c_effective_date date
86: )
87: IS
88: SELECT DISTINCT papf.person_id
89: FROM per_all_people_f papf
90: ,per_periods_of_service ppos
91: WHERE ppos.person_id = papf.person_id
92: AND (papf.current_employee_flag = 'Y'
93: OR

Line 125: from per_all_people_f papf,

121: min(decode(pivf.name, 'Refundable', substr(HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',peevf.screen_entry_value),1,80),null)) Refundable,
122: hr_chkfmt.changeformat(nvl(min(decode(pivf.name, 'Pay Previous', peevf.screen_entry_value, null)), 0), 'M', 'GBP') Pay_Previous,
123: hr_chkfmt.changeformat(nvl(min(decode(pivf.name, 'Tax Previous', peevf.screen_entry_value, null)), 0), 'M', 'GBP') Tax_Previous,
124: min(decode(pivf.name, 'Authority', substr(HR_GENERAL.DECODE_LOOKUP('GB_AUTHORITY',peevf.screen_entry_value),1,80),null)) Authority
125: from per_all_people_f papf,
126: per_all_assignments_f paaf,
127: pay_element_entries_f peef,
128: pay_element_entry_values_f peevf,
129: pay_input_values_f pivf,

Line 253: from per_all_people_f pap,

249: is
250: Select paaf.assignment_id,
251: paaf.assignment_number,
252: pap.last_name
253: from per_all_people_f pap,
254: per_all_assignments_f paaf,
255: pay_all_payrolls_f papf,
256: hr_soft_coding_keyflex hsck
257: where paaf.person_id = pap.person_id

Line 661: last_name per_all_people_f.last_name%type,

657:
658: Type paye_sync_table Is Table Of paye_sync_record Index By Binary_Integer;
659:
660: TYPE db_paye_record IS RECORD(
661: last_name per_all_people_f.last_name%type,
662: person_id per_all_people_f.person_id%type,
663: assignment_id per_all_assignments_f.assignment_id%type,
664: assignment_number per_all_assignments_f.assignment_number%type,
665: payroll_id per_all_assignments_f.payroll_id%type,

Line 662: person_id per_all_people_f.person_id%type,

658: Type paye_sync_table Is Table Of paye_sync_record Index By Binary_Integer;
659:
660: TYPE db_paye_record IS RECORD(
661: last_name per_all_people_f.last_name%type,
662: person_id per_all_people_f.person_id%type,
663: assignment_id per_all_assignments_f.assignment_id%type,
664: assignment_number per_all_assignments_f.assignment_number%type,
665: payroll_id per_all_assignments_f.payroll_id%type,
666: effective_start_date pay_element_entries_f.effective_start_date%type,

Line 722: from per_all_people_f papf,

718: min(decode(inv.name, 'Authority', eev.input_value_id, null)) authority_id ,
719: min(decode(inv.name, 'Authority', eev.screen_entry_value, null)) authority_sv ,
720: min(decode(inv.name, 'Refundable', eev.input_value_id, null)) refundable_id ,
721: min(decode(inv.name, 'Refundable', eev.screen_entry_value, null)) refundable_sv
722: from per_all_people_f papf,
723: per_all_assignments_f paaf,
724: pay_element_entries_f peef,
725: pay_element_entry_values_f eev,
726: pay_input_values_f inv,