APPS.PAY_IE_ARCHIVE_DETAIL_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 124: from legislative parameters in pay_payroll_actions */

120: --
121: -------------------------------------------------------------------------
122:
123: /*FUNCTION get_parameter accepts payroll_action_id and returns parameter values
124: from legislative parameters in pay_payroll_actions */
125: --
126: FUNCTION get_parameter(p_payroll_action_id NUMBER,
127: p_token_name VARCHAR2) RETURN VARCHAR2 AS
128:

Line 131: FROM pay_payroll_actions

127: p_token_name VARCHAR2) RETURN VARCHAR2 AS
128:
129: CURSOR csr_parameter_info(p_pact_id IN NUMBER) IS
130: SELECT legislative_parameters
131: FROM pay_payroll_actions
132: WHERE payroll_action_id = p_pact_id;
133:
134: l_token_value VARCHAR2(50);
135: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;

Line 135: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;

131: FROM pay_payroll_actions
132: WHERE payroll_action_id = p_pact_id;
133:
134: l_token_value VARCHAR2(50);
135: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
136: l_delimiter varchar2(1):=' ';
137: l_start_pos NUMBER;
138: --
139:

Line 182: FROM pay_payroll_actions

178: INSTR(legislative_parameters,' ',
179: INSTR(legislative_parameters,p_token))
180: - (INSTR(legislative_parameters,p_token)+LENGTH(p_token))),
181: business_group_id
182: FROM pay_payroll_actions
183: WHERE payroll_action_id = p_pact_id;
184: l_business_group_id VARCHAR2(20);
185: l_token_value VARCHAR2(50);
186: BEGIN

Line 223: , pay_payroll_actions ppa

219: CURSOR CSR_BG_PAYPATH
220: IS
221: SELECT org.org_information8
222: FROM hr_organization_information org
223: , pay_payroll_actions ppa
224: WHERE
225: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
226: and org.organization_id = ppa.business_group_id
227: and org.org_information_context = 'IE_PAYPATH_INFORMATION'

Line 241: , pay_payroll_actions ppa

237: (SELECT to_number(segment2)
238: FROM
239: hr_soft_coding_keyflex sck
240: , pay_all_payrolls_f papf
241: , pay_payroll_actions ppa
242: WHERE
243: papf.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
244: and papf.payroll_id = pay_magtape_generic.get_parameter_value('PAYROLL_ID')
245: and papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')