APPS.PAY_P45_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 138: FROM pay_assignment_actions act_edi,

134: 'TOWN_OR_CITY=P',
135: upper(nvl(max(decode(fue.user_entity_name,
136: 'X_TOWN_OR_CITY',
137: substr(fai.VALUE,1,35))),' '))
138: FROM pay_assignment_actions act_edi,
139: pay_action_interlocks pai,
140: pay_assignment_actions act,
141: pay_payroll_actions pact,
142: ff_archive_items fai,

Line 140: pay_assignment_actions act,

136: 'X_TOWN_OR_CITY',
137: substr(fai.VALUE,1,35))),' '))
138: FROM pay_assignment_actions act_edi,
139: pay_action_interlocks pai,
140: pay_assignment_actions act,
141: pay_payroll_actions pact,
142: ff_archive_items fai,
143: ff_user_entities fue
144: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 235: FROM pay_assignment_actions act_edi,

231: upper(nvl(max(decode(fue.user_entity_name,
232: 'X_TOWN_OR_CITY',
233: substr(fai.VALUE,1,35))),' ')),
234: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)
235: FROM pay_assignment_actions act_edi,
236: pay_action_interlocks pai,
237: pay_assignment_actions act,
238: pay_payroll_actions pact,
239: ff_archive_items fai,

Line 237: pay_assignment_actions act,

233: substr(fai.VALUE,1,35))),' ')),
234: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)
235: FROM pay_assignment_actions act_edi,
236: pay_action_interlocks pai,
237: pay_assignment_actions act,
238: pay_payroll_actions pact,
239: ff_archive_items fai,
240: ff_user_entities fue
241: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 332: FROM pay_assignment_actions act_edi,

328: upper(nvl(max(decode(fue.user_entity_name,
329: 'X_TOWN_OR_CITY',
330: substr(fai.VALUE,1,35))),' ')),
331: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)
332: FROM pay_assignment_actions act_edi,
333: pay_action_interlocks pai,
334: pay_assignment_actions act,
335: pay_payroll_actions pact,
336: ff_archive_items fai,

Line 334: pay_assignment_actions act,

330: substr(fai.VALUE,1,35))),' ')),
331: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)
332: FROM pay_assignment_actions act_edi,
333: pay_action_interlocks pai,
334: pay_assignment_actions act,
335: pay_payroll_actions pact,
336: ff_archive_items fai,
337: ff_user_entities fue
338: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value