DBA Data[Home] [Help]

APPS.PAY_GB_WNU_EDI dependencies on PAY_ASSIGNMENT_ACTIONS

Line 86: from pay_assignment_actions paa,

82: 'LAST_NAME=P', nvl(upper(substr(pai_emp.action_information8,1,35)),' '),
83: 'MIDDLE_NAME=P', nvl(substr(upper(pai_emp.action_information7),1,35),' '),
84: 'NATIONAL_INSURANCE_NUMBER=P', nvl(upper(pai_emp.action_information12),'NONE'),
85: 'TITLE=P', nvl(upper(pai_emp.action_information14),' ')
86: from pay_assignment_actions paa,
87: pay_action_information pai_emp,
88: pay_action_information pai_wnu
89: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
90: and paa.assignment_action_id = pai_emp.action_context_id

Line 108: from pay_assignment_actions paa,

104: 'LAST_NAME=P', nvl(upper(substr(pai_emp.action_information8,1,35)),' '),
105: 'MIDDLE_NAME=P', nvl(substr(upper(pai_emp.action_information7),1,35),' '),
106: 'NATIONAL_INSURANCE_NUMBER=P', nvl(upper(pai_emp.action_information12),'NONE'),
107: 'TITLE=P', nvl(upper(pai_emp.action_information14),' ')
108: from pay_assignment_actions paa,
109: pay_action_information pai_emp,
110: pay_action_information pai_wnu
111: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
112: and paa.assignment_action_id = pai_emp.action_context_id