APPS.PAY_AU_TFN_MAGTAPE dependencies on HR_SOFT_CODING_KEYFLEX

Line 138: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,

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

Line 147: ,hr_soft_coding_keyflex hsc

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

Line 254: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;

250: FROM pay_payroll_actions ppa
251: WHERE ppa.payroll_action_id = c_payroll_action_id;
252:
253: l_business_group_id per_business_groups.business_group_id%TYPE;
254: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;
255: l_report_end_date date;
256:
257: CURSOR next_action_id IS
258: SELECT pay_assignment_actions_s.nextval

Line 342: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;

338: FROM pay_payroll_actions ppa
339: WHERE ppa.payroll_action_id = c_payroll_action_id;
340:
341: l_business_group_id per_business_groups.business_group_id%TYPE;
342: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;
343: l_report_end_date date;
344:
345:
346: BEGIN