APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_PAYROLL_ACTIONS

Line 4: l_arc_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

1: PACKAGE PAY_IE_P35_MAGTAPE AUTHID CURRENT_USER AS
2: /* $Header: pyiep35m.pkh 120.8.12020000.4 2013/02/04 11:46:54 rsahai ship $ */
3:
4: l_arc_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
5: level_cnt NUMBER;
6:
7: FUNCTION get_parameter(p_payroll_action_id IN NUMBER,
8: p_token_name IN VARCHAR2) RETURN VARCHAR2;

Line 31: FROM pay_payroll_actions ppa

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
35: AND pact.action_information_category = 'ADDRESS DETAILS'