DBA Data[Home] [Help]

APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_ACTION_INFORMATION

Line 32: ,pay_action_information pact

28: ('WEEKS_53=P') , decode(trim(pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'WEEKS')),'Y','1','0'), --8233782
29: ('REQUEST_ID=P'), to_char(ppa.request_id),
30: ('SUBMISSION_TYPE=P'),pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'SUB_TYPE') /*Added for bug fix 3815830*/
31: FROM pay_payroll_actions ppa
32: ,pay_action_information pact
33:
34: WHERE pact.action_context_id = ppa.payroll_action_id
35: AND pact.action_information_category = 'ADDRESS DETAILS'
36: AND pact.action_context_type = 'PA'

Line 128: ,pay_action_information pact

124: --14656910
125:
126: FROM
127: pay_assignment_actions paa
128: ,pay_action_information pact
129: ,pay_action_information pact1
130: ,pay_action_interlocks pai
131: WHERE
132: paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 129: ,pay_action_information pact1

125:
126: FROM
127: pay_assignment_actions paa
128: ,pay_action_information pact
129: ,pay_action_information pact1
130: ,pay_action_interlocks pai
131: WHERE
132: paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
133: and pai.locking_action_id = paa.assignment_action_id