APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 22: FROM pay_payroll_actions ppa

18: ('FILE_EXTENSION=P'), RPAD(pact.action_information6, 3),
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'

Line 48: FROM pay_payroll_actions ppa

44: ('REGISTERED_NAME=P'), RPAD(NVL(pact.action_information13,' '), 55),
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'

Line 55: FROM pay_payroll_actions ppa1

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'
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'

Line 111: FROM pay_payroll_actions ppa

107: ('WORKING_DAYS=P'),LPAD(NVL(pact_tra.action_information19,'0'),3,'0'),
108: ('DAYS_PERCENT_APPLIES=P'),LPAD(NVL(pact_tra.action_information20,'0'),3,'0'),
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')