eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 236: FROM pay_action_information pai

232: ,fnd_number.canonical_to_number(pai1.action_information8) record_count -- Format Changes for Payslip Bug - 7229247 /* 9358829 */
233: --,sum(pai1.action_information4) value
234: ,substr(pai1.action_information9,instr(pai1.action_information9,':',-1)+1) unit_price -- Format Changes in Payslip Bug - 7229247
235: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value -- Format Changes for Payslip Bug - 7229247
236: FROM pay_action_information pai
237: ,pay_action_information pai1
238: ,pay_assignment_actions paa
239: WHERE pai.action_context_type = 'PA'
240: AND pai.action_information_category = p_pa_category

Line 237: ,pay_action_information pai1

233: --,sum(pai1.action_information4) value
234: ,substr(pai1.action_information9,instr(pai1.action_information9,':',-1)+1) unit_price -- Format Changes in Payslip Bug - 7229247
235: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value -- Format Changes for Payslip Bug - 7229247
236: FROM pay_action_information pai
237: ,pay_action_information pai1
238: ,pay_assignment_actions paa
239: WHERE pai.action_context_type = 'PA'
240: AND pai.action_information_category = p_pa_category
241: AND pai1.action_context_type = 'AAP'

Line 294: FROM pay_action_information pai

290: ,pai.action_information5 type
291: ,pai.action_information6 uom
292: --,sum(pai1.action_information4) value
293: ,pai1.action_information4 value
294: FROM pay_action_information pai
295: ,pay_action_information pai1
296: ,pay_assignment_actions paa
297: WHERE pai.action_context_type = 'PA'
298: AND pai.action_information_category = p_pa_category

Line 295: ,pay_action_information pai1

291: ,pai.action_information6 uom
292: --,sum(pai1.action_information4) value
293: ,pai1.action_information4 value
294: FROM pay_action_information pai
295: ,pay_action_information pai1
296: ,pay_assignment_actions paa
297: WHERE pai.action_context_type = 'PA'
298: AND pai.action_information_category = p_pa_category
299: AND pai1.action_context_type = 'AAP'

Line 343: ,pay_action_information pai

339: --,pai.effective_date payment_date
340: ,ptp.default_dd_date payment_date
341: FROM per_time_periods ptp
342: ,pay_payrolls_f ppf
343: ,pay_action_information pai
344: WHERE ppf.payroll_id = ptp.payroll_id
345: AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
346: AND ptp.time_period_id = pai.action_information16
347: AND pai.action_context_type = 'AAP'