DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on PER_BUSINESS_GROUPS

Line 139: c_business_group_id in per_business_groups.business_group_id%TYPE,

135: CURSOR process_assignments
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,

Line 243: l_business_group_id per_business_groups.business_group_id%TYPE;

239: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
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

Line 331: l_business_group_id per_business_groups.business_group_id%TYPE;

327: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
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: