[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';
1004: pay_defined_balances pdb,
1005: pay_payment_types ppt,
1006: pay_org_pay_method_usages_f pmu,
1007: pay_org_payment_methods_f opm,
1008: pay_payroll_actions ppa
1009: where ppa.payroll_action_id = payroll_action
1010: and ppa.payroll_id = pmu.payroll_id
1011: and ppa.payroll_id = pp.payroll_id
1012: and pmu.org_payment_method_id = override_method
1042: select plr.rule_mode
1043: into g_adjust_ee_source
1044: from pay_legislation_rules plr,
1045: per_business_groups_perf pbg,
1046: pay_payroll_actions ppa
1047: where ppa.payroll_action_id = payroll_action
1048: and ppa.business_group_id = pbg.business_group_id
1049: and pbg.legislation_code = plr.legislation_code
1050: and plr.rule_type = 'ADJUSTMENT_EE_SOURCE';
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
1301: and org.business_group_id=pact.business_group_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
1490: and pai.locked_action_id = paa_chd.assignment_action_id
1516: from pay_payment_types ppt,
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
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
1609: and org.business_group_id=pact.business_group_id;
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
2048: and pai.locked_action_id = paa_chd.assignment_action_id
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
2304: and pet.element_type_id = prr2.element_type_id
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
2454: and paa.payroll_action_id = ppa.payroll_action_id
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
2514: and paa.payroll_action_id = ppa.payroll_action_id
2515: and nvl(paa.run_type_id, -999) = prt.run_type_id (+)
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
2706: and popm.type = 'PAYEE'
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
2733: and paa.assignment_action_id = prr.assignment_action_id
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;
3381: type t_pre_payment_id is table of pay_pre_payments.pre_payment_id%type
3382: index by binary_integer;
3383: type t_assignment_action_id is table of pay_pre_payments.assignment_action_id%type
3384: index by binary_integer;
3385: type t_payroll_action_id is table of pay_payroll_actions.payroll_action_id%type
3386: index by binary_integer;
3387: --
3388: f_pre_payment_id t_pre_payment_id;
3389: f_assignment_action_id t_assignment_action_id;
3395: select
3396: ppp.pre_payment_id,
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,
3396: ppp.pre_payment_id,
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