[Home] [Help]
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'
28: AND ROWNUM < 2;
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'
54: AND EXISTS ( SELECT 1
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
119: AND pact_tra.action_context_id = pact_fab.action_context_id
120: AND pact_tra.action_information_category = 'ES_SS_REPORT_TRA'
121: AND pact_fab.action_information_category = 'ES_SS_REPORT_FAB'
122: AND pact_tra.action_context_type = 'AAP'
123: AND pact_fab.action_context_type = 'AAP'
124: AND pact_tra.action_information11 = pay_magtape_generic.get_parameter_value('ORG_ID')
125: ORDER BY pact_fab.action_information1;
126: --------------------------------------------------------------------------------
127: FUNCTION get_parameter (
128: p_parameter_string IN VARCHAR2