[Home] [Help]
52: from pay_action_interlocks pai2,
53: pay_run_results prr2,
54: pay_element_types_f pet2,
55: pay_payroll_actions ppa,
56: pay_assignment_actions paa
57: where pai2.locking_action_id = p_assignment_action
58: and pai2.locked_action_id = prr2.assignment_action_id
59: and paa.assignment_action_id = pai2.locked_action_id
60: and ppa.payroll_action_id = paa.payroll_action_id
110: pmu.relative_value
111: from pay_monetary_units pmu,
112: per_business_groups_perf pbg,
113: pay_payroll_actions pac,
114: pay_assignment_actions pas
115: where pmu.currency_code = currency
116: and pbg.business_group_id = pac.business_group_id
117: and pac.payroll_action_id = pas.payroll_action_id
118: and pas.assignment_action_id = ass_act
251: --
252: select pmu.monetary_unit_id
253: into monetary_unit
254: from pay_monetary_units pmu,
255: pay_assignment_actions pas,
256: pay_payroll_actions pac,
257: per_business_groups_perf pbg
258: where cash_detail.a_action_id = pas.assignment_action_id
259: and pac.payroll_action_id = pas.payroll_action_id
624: --
625: select opm.external_account_id
626: into l_ext_acc
627: from pay_org_payment_methods_f opm,
628: pay_assignment_actions paa,
629: pay_payroll_actions ppa
630: where paa.assignment_action_id = action_id
631: and ppa.payroll_action_id = paa.payroll_action_id
632: and opm.org_payment_method_id = org_method_id
635: --
636: if (l_ext_acc is null) then
637: select pbg.legislation_code, ppa.effective_date
638: into lgcode, l_effective_date
639: from pay_assignment_actions asg,
640: per_business_groups_perf pbg,
641: pay_payroll_actions ppa
642: where ppa.payroll_action_id = asg.payroll_action_id
643: and asg.assignment_action_id = action_id
1297:
1298: -- check for legilsation rule
1299: select org.legislation_code
1300: into leg_code
1301: from pay_assignment_Actions act,
1302: pay_payroll_actions pact,
1303: per_business_groups_perf org
1304: where act.assignment_action_id=p_assignment_action
1305: and pact.payroll_action_id=act.payroll_action_id
1484: cursor chdact is
1485: select paa_chd.assignment_action_id,
1486: paa_chd.run_type_id,
1487: prt.run_method,paa_chd.assignment_id
1488: from pay_assignment_actions paa_par,
1489: pay_action_interlocks pai,
1490: pay_assignment_actions paa_chd,
1491: pay_payroll_actions ppa_chd,
1492: pay_run_types_f prt
1486: paa_chd.run_type_id,
1487: prt.run_method,paa_chd.assignment_id
1488: from pay_assignment_actions paa_par,
1489: pay_action_interlocks pai,
1490: pay_assignment_actions paa_chd,
1491: pay_payroll_actions ppa_chd,
1492: pay_run_types_f prt
1493: where paa_par.assignment_action_id = p_assignment_action
1494: and paa_par.assignment_action_id = pai.locking_action_id
1522: pay_org_payment_methods_f opm,
1523: pay_run_type_org_methods_f rtom,
1524: pay_org_pay_method_usages_f opmu,
1525: pay_payroll_actions ppa,
1526: pay_assignment_actions paa
1527: where rtom.run_type_id = p_run_type
1528: and rtom.org_payment_method_id = opm.org_payment_method_id
1529: and opm.payment_type_id = ppt.payment_type_id
1530: and opm.defined_balance_id = p_def_balance
1561: from pay_external_accounts pea,
1562: pay_payment_types ppt,
1563: pay_org_payment_methods_f opm,
1564: pay_personal_payment_methods_f ppm,
1565: pay_assignment_actions act
1566: where act.assignment_action_id=p_assignment_action
1567: and ppm.assignment_id = act.assignment_id
1568: and ppm.run_type_id = p_run_type
1569: and ppm.org_payment_method_id = opm.org_payment_method_id
1605: hr_utility.trace('Enter pay_run_type_methods');
1606: -- check for legilsation rule
1607: select org.legislation_code
1608: into leg_code
1609: from pay_assignment_Actions act,
1610: pay_payroll_actions pact,
1611: per_business_groups_perf org
1612: where act.assignment_action_id=p_assignment_Action
1613: and pact.payroll_action_id=act.payroll_action_id
2042: p_master_aa_id in number) is
2043:
2044: cursor chdact is
2045: select paa_chd.assignment_action_id, paa_chd.run_type_id, prt.run_method,paa_chd.assignment_id
2046: from pay_assignment_actions paa_par,
2047: pay_action_interlocks pai,
2048: pay_assignment_actions paa_chd,
2049: pay_payroll_actions ppa_chd,
2050: pay_run_types_f prt
2044: cursor chdact is
2045: select paa_chd.assignment_action_id, paa_chd.run_type_id, prt.run_method,paa_chd.assignment_id
2046: from pay_assignment_actions paa_par,
2047: pay_action_interlocks pai,
2048: pay_assignment_actions paa_chd,
2049: pay_payroll_actions ppa_chd,
2050: pay_run_types_f prt
2051: where paa_par.assignment_action_id = p_assignment_action
2052: and paa_par.assignment_action_id = pai.locking_action_id
2300: pay_element_types_f pet,
2301: pay_run_result_values rrv,
2302: pay_run_results prr2,
2303: pay_run_results prr,
2304: pay_assignment_actions paa,
2305: pay_payroll_actions ppa
2306: where prr.run_result_id = p_run_result
2307: and paa.assignment_action_id= prr.assignment_action_id
2308: and ppa.payroll_action_id = paa.payroll_action_id
2470: pay_personal_payment_methods_f ppm,
2471: pay_external_accounts pea,
2472: pay_org_payment_methods_f opm,
2473: pay_payment_types ppt,
2474: pay_assignment_actions paa,
2475: pay_payroll_actions ppa
2476: where prr.run_result_id = p_run_results
2477: /* Bug 12364433*/
2478: and nvl(prr.element_entry_id,prr.source_id) = pee.element_entry_id
2533: payment_details.category IN ('MT', 'CA')) then
2534: --
2535: declare
2536: rt_method pay_run_types_f.run_method%type;
2537: sep_chq_aa_id pay_assignment_actions.assignment_action_id%type;
2538: begin
2539: --
2540: -- Get the run method
2541: select nvl(prt.run_method, 'N'), paa.assignment_action_id
2541: select nvl(prt.run_method, 'N'), paa.assignment_action_id
2542: into rt_method,
2543: sep_chq_aa_id
2544: from pay_run_types_f prt,
2545: pay_assignment_actions paa,
2546: pay_run_results prr,
2547: pay_payroll_actions ppa
2548: where prr.run_result_id = p_run_results
2549: and prr.assignment_action_id = paa.assignment_action_id
2733: pay_payment_types ppt,
2734: pay_org_payment_methods_f popm,
2735: pay_org_payment_methods_f popm_par,
2736: pay_org_pay_method_usages_f popmu,
2737: pay_assignment_actions paa,
2738: pay_payroll_actions ppa
2739: where paa.assignment_action_id = p_asg_action
2740: and paa.payroll_action_id = ppa.payroll_action_id
2741: and popm.organization_id = p_org_id
2762: select distinct (prrv.result_value) organization_id
2763: from pay_run_result_values prrv,
2764: pay_input_values_f piv,
2765: pay_run_results prr,
2766: pay_assignment_actions paa,
2767: pay_payroll_actions ppa,
2768: pay_action_interlocks pai
2769: where pai.locking_action_id = p_asg_action
2770: and pai.locked_action_id = paa.assignment_action_id
2983: is
2984: cursor get_child_actions(p_run_act_id number)
2985: is
2986: select chld.assignment_action_id
2987: from pay_assignment_actions chld,
2988: pay_assignment_actions mas
2989: where mas.assignment_action_id = p_run_act_id
2990: and mas.assignment_action_id = chld.source_action_id
2991: and mas.payroll_action_id = chld.payroll_action_id
2984: cursor get_child_actions(p_run_act_id number)
2985: is
2986: select chld.assignment_action_id
2987: from pay_assignment_actions chld,
2988: pay_assignment_actions mas
2989: where mas.assignment_action_id = p_run_act_id
2990: and mas.assignment_action_id = chld.source_action_id
2991: and mas.payroll_action_id = chld.payroll_action_id
2992: and mas.assignment_id = chld.assignment_id;
3012: paa_mas.payroll_action_id pre_payroll_action_id,
3013: paa.tax_unit_id run_tax_unit_id,
3014: paa_mas.chunk_number pre_chunk_number
3015: from pay_action_interlocks pai,
3016: pay_assignment_actions paa,
3017: pay_assignment_actions paa_mas
3018: where pai.locking_action_id = paa_mas.assignment_action_id
3019: and paa_mas.assignment_action_id = p_action
3020: and pai.locked_action_id = paa.assignment_action_id
3013: paa.tax_unit_id run_tax_unit_id,
3014: paa_mas.chunk_number pre_chunk_number
3015: from pay_action_interlocks pai,
3016: pay_assignment_actions paa,
3017: pay_assignment_actions paa_mas
3018: where pai.locking_action_id = paa_mas.assignment_action_id
3019: and paa_mas.assignment_action_id = p_action
3020: and pai.locked_action_id = paa.assignment_action_id
3021: and exists (select ''
3019: and paa_mas.assignment_action_id = p_action
3020: and pai.locked_action_id = paa.assignment_action_id
3021: and exists (select ''
3022: from pay_action_interlocks pai2,
3023: pay_assignment_actions paa2
3024: where pai2.locking_action_id = paa_mas.assignment_action_id
3025: and pai2.locked_action_id = paa2.assignment_action_id
3026: and paa2.tax_unit_id <> paa.tax_unit_id)
3027: order by paa.tax_unit_id;
3034: paa_mas.chunk_number pre_chunk_number,
3035: paa.start_date start_date,
3036: paa.end_date end_date
3037: from pay_action_interlocks pai,
3038: pay_assignment_actions paa,
3039: pay_assignment_actions paa_mas
3040: where pai.locking_action_id = paa_mas.assignment_action_id
3041: and paa_mas.assignment_action_id = p_action
3042: and pai.locked_action_id = paa.assignment_action_id
3035: paa.start_date start_date,
3036: paa.end_date end_date
3037: from pay_action_interlocks pai,
3038: pay_assignment_actions paa,
3039: pay_assignment_actions paa_mas
3040: where pai.locking_action_id = paa_mas.assignment_action_id
3041: and paa_mas.assignment_action_id = p_action
3042: and pai.locked_action_id = paa.assignment_action_id
3043: --
3045: -- multiple assignment payrolls
3046: --
3047: --and exists (select ''
3048: -- from pay_action_interlocks pai2,
3049: -- pay_assignment_actions paa2
3050: -- where pai2.locking_action_id = paa_mas.assignment_action_id
3051: -- and pai2.locked_action_id = paa2.assignment_action_id
3052: -- and paa2.assignment_id <> paa.assignment_id)
3053: order by paa.assignment_id;
3078: found_tu := TRUE;
3079: --
3080: if (prev_tu <> turec.run_tax_unit_id) then
3081: --
3082: select pay_assignment_actions_s.nextval
3083: into pre_tu_actid
3084: from dual;
3085: --
3086: hr_nonrun_asact.insact(pre_tu_actid,
3122: --
3123: hr_utility.trace('Found Non Pro Asg '||asgrec.assignment_id);
3124: --
3125: if (prev_asg_id <> asgrec.assignment_id) then
3126: select pay_assignment_actions_s.nextval
3127: into pre_asg_actid
3128: from dual;
3129: --
3130: hr_nonrun_asact.insact(pre_asg_actid,
3167: --
3168: cursor get_pp_chld (p_asg_act number) is
3169: select paa_chd.assignment_action_id,
3170: paa_chd.start_date
3171: from pay_assignment_actions paa_chd,
3172: pay_assignment_actions paa_mas
3173: where paa_mas.assignment_action_id = p_asg_act
3174: and paa_mas.assignment_action_id = paa_chd.source_action_id
3175: and paa_mas.payroll_action_id = paa_chd.payroll_action_id
3168: cursor get_pp_chld (p_asg_act number) is
3169: select paa_chd.assignment_action_id,
3170: paa_chd.start_date
3171: from pay_assignment_actions paa_chd,
3172: pay_assignment_actions paa_mas
3173: where paa_mas.assignment_action_id = p_asg_act
3174: and paa_mas.assignment_action_id = paa_chd.source_action_id
3175: and paa_mas.payroll_action_id = paa_chd.payroll_action_id
3176: and paa_mas.chunk_number = paa_chd.chunk_number;
3183: and target_location = 'PAYWSDOR'
3184: and rule_mode = 'Y'
3185: and legislation_code =
3186: (select hr_api.return_legislation_code(ppa.business_group_id)
3187: from pay_payroll_actions ppa, pay_assignment_actions paa
3188: where paa.payroll_action_id = ppa.payroll_action_id
3189: and paa.assignment_action_id = p_asg_act);
3190: --
3191: l_eff_date date;
3435: paa_pru.assignment_action_id,
3436: ppa_pru.payroll_action_id
3437: from pay_payroll_actions ppa_pru,
3438: pay_payroll_actions ppa_pre,
3439: pay_assignment_actions paa_pru,
3440: pay_assignment_actions paa_pre,
3441: pay_action_interlocks pai,
3442: pay_pre_payments ppp
3443: where
3436: ppa_pru.payroll_action_id
3437: from pay_payroll_actions ppa_pru,
3438: pay_payroll_actions ppa_pre,
3439: pay_assignment_actions paa_pru,
3440: pay_assignment_actions paa_pre,
3441: pay_action_interlocks pai,
3442: pay_pre_payments ppp
3443: where
3444: paa_pru.assignment_action_id = p_asg_act