[Home] [Help]
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: --
594: -- cache the value that doesn't change unless payroll action changes
595: if nvl(g_payroll_action_id,-1) <> p_payroll_action_id then
596: select max(org_information8) into g_tax_phone
597: from pay_payrolls_f p,
598: pay_payroll_actions pact,
599: hr_soft_coding_keyflex flex,
600: hr_organization_information org
601: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
602: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
1953: AND row_name = pbt.balance_name || pbd.database_item_suffix;
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:
2387: AND row_name = pbt.balance_name || pbd.database_item_suffix;
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:
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
2739: and rppa.payroll_action_id = rpaa.payroll_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
2741: and paa.assignment_action_id =
2740: and paa.assignment_id = rpaa.assignment_id
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
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
2770: /* Commented below code, removed action_types 'B' and 'I' for bug fix 4775025*/
2776:
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:
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:
2792: cursor csr_formula_5(p_assig_act_id NUMBER) is
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: ;
2861: cursor csr_formula_2 is
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
2878: and pact.payroll_action_id = assact.payroll_action_id
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: ;
2891: --
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
2951: -- and rppa.payroll_action_id = rpaa.payroll_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
2953: -- and ( ppa.action_type in ('R', 'Q')