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_SE_RULES dependencies on PAY_ACTION_INFORMATION

Line 4: g_custom_context pay_action_information.action_information_category%type;

1: package body PAY_SE_RULES as
2: /* $Header: pyserule.pkb 120.6.12010000.2 2008/08/06 08:18:27 ubhat ship $ */
3:
4: g_custom_context pay_action_information.action_information_category%type;
5: g_action_ctx_id NUMBER;
6:
7: -----------------------------------------------------------------------------
8: -- GET_MAIN_TAX_UNIT_ID fetches the Legal Employer Id of the Local Unit

Line 231: l_data pay_action_information.action_information1%type;

227: AND paa_xfr.assignment_action_id = g_action_ctx_id;
228:
229: l_tag_name varchar2(500);
230: l_chk_no pay_assignment_actions.serial_number%type;
231: l_data pay_action_information.action_information1%type;
232:
233: PROCEDURE LOAD_XML_INTERNAL (
234: P_NODE_TYPE varchar2,
235: P_NODE varchar2,

Line 239: l_data pay_action_information.action_information1%type;

235: P_NODE varchar2,
236: P_DATA varchar2
237: ) AS
238:
239: l_data pay_action_information.action_information1%type;
240:
241: BEGIN
242:
243: IF p_node_type = 'CS' THEN

Line 314: ,pay_action_information pai

310: ,ptp.end_date end_date
311: ,pai.effective_date payment_date
312: FROM per_time_periods ptp
313: ,pay_payrolls_f ppf
314: ,pay_action_information pai
315: WHERE ppf.payroll_id = ptp.payroll_id
316: AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
317: AND ptp.time_period_id = pai.action_information16
318: AND pai.action_context_type = 'AAP'

Line 345: FROM pay_action_information pai

341: ,SUBSTR(pai.action_information4,1,INSTR(pai.action_information4,',')-1) CODE
342: ,pai1.action_information8 record_count
343: ,substr(pai1.action_information9,instr(pai1.action_information9,':',-1)+1) unit_price
344: ,pai1.action_information4 value
345: FROM pay_action_information pai
346: ,pay_action_information pai1
347: ,pay_assignment_actions paa
348: WHERE pai.action_context_type = 'PA'
349: AND pai.action_information_category = p_pa_category

Line 346: ,pay_action_information pai1

342: ,pai1.action_information8 record_count
343: ,substr(pai1.action_information9,instr(pai1.action_information9,':',-1)+1) unit_price
344: ,pai1.action_information4 value
345: FROM pay_action_information pai
346: ,pay_action_information pai1
347: ,pay_assignment_actions paa
348: WHERE pai.action_context_type = 'PA'
349: AND pai.action_information_category = p_pa_category
350: AND pai1.action_context_type = 'AAP'

Line 388: FROM pay_action_information pai

384: ,SUBSTR(pai.action_information4,1,INSTR(pai.action_information4,',')-1) CODE
385: --,pai1.action_information8 record_count
386: --,sum(pai1.action_information4) value
387: ,pai1.action_information4 value
388: FROM pay_action_information pai
389: ,pay_action_information pai1
390: ,pay_assignment_actions paa
391: WHERE pai.action_context_type = 'PA'
392: AND pai.action_information_category = p_pa_category

Line 389: ,pay_action_information pai1

385: --,pai1.action_information8 record_count
386: --,sum(pai1.action_information4) value
387: ,pai1.action_information4 value
388: FROM pay_action_information pai
389: ,pay_action_information pai1
390: ,pay_assignment_actions paa
391: WHERE pai.action_context_type = 'PA'
392: AND pai.action_information_category = p_pa_category
393: AND pai1.action_context_type = 'AAP'

Line 422: FROM pay_action_information pai

418: ,pai.action_information5 type
419: ,pai.action_information6 uom
420: --,pai1.action_information8 record_count
421: ,sum(pai1.action_information4) value
422: FROM pay_action_information pai
423: ,pay_action_information pai1
424: ,pay_assignment_actions paa
425: WHERE pai.action_context_type = 'PA'
426: AND pai.action_information_category = p_pa_category

Line 423: ,pay_action_information pai1

419: ,pai.action_information6 uom
420: --,pai1.action_information8 record_count
421: ,sum(pai1.action_information4) value
422: FROM pay_action_information pai
423: ,pay_action_information pai1
424: ,pay_assignment_actions paa
425: WHERE pai.action_context_type = 'PA'
426: AND pai.action_information_category = p_pa_category
427: AND pai1.action_context_type = 'AAP'

Line 466: FROM pay_action_information pai

462: ,SUBSTR(pai.action_information4,1,INSTR(pai.action_information4,',')-1) CODE
463: ,pai1.action_information8 record_count
464: ,substr(pai1.action_information9,instr(pai1.action_information9,':',-1)+1) unit_price
465: ,pai1.action_information4 value
466: FROM pay_action_information pai
467: ,pay_action_information pai1
468: ,pay_assignment_actions paa
469: WHERE pai.action_context_type = 'PA'
470: AND pai.action_information_category = p_pa_category

Line 467: ,pay_action_information pai1

463: ,pai1.action_information8 record_count
464: ,substr(pai1.action_information9,instr(pai1.action_information9,':',-1)+1) unit_price
465: ,pai1.action_information4 value
466: FROM pay_action_information pai
467: ,pay_action_information pai1
468: ,pay_assignment_actions paa
469: WHERE pai.action_context_type = 'PA'
470: AND pai.action_information_category = p_pa_category
471: AND pai1.action_context_type = 'AAP'