[Home] [Help]
11:
12: FUNCTION get_end_date RETURN DATE;
13:
14: CURSOR CSR_P35_HEADER_FOOTER IS
15: SELECT ('P35_MODE=P'), trim(pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'MODE')),
16: ('END_DATE=P'), pay_ie_p35.get_parameter(ppa.payroll_action_id,'END_DATE'),
17: ('EFFECTIVE_DATE=P'),to_char(ppa.effective_date,'dd-mm-yyyy'),
18: ('EMPLOYER_NUMBER=P'), pact.action_information1,
19: ('EMPLOYER_NAME=P'), pact.action_information26 ,
25: ('CONTACT_NUMBER=P'), pact.action_information28 ,
26: ('FAX_NO=P'), pact.action_information10,
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
37: (select max(arc_paa.payroll_action_id) from
38: pay_assignment_actions mag_paa,
39: pay_assignment_actions arc_paa,
40: pay_action_interlocks pai
41: where mag_paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
42: and pai.locking_action_id = mag_paa.assignment_action_id
43: and arc_paa.assignment_action_id= pai.locked_action_id);
44:
45: /* Modified the cursor for BUG 2987230 */
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
112: and paa.source_action_id is null
113: and pact.action_context_id = pai.locked_action_id
114: and pact.action_information_category = 'IE P35 DETAIL'