[Home] [Help]
108: ass_act in number) is
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
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
261: and pmu.currency_code = cash_detail.currency
501: */
502: procedure override_mult_tax_unit_payment(p_business_group_id in number,
503: p_multi_tax_unit_payment in out nocopy varchar2)
504: is
505: leg_code per_business_groups_perf.legislation_code%type;
506: statem varchar2(2000);
507: sql_cursor integer;
508: l_rows integer;
509: begin
509: begin
510: --
511: select legislation_code
512: into leg_code
513: from per_business_groups_perf
514: where business_group_id = p_business_group_id;
515: --
516: statem := 'begin pay_'||leg_code||'_rules.get_multi_tax_unit_pay_flag(';
517: statem := statem||':bus_grp, :mtup_flag); end;';
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
644: and ppa.business_group_id = pbg.business_group_id;
932: begin
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
1046: begin
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
1100: --
1101: if (bal_found = FALSE) then
1102: select distinct legislation_code
1103: into bus_leg
1104: from per_business_groups_perf
1105: where business_group_id = p_bus_grp;
1106: --
1107: select distinct pdb.defined_balance_id,
1108: pbt.currency_code
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;
1307:
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;
1615:
3291: --
3292: l_trx_date date;
3293: statem varchar2(1000);
3294: rows_processed integer;
3295: l_leg_code per_business_groups_perf.legislation_code%type;
3296: l_cur_id number;
3297: --
3298: begin
3299: --
3304: l_cur_id := p_cur_id;
3305: else
3306: select legislation_code
3307: into l_leg_code
3308: from per_business_groups_perf
3309: where business_group_id = p_business_group_id;
3310: --
3311: if l_leg_code = p_leg_code then
3312: --