[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
1292:
1293: -- check for legilsation rule
1294: select org.legislation_code
1295: into leg_code
1296: from pay_assignment_Actions act,
1297: pay_payroll_actions pact,
1298: per_business_groups_perf org
1299: where act.assignment_action_id=p_assignment_action
1300: and pact.payroll_action_id=act.payroll_action_id
1479: cursor chdact is
1480: select paa_chd.assignment_action_id,
1481: paa_chd.run_type_id,
1482: prt.run_method,paa_chd.assignment_id
1483: from pay_assignment_actions paa_par,
1484: pay_action_interlocks pai,
1485: pay_assignment_actions paa_chd,
1486: pay_payroll_actions ppa_chd,
1487: pay_run_types_f prt
1481: paa_chd.run_type_id,
1482: prt.run_method,paa_chd.assignment_id
1483: from pay_assignment_actions paa_par,
1484: pay_action_interlocks pai,
1485: pay_assignment_actions paa_chd,
1486: pay_payroll_actions ppa_chd,
1487: pay_run_types_f prt
1488: where paa_par.assignment_action_id = p_assignment_action
1489: and paa_par.assignment_action_id = pai.locking_action_id
1517: pay_org_payment_methods_f opm,
1518: pay_run_type_org_methods_f rtom,
1519: pay_org_pay_method_usages_f opmu,
1520: pay_payroll_actions ppa,
1521: pay_assignment_actions paa
1522: where rtom.run_type_id = p_run_type
1523: and rtom.org_payment_method_id = opm.org_payment_method_id
1524: and opm.payment_type_id = ppt.payment_type_id
1525: and opm.defined_balance_id = p_def_balance
1556: from pay_external_accounts pea,
1557: pay_payment_types ppt,
1558: pay_org_payment_methods_f opm,
1559: pay_personal_payment_methods_f ppm,
1560: pay_assignment_actions act
1561: where act.assignment_action_id=p_assignment_action
1562: and ppm.assignment_id = act.assignment_id
1563: and ppm.run_type_id = p_run_type
1564: and ppm.org_payment_method_id = opm.org_payment_method_id
1600: hr_utility.trace('Enter pay_run_type_methods');
1601: -- check for legilsation rule
1602: select org.legislation_code
1603: into leg_code
1604: from pay_assignment_Actions act,
1605: pay_payroll_actions pact,
1606: per_business_groups_perf org
1607: where act.assignment_action_id=p_assignment_Action
1608: and pact.payroll_action_id=act.payroll_action_id
2037: p_master_aa_id in number) is
2038:
2039: cursor chdact is
2040: select paa_chd.assignment_action_id, paa_chd.run_type_id, prt.run_method,paa_chd.assignment_id
2041: from pay_assignment_actions paa_par,
2042: pay_action_interlocks pai,
2043: pay_assignment_actions paa_chd,
2044: pay_payroll_actions ppa_chd,
2045: pay_run_types_f prt
2039: cursor chdact is
2040: select paa_chd.assignment_action_id, paa_chd.run_type_id, prt.run_method,paa_chd.assignment_id
2041: from pay_assignment_actions paa_par,
2042: pay_action_interlocks pai,
2043: pay_assignment_actions paa_chd,
2044: pay_payroll_actions ppa_chd,
2045: pay_run_types_f prt
2046: where paa_par.assignment_action_id = p_assignment_action
2047: and paa_par.assignment_action_id = pai.locking_action_id
2295: pay_element_types_f pet,
2296: pay_run_result_values rrv,
2297: pay_run_results prr2,
2298: pay_run_results prr,
2299: pay_assignment_actions paa,
2300: pay_payroll_actions ppa
2301: where prr.run_result_id = p_run_result
2302: and paa.assignment_action_id= prr.assignment_action_id
2303: and ppa.payroll_action_id = paa.payroll_action_id
2445: pay_personal_payment_methods_f ppm,
2446: pay_external_accounts pea,
2447: pay_org_payment_methods_f opm,
2448: pay_payment_types ppt,
2449: pay_assignment_actions paa,
2450: pay_payroll_actions ppa
2451: where prr.run_result_id = p_run_results
2452: and prr.source_id = pee.element_entry_id
2453: and paa.assignment_action_id = prr.assignment_action_id
2497: payment_details.category IN ('MT', 'CA')) then
2498: --
2499: declare
2500: rt_method pay_run_types_f.run_method%type;
2501: sep_chq_aa_id pay_assignment_actions.assignment_action_id%type;
2502: begin
2503: --
2504: -- Get the run method
2505: select nvl(prt.run_method, 'N'), paa.assignment_action_id
2505: select nvl(prt.run_method, 'N'), paa.assignment_action_id
2506: into rt_method,
2507: sep_chq_aa_id
2508: from pay_run_types_f prt,
2509: pay_assignment_actions paa,
2510: pay_run_results prr,
2511: pay_payroll_actions ppa
2512: where prr.run_result_id = p_run_results
2513: and prr.assignment_action_id = paa.assignment_action_id
2697: pay_payment_types ppt,
2698: pay_org_payment_methods_f popm,
2699: pay_org_payment_methods_f popm_par,
2700: pay_org_pay_method_usages_f popmu,
2701: pay_assignment_actions paa,
2702: pay_payroll_actions ppa
2703: where paa.assignment_action_id = p_asg_action
2704: and paa.payroll_action_id = ppa.payroll_action_id
2705: and popm.organization_id = p_org_id
2724: distinct (prrv.result_value) organization_id
2725: from pay_run_result_values prrv,
2726: pay_input_values_f piv,
2727: pay_run_results prr,
2728: pay_assignment_actions paa,
2729: pay_payroll_actions ppa,
2730: pay_action_interlocks pai
2731: where pai.locking_action_id = p_asg_action
2732: and pai.locked_action_id = paa.assignment_action_id
2945: is
2946: cursor get_child_actions(p_run_act_id number)
2947: is
2948: select chld.assignment_action_id
2949: from pay_assignment_actions chld,
2950: pay_assignment_actions mas
2951: where mas.assignment_action_id = p_run_act_id
2952: and mas.assignment_action_id = chld.source_action_id
2953: and mas.payroll_action_id = chld.payroll_action_id
2946: cursor get_child_actions(p_run_act_id number)
2947: is
2948: select chld.assignment_action_id
2949: from pay_assignment_actions chld,
2950: pay_assignment_actions mas
2951: where mas.assignment_action_id = p_run_act_id
2952: and mas.assignment_action_id = chld.source_action_id
2953: and mas.payroll_action_id = chld.payroll_action_id
2954: and mas.assignment_id = chld.assignment_id;
2974: paa_mas.payroll_action_id pre_payroll_action_id,
2975: paa.tax_unit_id run_tax_unit_id,
2976: paa_mas.chunk_number pre_chunk_number
2977: from pay_action_interlocks pai,
2978: pay_assignment_actions paa,
2979: pay_assignment_actions paa_mas
2980: where pai.locking_action_id = paa_mas.assignment_action_id
2981: and paa_mas.assignment_action_id = p_action
2982: and pai.locked_action_id = paa.assignment_action_id
2975: paa.tax_unit_id run_tax_unit_id,
2976: paa_mas.chunk_number pre_chunk_number
2977: from pay_action_interlocks pai,
2978: pay_assignment_actions paa,
2979: pay_assignment_actions paa_mas
2980: where pai.locking_action_id = paa_mas.assignment_action_id
2981: and paa_mas.assignment_action_id = p_action
2982: and pai.locked_action_id = paa.assignment_action_id
2983: and exists (select ''
2981: and paa_mas.assignment_action_id = p_action
2982: and pai.locked_action_id = paa.assignment_action_id
2983: and exists (select ''
2984: from pay_action_interlocks pai2,
2985: pay_assignment_actions paa2
2986: where pai2.locking_action_id = paa_mas.assignment_action_id
2987: and pai2.locked_action_id = paa2.assignment_action_id
2988: and paa2.tax_unit_id <> paa.tax_unit_id)
2989: order by paa.tax_unit_id;
2996: paa_mas.chunk_number pre_chunk_number,
2997: paa.start_date start_date,
2998: paa.end_date end_date
2999: from pay_action_interlocks pai,
3000: pay_assignment_actions paa,
3001: pay_assignment_actions paa_mas
3002: where pai.locking_action_id = paa_mas.assignment_action_id
3003: and paa_mas.assignment_action_id = p_action
3004: and pai.locked_action_id = paa.assignment_action_id
2997: paa.start_date start_date,
2998: paa.end_date end_date
2999: from pay_action_interlocks pai,
3000: pay_assignment_actions paa,
3001: pay_assignment_actions paa_mas
3002: where pai.locking_action_id = paa_mas.assignment_action_id
3003: and paa_mas.assignment_action_id = p_action
3004: and pai.locked_action_id = paa.assignment_action_id
3005: --
3007: -- multiple assignment payrolls
3008: --
3009: --and exists (select ''
3010: -- from pay_action_interlocks pai2,
3011: -- pay_assignment_actions paa2
3012: -- where pai2.locking_action_id = paa_mas.assignment_action_id
3013: -- and pai2.locked_action_id = paa2.assignment_action_id
3014: -- and paa2.assignment_id <> paa.assignment_id)
3015: order by paa.assignment_id;
3040: found_tu := TRUE;
3041: --
3042: if (prev_tu <> turec.run_tax_unit_id) then
3043: --
3044: select pay_assignment_actions_s.nextval
3045: into pre_tu_actid
3046: from dual;
3047: --
3048: hr_nonrun_asact.insact(pre_tu_actid,
3084: --
3085: hr_utility.trace('Found Non Pro Asg '||asgrec.assignment_id);
3086: --
3087: if (prev_asg_id <> asgrec.assignment_id) then
3088: select pay_assignment_actions_s.nextval
3089: into pre_asg_actid
3090: from dual;
3091: --
3092: hr_nonrun_asact.insact(pre_asg_actid,
3129: --
3130: cursor get_pp_chld (p_asg_act number) is
3131: select paa_chd.assignment_action_id,
3132: paa_chd.start_date
3133: from pay_assignment_actions paa_chd,
3134: pay_assignment_actions paa_mas
3135: where paa_mas.assignment_action_id = p_asg_act
3136: and paa_mas.assignment_action_id = paa_chd.source_action_id
3137: and paa_mas.payroll_action_id = paa_chd.payroll_action_id
3130: cursor get_pp_chld (p_asg_act number) is
3131: select paa_chd.assignment_action_id,
3132: paa_chd.start_date
3133: from pay_assignment_actions paa_chd,
3134: pay_assignment_actions paa_mas
3135: where paa_mas.assignment_action_id = p_asg_act
3136: and paa_mas.assignment_action_id = paa_chd.source_action_id
3137: and paa_mas.payroll_action_id = paa_chd.payroll_action_id
3138: and paa_mas.chunk_number = paa_chd.chunk_number;
3145: and target_location = 'PAYWSDOR'
3146: and rule_mode = 'Y'
3147: and legislation_code =
3148: (select hr_api.return_legislation_code(ppa.business_group_id)
3149: from pay_payroll_actions ppa, pay_assignment_actions paa
3150: where paa.payroll_action_id = ppa.payroll_action_id
3151: and paa.assignment_action_id = p_asg_act);
3152: --
3153: l_eff_date date;
3397: paa_pru.assignment_action_id,
3398: ppa_pru.payroll_action_id
3399: from pay_payroll_actions ppa_pru,
3400: pay_payroll_actions ppa_pre,
3401: pay_assignment_actions paa_pru,
3402: pay_assignment_actions paa_pre,
3403: pay_action_interlocks pai,
3404: pay_pre_payments ppp
3405: where
3398: ppa_pru.payroll_action_id
3399: from pay_payroll_actions ppa_pru,
3400: pay_payroll_actions ppa_pre,
3401: pay_assignment_actions paa_pru,
3402: pay_assignment_actions paa_pre,
3403: pay_action_interlocks pai,
3404: pay_pre_payments ppp
3405: where
3406: paa_pru.assignment_action_id = p_asg_act