APPS.PAY_AU_TFN_MAGTAPE_FLAGS dependencies on PER_BUSINESS_GROUPS

Line 18: p_business_group_id in per_business_groups.business_group_id%TYPE,

14: -- values of all reportable fields and print on the matape.
15: ------------------------------------------------------------------------------+
16:
17: PROCEDURE populate_tfn_flags(p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
18: p_business_group_id in per_business_groups.business_group_id%TYPE,
19: p_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,
20: p_report_end_date in date) IS
21:
22: -- Record used store the Superannuation details of the employee

Line 54: CURSOR c_get_tfn_flag_values(c_business_group_id in per_business_groups.business_group_id%TYPE,

50:
51: /* bUG 4925794 - Modified the cursor added per_people_f and its relative joins */
52: /* Bug#5864230 moved join pee.entry_information_category = 'AU_TAX DEDUCTIONS' inside expression */
53:
54: CURSOR c_get_tfn_flag_values(c_business_group_id in per_business_groups.business_group_id%TYPE,
55: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,
56: c_report_end_date in date)
57: IS
58: SELECT pee.assignment_id

Line 239: CURSOR c_get_tfn_super_flag_value(c_business_group_id in per_business_groups.business_group_id%TYPE,

235: ----------------------------------------------------------------------------------
236:
237: /*Bug2920725 Corrected base tables to support security model*/
238:
239: CURSOR c_get_tfn_super_flag_value(c_business_group_id in per_business_groups.business_group_id%TYPE,
240: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,
241: c_report_end_date in date,
242: c_assignment_id per_assignments_f.assignment_id%TYPE ) IS
243: SELECT pee.assignment_id