APPS.PAY_US_MMREF_LOCAL_XML dependencies on PAY_ASSIGNMENT_ACTIONS

Line 116: pay_assignment_actions aa

112: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
113: 'TAX_UNIT_NAME=P', hou.name
114: FROM hr_all_organization_units hou,
115: pay_payroll_actions ppa,
116: pay_assignment_actions aa
117: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
118: ('TRANSFER_PAYROLL_ACTION_ID')
119: AND ppa.report_type = 'YREND'
120: AND to_char(ppa.effective_date, 'YYYY') =

Line 147: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions

143: ff_archive_item_contexts FAIC,
144: per_all_people_f PE,
145: per_all_assignments_f SS,
146: pay_action_interlocks AI,
147: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
148: pay_assignment_actions AA,
149: pay_payroll_actions PA
150: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
151: ('TRANSFER_PAYROLL_ACTION_ID')

Line 148: pay_assignment_actions AA,

144: per_all_people_f PE,
145: per_all_assignments_f SS,
146: pay_action_interlocks AI,
147: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
148: pay_assignment_actions AA,
149: pay_payroll_actions PA
150: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
151: ('TRANSFER_PAYROLL_ACTION_ID')
152: AND AA.payroll_action_id = PA.payroll_action_id

Line 206: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions

202: ff_archive_item_contexts FAIC,
203: per_all_people_f PE,
204: per_all_assignments_f SS,
205: pay_action_interlocks AI,
206: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
207: pay_assignment_actions AA,
208: pay_payroll_actions PA
209: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
210: ('TRANSFER_PAYROLL_ACTION_ID')

Line 207: pay_assignment_actions AA,

203: per_all_people_f PE,
204: per_all_assignments_f SS,
205: pay_action_interlocks AI,
206: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
207: pay_assignment_actions AA,
208: pay_payroll_actions PA
209: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
210: ('TRANSFER_PAYROLL_ACTION_ID')
211: AND AA.payroll_action_id = PA.payroll_action_id

Line 309: FROM pay_assignment_actions paa

305: FROM DUAL;
306:
307: CURSOR LOCAL_MAG_ASG_ACT IS
308: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
309: FROM pay_assignment_actions paa
310: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value(
311: 'TRANSFER_PAYROLL_ACTION_ID');
312: --
313: -- Follwing Procedures are used for constructing XML for Submitter or RA Record