DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 129: FROM pay_assignment_actions act_edi,

125: 'TOWN_OR_CITY=P',
126: upper(nvl(max(decode(fue.user_entity_name,
127: 'X_TOWN_OR_CITY',
128: substr(fai.VALUE,1,35))),' '))
129: FROM pay_assignment_actions act_edi,
130: pay_action_interlocks pai,
131: pay_assignment_actions act,
132: pay_payroll_actions pact,
133: ff_archive_items fai,

Line 131: pay_assignment_actions act,

127: 'X_TOWN_OR_CITY',
128: substr(fai.VALUE,1,35))),' '))
129: FROM pay_assignment_actions act_edi,
130: pay_action_interlocks pai,
131: pay_assignment_actions act,
132: pay_payroll_actions pact,
133: ff_archive_items fai,
134: ff_user_entities fue
135: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 226: FROM pay_assignment_actions act_edi,

222: upper(nvl(max(decode(fue.user_entity_name,
223: 'X_TOWN_OR_CITY',
224: substr(fai.VALUE,1,35))),' ')),
225: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)
226: FROM pay_assignment_actions act_edi,
227: pay_action_interlocks pai,
228: pay_assignment_actions act,
229: pay_payroll_actions pact,
230: ff_archive_items fai,

Line 228: pay_assignment_actions act,

224: substr(fai.VALUE,1,35))),' ')),
225: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)
226: FROM pay_assignment_actions act_edi,
227: pay_action_interlocks pai,
228: pay_assignment_actions act,
229: pay_payroll_actions pact,
230: ff_archive_items fai,
231: ff_user_entities fue
232: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value