[Home] [Help]
51: paa.assignment_id
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
109: select pmu.monetary_unit_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
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
260: and pbg.business_group_id = pac.business_group_id
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
633: and ppa.effective_date between
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
644: and ppa.business_group_id = pbg.business_group_id;
645: --
897: pay_defined_balances pdb,
898: pay_payment_types ppt,
899: pay_all_payrolls_f pp,
900: pay_org_payment_methods_f opm,
901: pay_payroll_actions ppa
902: where ppa.payroll_action_id = payroll_action
903: and ppa.payroll_id = pp.payroll_id
904: and pp.default_payment_method_id = opm.org_payment_method_id
905: and opm.payment_type_id = ppt.payment_type_id
933: select plr.rule_mode
934: into g_adjust_ee_source
935: from pay_legislation_rules plr,
936: per_business_groups_perf pbg,
937: pay_payroll_actions ppa
938: where ppa.payroll_action_id = payroll_action
939: and ppa.business_group_id = pbg.business_group_id
940: and pbg.legislation_code = plr.legislation_code
941: and plr.rule_type = 'ADJUSTMENT_EE_SOURCE';
1009: pay_defined_balances pdb,
1010: pay_payment_types ppt,
1011: pay_org_pay_method_usages_f pmu,
1012: pay_org_payment_methods_f opm,
1013: pay_payroll_actions ppa
1014: where ppa.payroll_action_id = payroll_action
1015: and ppa.payroll_id = pmu.payroll_id
1016: and ppa.payroll_id = pp.payroll_id
1017: and pmu.org_payment_method_id = override_method
1047: select plr.rule_mode
1048: into g_adjust_ee_source
1049: from pay_legislation_rules plr,
1050: per_business_groups_perf pbg,
1051: pay_payroll_actions ppa
1052: where ppa.payroll_action_id = payroll_action
1053: and ppa.business_group_id = pbg.business_group_id
1054: and pbg.legislation_code = plr.legislation_code
1055: and plr.rule_type = 'ADJUSTMENT_EE_SOURCE';
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
1306: and org.business_group_id=pact.business_group_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
1495: and pai.locked_action_id = paa_chd.assignment_action_id
1521: from pay_payment_types ppt,
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
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
1614: and org.business_group_id=pact.business_group_id;
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
2053: and pai.locked_action_id = paa_chd.assignment_action_id
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
2309: and pet.element_type_id = prr2.element_type_id
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
2479: and paa.assignment_action_id = prr.assignment_action_id
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
2550: and paa.payroll_action_id = ppa.payroll_action_id
2551: and nvl(paa.run_type_id, -999) = prt.run_type_id (+)
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
2742: and popm.type = 'PAYEE'
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
2771: and paa.assignment_action_id = prr.assignment_action_id
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;
3419: type t_pre_payment_id is table of pay_pre_payments.pre_payment_id%type
3420: index by binary_integer;
3421: type t_assignment_action_id is table of pay_pre_payments.assignment_action_id%type
3422: index by binary_integer;
3423: type t_payroll_action_id is table of pay_payroll_actions.payroll_action_id%type
3424: index by binary_integer;
3425: --
3426: f_pre_payment_id t_pre_payment_id;
3427: f_assignment_action_id t_assignment_action_id;
3433: select
3434: ppp.pre_payment_id,
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,
3434: ppp.pre_payment_id,
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