APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PAY_ACTION_INFORMATION

Line 23: ,pay_action_information pact

19: ('TEST_FLAG=P'), pact.action_information8,
20: ('CURRENT_PASSWORD=P'), RPAD(NVL(pact.action_information9,' '), 8),
21: ('NEW_PASSWORD=P'), RPAD(NVL(pact.action_information10,' '), 8)
22: FROM pay_payroll_actions ppa
23: ,pay_action_information pact
24: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
25: AND pact.action_context_id = ppa.payroll_action_id
26: AND pact.action_information_category = 'ES_SS_REPORT_ETI'
27: AND pact.action_context_type = 'PA'

Line 49: ,pay_action_information pact

45: ('START_DATE=P'), LPAD(NVL(pact.action_information14,'0'),8,'0'),
46: ('END_DATE=P'), LPAD(NVL(pact.action_information15,'0'),8,'0'),
47: ('ORG_ID=P'),pact.action_information16
48: FROM pay_payroll_actions ppa
49: ,pay_action_information pact
50: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
51: AND pact.action_context_id = ppa.payroll_action_id
52: AND pact.action_information_category = 'ES_SS_REPORT_EMP'
53: AND pact.action_context_type = 'PA'

Line 56: ,pay_action_information pact_tra

52: AND pact.action_information_category = 'ES_SS_REPORT_EMP'
53: AND pact.action_context_type = 'PA'
54: AND EXISTS ( SELECT 1
55: FROM pay_payroll_actions ppa1
56: ,pay_action_information pact_tra
57: ,pay_assignment_actions paa1
58: WHERE ppa1.payroll_action_id = ppa.payroll_action_id
59: AND pact_tra.action_information_category = 'ES_SS_REPORT_TRA'
60: AND pact_tra.action_context_type = 'AAP'

Line 113: ,pay_action_information pact_tra

109: ('RETIREMENT_REDUCTION_PERCENT=P'),LPAD(NVL(pact_tra.action_information21,'0'),2,'0'),
110: ('TEST_FLAG=P'),pact_tra.action_information22 -- not used
111: FROM pay_payroll_actions ppa
112: ,pay_assignment_actions paa
113: ,pay_action_information pact_tra
114: ,pay_action_information pact_fab
115: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
116: AND paa.payroll_action_id = ppa.payroll_action_id
117: AND pact_tra.action_context_id = paa.assignment_action_id

Line 114: ,pay_action_information pact_fab

110: ('TEST_FLAG=P'),pact_tra.action_information22 -- not used
111: FROM pay_payroll_actions ppa
112: ,pay_assignment_actions paa
113: ,pay_action_information pact_tra
114: ,pay_action_information pact_fab
115: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
116: AND paa.payroll_action_id = ppa.payroll_action_id
117: AND pact_tra.action_context_id = paa.assignment_action_id
118: AND pact_fab.action_context_id = paa.assignment_action_id