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 AS
2: /* $Header: pyiep35m.pkh 120.4.12010000.1 2008/07/27 22:50:10 appldev 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 30: FROM pay_payroll_actions ppa

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