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 365: pay_assignment_actions paa

361: cursor element_type_value(p_assig_act_id NUMBER) is
362: SELECT peev.screen_entry_value
363: FROM pay_element_entry_values_f peev,
364: pay_element_entries_f pee,
365: pay_assignment_actions paa
366: WHERE pee.element_entry_id = peev.element_entry_id
367: AND pee.assignment_id = paa.assignment_id
368: AND paa.assignment_action_id = p_assig_act_id
369: AND peev.input_value_id +0 = p_input_value_id

Line 412: from pay_assignment_actions

408: -- Get the child action
409: --
410: cursor get_child_action(p_assig_act_id number) is
411: select assignment_action_id
412: from pay_assignment_actions
413: where source_action_id = p_assig_act_id
414: order by action_sequence desc;
415:
416: --

Line 1933: pay_assignment_actions paa

1929:
1930: CURSOR csr_get_action_type(c_assignment_action_id number) is
1931: SELECT ppa.action_type
1932: FROM pay_payroll_actions ppa,
1933: pay_assignment_actions paa
1934: WHERE ppa.payroll_action_id = paa.payroll_action_id
1935: AND paa.assignment_action_id = c_assignment_action_id;
1936:
1937: l_calculated_employer number;

Line 2333: from pay_assignment_actions paa,

2329: to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
2330: rpaa.payroll_action_id,
2331: rpaa.assignment_action_id,
2332: paa.assignment_action_id
2333: from pay_assignment_actions paa,
2334: pay_payroll_actions ppa,
2335: pay_assignment_actions rpaa,
2336: pay_payroll_actions rppa
2337: where paa.payroll_action_id = ppa.payroll_action_id

Line 2335: pay_assignment_actions rpaa,

2331: rpaa.assignment_action_id,
2332: paa.assignment_action_id
2333: from pay_assignment_actions paa,
2334: pay_payroll_actions ppa,
2335: pay_assignment_actions rpaa,
2336: pay_payroll_actions rppa
2337: where paa.payroll_action_id = ppa.payroll_action_id
2338: and rppa.payroll_action_id = rpaa.payroll_action_id
2339: and paa.assignment_id = rpaa.assignment_id

Line 2344: pay_assignment_actions aa

2340: and paa.assignment_action_id =
2341: (select
2342: to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
2343: from pay_payroll_actions pa,
2344: pay_assignment_actions aa
2345: where pa.action_type in ('U','P')
2346: and aa.action_status = 'C'
2347: and pa.payroll_action_id = aa.payroll_action_id
2348: and aa.assignment_id = p_assignment_id

Line 2354: from pay_assignment_actions aa,

2350: and ppa.action_type in ('P', 'U')
2351: and rpaa.assignment_id = p_assignment_id
2352: and rpaa.action_sequence =
2353: (select max(aa.action_sequence)
2354: from pay_assignment_actions aa,
2355: pay_action_interlocks loc
2356: where loc.locked_action_id = aa.assignment_action_id
2357: and loc.locking_action_id = paa.assignment_action_id);
2358:

Line 2364: FROM pay_assignment_actions paa,

2360: cursor csr_formula_2 is
2361: SELECT /*+ USE_NL(paa, ppa) */
2362: --fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) /*Bug 4775025*/
2363: to_number(substr(max(to_char(ppa.effective_date,'J')||lpad(paa.assignment_action_id,15,'0')),8))
2364: FROM pay_assignment_actions paa,
2365: pay_payroll_actions ppa
2366: WHERE
2367: paa.assignment_id = p_assignment_id
2368: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2380: pay_assignment_actions paa

2376: cursor csr_formula_3(p_assig_act_id NUMBER) is
2377: select to_char(nvl(ppa.date_earned,ppa.effective_date),'YYYY/MM/DD'),
2378: paa.payroll_action_id
2379: from pay_payroll_actions ppa,
2380: pay_assignment_actions paa
2381: where paa.assignment_action_id = p_assig_act_id
2382: and ppa.payroll_action_id = paa.payroll_action_id;
2383:
2384: cursor csr_formula_4(p_assig_act_id NUMBER) is

Line 2386: from pay_assignment_actions assact,

2382: and ppa.payroll_action_id = paa.payroll_action_id;
2383:
2384: cursor csr_formula_4(p_assig_act_id NUMBER) is
2385: select pact.action_type
2386: from pay_assignment_actions assact,
2387: pay_payroll_actions pact
2388: where assact.assignment_action_id = p_assignment_action_id
2389: and pact.payroll_action_id = assact.payroll_action_id;
2390:

Line 2393: from pay_assignment_actions assact,

2389: and pact.payroll_action_id = assact.payroll_action_id;
2390:
2391: cursor csr_formula_5(p_assig_act_id NUMBER) is
2392: select assact.assignment_action_id
2393: from pay_assignment_actions assact,
2394: pay_action_interlocks loc
2395: where loc.locking_action_id = p_assignment_action_id
2396: and assact.assignment_action_id = loc.locked_action_id
2397: order by assact.action_sequence desc;

Line 2455: from pay_assignment_actions assact,

2451: -- if the action is a prepayment return the latest run details locked
2452: cursor csr_formula is
2453: -- find what type of action this is
2454: select pact.action_type , assact.assignment_id
2455: from pay_assignment_actions assact,
2456: pay_payroll_actions pact
2457: where assact.assignment_action_id = p_assignment_action_id
2458: and pact.payroll_action_id = assact.payroll_action_id
2459: ;

Line 2463: from pay_assignment_actions assact,

2459: ;
2460: cursor csr_formula_2 is
2461: -- for prepayment action find the latest interlocked run
2462: select assact.assignment_action_id
2463: from pay_assignment_actions assact,
2464: pay_action_interlocks loc
2465: where loc.locking_action_id = p_assignment_action_id
2466: and assact.assignment_action_id = loc.locked_action_id
2467: order by assact.action_sequence desc

Line 2472: from pay_assignment_actions assact,

2468: ;
2469: cursor csr_formula_3 is
2470: -- for run action check if its been prepaid
2471: select assact.assignment_action_id
2472: from pay_assignment_actions assact,
2473: pay_payroll_actions pact,
2474: pay_action_interlocks loc
2475: where loc.locked_action_id = p_assignment_action_id
2476: and assact.assignment_action_id = loc.locking_action_id

Line 2485: from pay_assignment_actions assact,

2481: cursor csr_formula_4 is
2482: -- now find the date earned and payroll action of the run action
2483: select pact.payroll_action_id,
2484: to_char(nvl(pact.date_earned,pact.effective_date),'YYYY/MM/DD')
2485: from pay_assignment_actions assact,
2486: pay_payroll_actions pact
2487: where assact.assignment_action_id = p_run_assignment_action_id
2488: and pact.payroll_action_id = assact.payroll_action_id
2489: ;

Line 2545: -- from pay_assignment_actions paa,

2541: -- rpaa.payroll_action_id,
2542: -- rpaa.assignment_id,
2543: -- rpaa.assignment_action_id,
2544: -- paa.assignment_action_id
2545: -- from pay_assignment_actions paa,
2546: -- pay_payroll_actions ppa,
2547: -- pay_assignment_actions rpaa,
2548: -- pay_payroll_actions rppa
2549: -- where paa.payroll_action_id = ppa.payroll_action_id

Line 2547: -- pay_assignment_actions rpaa,

2543: -- rpaa.assignment_action_id,
2544: -- paa.assignment_action_id
2545: -- from pay_assignment_actions paa,
2546: -- pay_payroll_actions ppa,
2547: -- pay_assignment_actions rpaa,
2548: -- pay_payroll_actions rppa
2549: -- where paa.payroll_action_id = ppa.payroll_action_id
2550: -- and rppa.payroll_action_id = rpaa.payroll_action_id
2551: -- and paa.assignment_action_id = p_assignment_action_id

Line 2558: -- from pay_assignment_actions aa,

2554: -- and rpaa.assignment_action_id = p_assignment_action_id
2555: -- or ( ppa.action_type in ('P', 'U')
2556: -- and rpaa.action_sequence =
2557: -- (select max(aa.action_sequence)
2558: -- from pay_assignment_actions aa,
2559: -- pay_action_interlocks loc
2560: -- where loc.locked_action_id = aa.assignment_action_id
2561: -- and loc.locking_action_id = p_assignment_action_id)))
2562: --;