DBA Data[Home] [Help]

APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_MAGTAPE_GENERIC

Line 15: SELECT ('P35_MODE=P'), trim(pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'MODE')),

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 ,

Line 28: ('WEEKS_53=P') , decode(trim(pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'WEEKS')),'Y','1','0'), --8233782

24: ('CONTACT_NAME=P'), pact.action_information27 ,
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: ('WEEKS_53=P') , decode(trim(pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'WEEKS')),'Y','1','0'), --8233782
29: ('REQUEST_ID=P'), to_char(ppa.request_id),
30: ('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*/
31: FROM pay_payroll_actions ppa
32: ,pay_action_information pact

Line 30: ('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*/

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: ('WEEKS_53=P') , decode(trim(pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'WEEKS')),'Y','1','0'), --8233782
29: ('REQUEST_ID=P'), to_char(ppa.request_id),
30: ('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*/
31: FROM pay_payroll_actions ppa
32: ,pay_action_information pact
33:
34: WHERE pact.action_context_id = ppa.payroll_action_id

Line 42: where mag_paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

38: (select max(arc_paa.payroll_action_id) from
39: pay_assignment_actions mag_paa,
40: pay_assignment_actions arc_paa,
41: pay_action_interlocks pai
42: where mag_paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
43: and pai.locking_action_id = mag_paa.assignment_action_id
44: and arc_paa.assignment_action_id= pai.locked_action_id)
45: --16210193
46: AND EXISTS ( SELECT 1 FROM PAY_ASSIGNMENT_ACTIONS PAA

Line 48: AND PAA.TAX_UNIT_ID = pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'EMP_NO'));

44: and arc_paa.assignment_action_id= pai.locked_action_id)
45: --16210193
46: AND EXISTS ( SELECT 1 FROM PAY_ASSIGNMENT_ACTIONS PAA
47: WHERE PAA.payroll_action_id = ppa.payroll_action_id
48: AND PAA.TAX_UNIT_ID = pay_ie_p35.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'EMP_NO'));
49: --16210193
50:
51: /* Modified the cursor for BUG 2987230 */
52: CURSOR CSR_P35_DETAIL IS

Line 132: paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

128: ,pay_action_information pact
129: ,pay_action_information pact1
130: ,pay_action_interlocks pai
131: WHERE
132: paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
133: and pai.locking_action_id = paa.assignment_action_id
134: and paa.source_action_id is null
135: and pact.action_context_id = pai.locked_action_id
136: and pact.action_information_category = 'IE P35 DETAIL'