[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
1041: begin
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
1095: --
1096: if (bal_found = FALSE) then
1097: select distinct legislation_code
1098: into bus_leg
1099: from per_business_groups_perf
1100: where business_group_id = p_bus_grp;
1101: --
1102: select distinct pdb.defined_balance_id,
1103: pbt.currency_code
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;
1302:
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;
1610:
3253: --
3254: l_trx_date date;
3255: statem varchar2(1000);
3256: rows_processed integer;
3257: l_leg_code per_business_groups_perf.legislation_code%type;
3258: l_cur_id number;
3259: --
3260: begin
3261: --
3266: l_cur_id := p_cur_id;
3267: else
3268: select legislation_code
3269: into l_leg_code
3270: from per_business_groups_perf
3271: where business_group_id = p_business_group_id;
3272: --
3273: if l_leg_code = p_leg_code then
3274: --