APPS.PAY_AU_TFN_MAGTAPE_FLAGS dependencies on HR_SOFT_CODING_KEYFLEX

Line 19: p_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,

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
23:

Line 55: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,

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 /*+ ORDERED */ pee.assignment_id
59: ,decode(eev0.screen_entry_value,'YS','Y','YI','Y','YC','Y','NN','N','YN','Y','Y','Y','N','N',Null)

Line 93: hr_soft_coding_keyflex hsc,

89: 1,null,pps.actual_termination_date) actual_termination_date
90: , decode(eev0.screen_entry_value,'YS','Y','YI','Y','YC','Y','NN','N','YN','N','Y','N','N','N',Null) /*bug7270073*/
91: FROM per_people_f pap /* Bug 4925794 */
92: , per_all_assignments_f paa,/*Bug 3012794*/
93: hr_soft_coding_keyflex hsc,
94: per_periods_of_service pps
95: , pay_element_entries_f pee
96: , pay_element_types_f pet
97: , pay_input_values_f piv0

Line 239: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,

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

Line 244: hr_soft_coding_keyflex hsc,

240: c_report_end_date in date) IS
241: SELECT pee.assignment_id
242: ,pev.screen_entry_value tfn_for_super_flag
243: FROM per_assignments_f paa,
244: hr_soft_coding_keyflex hsc,
245: pay_element_entry_values_f pev,
246: pay_input_values_f piv,
247: pay_element_types_f pet,
248: pay_element_entries_f pee,