APPS.PAY_AU_TFN_MAGTAPE dependencies on PER_BUSINESS_GROUPS

Line 137: c_business_group_id in per_business_groups.business_group_id%TYPE,

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

Line 253: l_business_group_id per_business_groups.business_group_id%TYPE;

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

Line 341: l_business_group_id per_business_groups.business_group_id%TYPE;

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