APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 19: G_PAYROLL_ACTION_ID pay_payroll_actions.payroll_action_id%type;

15: G_NI_CATEGORY_ITEM varchar2(40) := 'NI_CATEGORY_ENTRY_VALUE';
16: --G_TAX_PHONE_NUM varchar2(40) := 'SCL_PAY_GB_TAX_OFFICE_PHONE_NUMBER';
17:
18: -- variables used for cache values
19: G_PAYROLL_ACTION_ID pay_payroll_actions.payroll_action_id%type;
20: G_TAX_PHONE hr_organization_information.org_information8%type;
21: --
22: -- Balance Items
23: --

Line 586: pay_payroll_actions pact,

582: -- cache the value that doesn't change unless payroll action changes
583: if nvl(g_payroll_action_id,-1) <> p_payroll_action_id then
584: select max(org_information8) into g_tax_phone
585: from pay_payrolls_f p,
586: pay_payroll_actions pact,
587: hr_soft_coding_keyflex flex,
588: hr_organization_information org
589: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
590: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'

Line 1932: FROM pay_payroll_actions ppa,

1928: AND row_name = pbt.balance_name || pbd.database_item_suffix;
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:

Line 2334: pay_payroll_actions ppa,

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
2338: and rppa.payroll_action_id = rpaa.payroll_action_id

Line 2336: pay_payroll_actions rppa

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
2340: and paa.assignment_action_id =

Line 2343: from pay_payroll_actions pa,

2339: and paa.assignment_id = rpaa.assignment_id
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

Line 2365: pay_payroll_actions ppa

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
2369: /* Commented below code, removed action_types 'B' and 'I' for bug fix 4775025*/

Line 2379: from pay_payroll_actions ppa,

2375:
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:

Line 2387: pay_payroll_actions pact

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:
2391: cursor csr_formula_5(p_assig_act_id NUMBER) is

Line 2456: pay_payroll_actions pact

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: ;
2460: cursor csr_formula_2 is

Line 2473: pay_payroll_actions pact,

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
2477: and pact.payroll_action_id = assact.payroll_action_id

Line 2486: pay_payroll_actions pact

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: ;
2490: --

Line 2546: -- pay_payroll_actions ppa,

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
2550: -- and rppa.payroll_action_id = rpaa.payroll_action_id

Line 2548: -- pay_payroll_actions rppa

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
2552: -- and ( ppa.action_type in ('R', 'Q')