APPS.PAY_DK_RULES dependencies on PAY_ACTION_INFORMATION

Line 141: l_data pay_action_information.action_information1%TYPE;

137: AND descriptive_flex_context_code = p_context_code
138: AND application_column_name = UPPER (p_node);
139: --
140: l_tag_name VARCHAR2(500);
141: l_data pay_action_information.action_information1%TYPE;
142: l_node pay_action_information.action_information1%TYPE;
143: --
144: BEGIN
145: --

Line 142: l_node pay_action_information.action_information1%TYPE;

138: AND application_column_name = UPPER (p_node);
139: --
140: l_tag_name VARCHAR2(500);
141: l_data pay_action_information.action_information1%TYPE;
142: l_node pay_action_information.action_information1%TYPE;
143: --
144: BEGIN
145: --
146: IF p_node_type = 'CS' THEN

Line 229: FROM pay_action_information pai

225: ,pai.action_information6 uom
226: --,pai1.action_information8 record_count
227: --,sum(pai1.action_information4) value
228: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value
229: FROM pay_action_information pai
230: ,pay_action_information pai1
231: ,pay_assignment_actions paa
232: WHERE pai.action_context_type = 'PA'
233: AND pai.action_information_category = p_pa_category

Line 230: ,pay_action_information pai1

226: --,pai1.action_information8 record_count
227: --,sum(pai1.action_information4) value
228: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value
229: FROM pay_action_information pai
230: ,pay_action_information pai1
231: ,pay_assignment_actions paa
232: WHERE pai.action_context_type = 'PA'
233: AND pai.action_information_category = p_pa_category
234: AND pai1.action_context_type = 'AAP'

Line 277: FROM pay_action_information pai

273: ,pai.action_information6 uom
274: --,pai1.action_information8 record_count
275: --,sum(pai1.action_information4) value
276: ,pai1.action_information4 value
277: FROM pay_action_information pai
278: ,pay_action_information pai1
279: ,pay_assignment_actions paa
280: WHERE pai.action_context_type = 'PA'
281: AND pai.action_information_category = p_pa_category

Line 278: ,pay_action_information pai1

274: --,pai1.action_information8 record_count
275: --,sum(pai1.action_information4) value
276: ,pai1.action_information4 value
277: FROM pay_action_information pai
278: ,pay_action_information pai1
279: ,pay_assignment_actions paa
280: WHERE pai.action_context_type = 'PA'
281: AND pai.action_information_category = p_pa_category
282: AND pai1.action_context_type = 'AAP'

Line 325: ,pay_action_information pai

321: --,pai.effective_date payment_date
322: ,ptp.default_dd_date payment_date
323: FROM per_time_periods ptp
324: ,pay_payrolls_f ppf
325: ,pay_action_information pai
326: WHERE ppf.payroll_id = ptp.payroll_id
327: AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
328: AND ptp.time_period_id = pai.action_information16
329: AND pai.action_context_type = 'AAP'