APPS.PAY_AE_RULES dependencies on PAY_ACTION_INFORMATION

Line 4: g_custom_context pay_action_information.action_information_category%type;

1: PACKAGE BODY PAY_AE_RULES AS
2: /* $Header: pyaerule.pkb 120.1 2006/05/24 12:53:17 spendhar noship $ */
3:
4: g_custom_context pay_action_information.action_information_category%type;
5: g_action_ctx_id NUMBER;
6:
7: -------------------------------------------------------------------------------
8: -- flex_seg_enabled

Line 69: l_data pay_action_information.action_information1%type;

65: AND paa_xfr.assignment_action_id = g_action_ctx_id;
66:
67: l_tag_name varchar2(500);
68: l_chk_no pay_assignment_actions.serial_number%type;
69: l_data pay_action_information.action_information1%type;
70:
71: PROCEDURE LOAD_XML_INTERNAL (
72: P_NODE_TYPE varchar2,
73: P_NODE varchar2,

Line 77: l_data pay_action_information.action_information1%type;

73: P_NODE varchar2,
74: P_DATA varchar2
75: ) AS
76:
77: l_data pay_action_information.action_information1%type;
78:
79: BEGIN
80:
81: IF p_node_type = 'CS' THEN

Line 150: ,pay_action_information pai

146: ,ptp.end_date end_date
147: ,pai.effective_date payment_date
148: FROM per_time_periods ptp
149: ,pay_payrolls_f ppf
150: ,pay_action_information pai
151: WHERE ppf.payroll_id = ptp.payroll_id
152: AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
153: AND ptp.time_period_id = pai.action_information16
154: AND pai.action_context_type = 'AAP'

Line 172: FROM pay_action_information pai

168: pai.action_information4||'('||pai1.action_information8||')') Name
169: ,pai.action_information5 type
170: ,pai.action_information6 uom
171: ,sum(pai1.action_information4) value
172: FROM pay_action_information pai
173: ,pay_action_information pai1
174: ,pay_assignment_actions paa
175: WHERE pai.action_context_type = 'PA'
176: AND pai.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 173: ,pay_action_information pai1

169: ,pai.action_information5 type
170: ,pai.action_information6 uom
171: ,sum(pai1.action_information4) value
172: FROM pay_action_information pai
173: ,pay_action_information pai1
174: ,pay_assignment_actions paa
175: WHERE pai.action_context_type = 'PA'
176: AND pai.action_information_category = 'EMEA ELEMENT DEFINITION'
177: AND pai1.action_context_type = 'AAP'

Line 208: FROM pay_action_information pai

204: pai.action_information4||'('||pai1.action_information8||')') Name
205: ,pai.action_information5 type
206: ,pai.action_information6 uom
207: ,pai1.action_information4 value
208: FROM pay_action_information pai
209: ,pay_action_information pai1
210: ,pay_assignment_actions paa
211: WHERE pai.action_context_type = 'PA'
212: AND pai.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 209: ,pay_action_information pai1

205: ,pai.action_information5 type
206: ,pai.action_information6 uom
207: ,pai1.action_information4 value
208: FROM pay_action_information pai
209: ,pay_action_information pai1
210: ,pay_assignment_actions paa
211: WHERE pai.action_context_type = 'PA'
212: AND pai.action_information_category = 'EMEA ELEMENT DEFINITION'
213: AND pai1.action_context_type = 'AAP'

Line 249: FROM pay_action_information pai

245: ,pai.action_information2 defined_balance_id
246: ,pai.action_information6 type
247: ,pai1.action_information4 value
248: ,pai1.action_information6 uom
249: FROM pay_action_information pai
250: ,pay_action_information pai1
251: ,pay_assignment_actions paa
252: WHERE pai.action_context_type = 'PA'
253: AND pai.action_information_category = 'EMEA BALANCE DEFINITION'

Line 250: ,pay_action_information pai1

246: ,pai.action_information6 type
247: ,pai1.action_information4 value
248: ,pai1.action_information6 uom
249: FROM pay_action_information pai
250: ,pay_action_information pai1
251: ,pay_assignment_actions paa
252: WHERE pai.action_context_type = 'PA'
253: AND pai.action_information_category = 'EMEA BALANCE DEFINITION'
254: AND pai1.action_context_type = 'AAP'