APPS.PAY_AU_TFN_MAGTAPE dependencies on HR_SOFT_CODING_KEYFLEX

Line 140: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,

136: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
137: c_start_person_id in per_all_people_f.person_id%TYPE,
138: c_end_person_id in per_all_people_f.person_id%TYPE,
139: c_business_group_id in per_business_groups.business_group_id%TYPE,
140: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,
141: c_report_end_date in date) IS
142: SELECT /*+ STAR_TRANSFORMATION */ paa.assignment_id,
143: decode(sign(nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) - c_report_end_date),1,
144: null,pps.actual_termination_date) actual_termination_date,

Line 149: ,hr_soft_coding_keyflex hsc

145: peev.screen_entry_value tax_file_number
146: FROM pay_payroll_actions ppa
147: ,per_people_f pap
148: ,per_assignments_f paa
149: ,hr_soft_coding_keyflex hsc
150: ,per_periods_of_service pps
151: ,pay_element_entries_f pee
152: ,pay_element_links_f pel
153: ,pay_element_types_f pet

Line 244: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;

240: FROM pay_payroll_actions ppa
241: WHERE ppa.payroll_action_id = c_payroll_action_id;
242:
243: l_business_group_id per_business_groups.business_group_id%TYPE;
244: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;
245: l_report_end_date date;
246:
247: CURSOR next_action_id IS
248: SELECT pay_assignment_actions_s.nextval

Line 332: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;

328: FROM pay_payroll_actions ppa
329: WHERE ppa.payroll_action_id = c_payroll_action_id;
330:
331: l_business_group_id per_business_groups.business_group_id%TYPE;
332: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;
333: l_report_end_date date;
334:
335:
336: BEGIN