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_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 373: pay_assignment_actions paa

369: cursor element_type_value(p_assig_act_id NUMBER) is
370: SELECT peev.screen_entry_value
371: FROM pay_element_entry_values_f peev,
372: pay_element_entries_f pee,
373: pay_assignment_actions paa
374: WHERE pee.element_entry_id = peev.element_entry_id
375: AND pee.assignment_id = paa.assignment_id
376: AND paa.assignment_action_id = p_assig_act_id
377: AND peev.input_value_id +0 = p_input_value_id

Line 420: from pay_assignment_actions

416: -- Get the child action
417: --
418: cursor get_child_action(p_assig_act_id number) is
419: select assignment_action_id
420: from pay_assignment_actions
421: where source_action_id = p_assig_act_id
422: order by action_sequence desc;
423:
424: --

Line 1958: pay_assignment_actions paa

1954:
1955: CURSOR csr_get_action_type(c_assignment_action_id number) is
1956: SELECT ppa.action_type
1957: FROM pay_payroll_actions ppa,
1958: pay_assignment_actions paa
1959: WHERE ppa.payroll_action_id = paa.payroll_action_id
1960: AND paa.assignment_action_id = c_assignment_action_id;
1961:
1962: l_calculated_employer number;

Line 2392: pay_assignment_actions paa

2388:
2389: CURSOR csr_get_action_type(c_assignment_action_id number) is
2390: SELECT ppa.action_type
2391: FROM pay_payroll_actions ppa,
2392: pay_assignment_actions paa
2393: WHERE ppa.payroll_action_id = paa.payroll_action_id
2394: AND paa.assignment_action_id = c_assignment_action_id;
2395:
2396: l_calculated_employer number;

Line 2734: from pay_assignment_actions paa,

2730: to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
2731: rpaa.payroll_action_id,
2732: rpaa.assignment_action_id,
2733: paa.assignment_action_id
2734: from pay_assignment_actions paa,
2735: pay_payroll_actions ppa,
2736: pay_assignment_actions rpaa,
2737: pay_payroll_actions rppa
2738: where paa.payroll_action_id = ppa.payroll_action_id

Line 2736: pay_assignment_actions rpaa,

2732: rpaa.assignment_action_id,
2733: paa.assignment_action_id
2734: from pay_assignment_actions paa,
2735: pay_payroll_actions ppa,
2736: pay_assignment_actions rpaa,
2737: pay_payroll_actions rppa
2738: where paa.payroll_action_id = ppa.payroll_action_id
2739: and rppa.payroll_action_id = rpaa.payroll_action_id
2740: and paa.assignment_id = rpaa.assignment_id

Line 2745: pay_assignment_actions aa

2741: and paa.assignment_action_id =
2742: (select
2743: to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
2744: from pay_payroll_actions pa,
2745: pay_assignment_actions aa
2746: where pa.action_type in ('U','P')
2747: and aa.action_status = 'C'
2748: and pa.payroll_action_id = aa.payroll_action_id
2749: and aa.assignment_id = p_assignment_id

Line 2755: from pay_assignment_actions aa,

2751: and ppa.action_type in ('P', 'U')
2752: and rpaa.assignment_id = p_assignment_id
2753: and rpaa.action_sequence =
2754: (select max(aa.action_sequence)
2755: from pay_assignment_actions aa,
2756: pay_action_interlocks loc
2757: where loc.locked_action_id = aa.assignment_action_id
2758: and loc.locking_action_id = paa.assignment_action_id);
2759:

Line 2765: FROM pay_assignment_actions paa,

2761: cursor csr_formula_2 is
2762: SELECT /*+ USE_NL(paa, ppa) */
2763: --fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) /*Bug 4775025*/
2764: to_number(substr(max(to_char(ppa.effective_date,'J')||lpad(paa.assignment_action_id,15,'0')),8))
2765: FROM pay_assignment_actions paa,
2766: pay_payroll_actions ppa
2767: WHERE
2768: paa.assignment_id = p_assignment_id
2769: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2781: pay_assignment_actions paa

2777: cursor csr_formula_3(p_assig_act_id NUMBER) is
2778: select to_char(nvl(ppa.date_earned,ppa.effective_date),'YYYY/MM/DD'),
2779: paa.payroll_action_id
2780: from pay_payroll_actions ppa,
2781: pay_assignment_actions paa
2782: where paa.assignment_action_id = p_assig_act_id
2783: and ppa.payroll_action_id = paa.payroll_action_id;
2784:
2785: cursor csr_formula_4(p_assig_act_id NUMBER) is

Line 2787: from pay_assignment_actions assact,

2783: and ppa.payroll_action_id = paa.payroll_action_id;
2784:
2785: cursor csr_formula_4(p_assig_act_id NUMBER) is
2786: select pact.action_type
2787: from pay_assignment_actions assact,
2788: pay_payroll_actions pact
2789: where assact.assignment_action_id = p_assignment_action_id
2790: and pact.payroll_action_id = assact.payroll_action_id;
2791:

Line 2794: from pay_assignment_actions assact,

2790: and pact.payroll_action_id = assact.payroll_action_id;
2791:
2792: cursor csr_formula_5(p_assig_act_id NUMBER) is
2793: select assact.assignment_action_id
2794: from pay_assignment_actions assact,
2795: pay_action_interlocks loc
2796: where loc.locking_action_id = p_assignment_action_id
2797: and assact.assignment_action_id = loc.locked_action_id
2798: order by assact.action_sequence desc;

Line 2856: from pay_assignment_actions assact,

2852: -- if the action is a prepayment return the latest run details locked
2853: cursor csr_formula is
2854: -- find what type of action this is
2855: select pact.action_type , assact.assignment_id
2856: from pay_assignment_actions assact,
2857: pay_payroll_actions pact
2858: where assact.assignment_action_id = p_assignment_action_id
2859: and pact.payroll_action_id = assact.payroll_action_id
2860: ;

Line 2864: from pay_assignment_actions assact,

2860: ;
2861: cursor csr_formula_2 is
2862: -- for prepayment action find the latest interlocked run
2863: select assact.assignment_action_id
2864: from pay_assignment_actions assact,
2865: pay_action_interlocks loc
2866: where loc.locking_action_id = p_assignment_action_id
2867: and assact.assignment_action_id = loc.locked_action_id
2868: order by assact.action_sequence desc

Line 2873: from pay_assignment_actions assact,

2869: ;
2870: cursor csr_formula_3 is
2871: -- for run action check if its been prepaid
2872: select assact.assignment_action_id
2873: from pay_assignment_actions assact,
2874: pay_payroll_actions pact,
2875: pay_action_interlocks loc
2876: where loc.locked_action_id = p_assignment_action_id
2877: and assact.assignment_action_id = loc.locking_action_id

Line 2886: from pay_assignment_actions assact,

2882: cursor csr_formula_4 is
2883: -- now find the date earned and payroll action of the run action
2884: select pact.payroll_action_id,
2885: to_char(nvl(pact.date_earned,pact.effective_date),'YYYY/MM/DD')
2886: from pay_assignment_actions assact,
2887: pay_payroll_actions pact
2888: where assact.assignment_action_id = p_run_assignment_action_id
2889: and pact.payroll_action_id = assact.payroll_action_id
2890: ;

Line 2946: -- from pay_assignment_actions paa,

2942: -- rpaa.payroll_action_id,
2943: -- rpaa.assignment_id,
2944: -- rpaa.assignment_action_id,
2945: -- paa.assignment_action_id
2946: -- from pay_assignment_actions paa,
2947: -- pay_payroll_actions ppa,
2948: -- pay_assignment_actions rpaa,
2949: -- pay_payroll_actions rppa
2950: -- where paa.payroll_action_id = ppa.payroll_action_id

Line 2948: -- pay_assignment_actions rpaa,

2944: -- rpaa.assignment_action_id,
2945: -- paa.assignment_action_id
2946: -- from pay_assignment_actions paa,
2947: -- pay_payroll_actions ppa,
2948: -- pay_assignment_actions rpaa,
2949: -- pay_payroll_actions rppa
2950: -- where paa.payroll_action_id = ppa.payroll_action_id
2951: -- and rppa.payroll_action_id = rpaa.payroll_action_id
2952: -- and paa.assignment_action_id = p_assignment_action_id

Line 2959: -- from pay_assignment_actions aa,

2955: -- and rpaa.assignment_action_id = p_assignment_action_id
2956: -- or ( ppa.action_type in ('P', 'U')
2957: -- and rpaa.action_sequence =
2958: -- (select max(aa.action_sequence)
2959: -- from pay_assignment_actions aa,
2960: -- pay_action_interlocks loc
2961: -- where loc.locked_action_id = aa.assignment_action_id
2962: -- and loc.locking_action_id = p_assignment_action_id)))
2963: --;