APPS.PAY_HK_IR56_MAGTAPE dependencies on PAY_MAGTAPE_GENERIC

Line 76: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

72: pay_assignment_actions paa,
73: pay_payroll_actions ppa,
74: pay_payroll_actions ppa2,
75: pay_payroll_actions ppa3
76: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
77: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
78: and fue.user_entity_id = fai.user_entity_id
79: and fue.user_entity_name like 'X_HK_IR56_%_ASG_LE_YTD'
80: and fai.context1 = paa.assignment_action_id

Line 93: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

89: from pay_payroll_actions ppa,
90: pay_payroll_actions ppa2,
91: pay_assignment_actions paa,
92: pay_payroll_actions ppa3--archive action
93: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
94: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
95: and ppa3.payroll_action_id = paa.payroll_action_id
96: and paa.action_status = 'C'
97: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters)

Line 129: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

125: pay_payroll_actions ppa3, -- Archive payroll action
126: pay_assignment_actions pac,
127: pay_assignment_actions pac3,
128: per_people_f pap
129: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
130: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
131: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters)
132: and pac.action_status = 'C'
133: and ppa3.payroll_action_id = pac.payroll_action_id