DBA Data[Home] [Help]

APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_ACTION_INFORMATION

Line 31: ,pay_action_information pact

27: ('WEEKS_53=P') , decode(trim(pay_ie_p35.get_parameter(ppa.payroll_action_id,'WEEKS')),'Y','1','0'),
28: ('REQUEST_ID=P'), to_char(ppa.request_id),
29: ('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*/
30: FROM pay_payroll_actions ppa
31: ,pay_action_information pact
32:
33: WHERE pact.action_context_id = ppa.payroll_action_id
34: AND pact.action_information_category = 'ADDRESS DETAILS'
35: AND pact.action_context_type = 'PA'

Line 106: ,pay_action_information pact

102: ,pact1.action_information17 -- 5867343
103:
104: FROM
105: pay_assignment_actions paa
106: ,pay_action_information pact
107: ,pay_action_information pact1
108: ,pay_action_interlocks pai
109: WHERE
110: paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 107: ,pay_action_information pact1

103:
104: FROM
105: pay_assignment_actions paa
106: ,pay_action_information pact
107: ,pay_action_information pact1
108: ,pay_action_interlocks pai
109: WHERE
110: paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
111: and pai.locking_action_id = paa.assignment_action_id