APPS.PAY_GB_PAYE_SYNC dependencies on PER_ALL_ASSIGNMENTS_F

Line 126: per_all_assignments_f paaf,

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,
130: -- per_assignment_status_types past,

Line 210: per_all_assignments_f paaf,

206: pay_input_values_f inv,
207: pay_element_links_f lnk,
208: pay_element_types_f elt,
209: pay_all_payrolls_f papf,
210: per_all_assignments_f paaf,
211: hr_soft_coding_keyflex hsck
212: WHERE ele.element_entry_id = eev.element_entry_id
213: AND l_effective_date between ele.effective_start_date and ele.effective_end_date
214: AND eev.input_value_id + 0 = inv.input_value_id

Line 254: per_all_assignments_f paaf,

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
258: and paaf.person_id = c_person_id

Line 663: assignment_id per_all_assignments_f.assignment_id%type,

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,
667: effective_end_date pay_element_entries_f.effective_end_date%type,

Line 664: assignment_number per_all_assignments_f.assignment_number%type,

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,
667: effective_end_date pay_element_entries_f.effective_end_date%type,
668: cpe_start_date date,

Line 665: payroll_id per_all_assignments_f.payroll_id%type,

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,
667: effective_end_date pay_element_entries_f.effective_end_date%type,
668: cpe_start_date date,
669: eef_object_version_number pay_element_entries_f.object_version_number%type,

Line 723: per_all_assignments_f paaf,

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,
727: pay_all_payrolls_f pap,