APPS.PAY_RUN_BALANCE_BUILD dependencies on PER_BUSINESS_GROUPS

Line 117: per_business_groups pbg,

113: ppa.legislative_parameters),
114: 'BOTH') balance_level,
115: pbd.dimension_level
116: from pay_payroll_actions ppa,
117: per_business_groups pbg,
118: pay_defined_balances pdb,
119: pay_balance_dimensions pbd
120: where ppa.payroll_action_id = p_pact_id
121: and ppa.business_group_id = pbg.business_group_id

Line 334: per_business_groups pbg

330: g_bus_grp,
331: g_att_name,
332: g_generate_pact
333: from pay_payroll_actions pa1,
334: per_business_groups pbg
335: where pa1.payroll_action_id = p_pact_id
336: and pa1.business_group_id = pbg.business_group_id;
337: --
338: begin

Line 605: /* Bug 13773218, removed join with per_business_groups_perf table */

601: Arguments :
602: Notes :
603: */
604:
605: /* Bug 13773218, removed join with per_business_groups_perf table */
606: procedure process_asg_lvl_balances(p_asg_id in number,
607: p_bus_grp in number,
608: p_chunk_number number)
609: is

Line 1087: l_leg_code per_business_groups.legislation_code%type;

1083: l_grp_eff_date date;
1084: l_bus_grp pay_payroll_actions.business_group_id%type;
1085: l_run_bal_status pay_balance_validation.run_balance_status%type;
1086: l_bal_load_date pay_balance_validation.balance_load_date%type;
1087: l_leg_code per_business_groups.legislation_code%type;
1088: l_del_cnt number;
1089: begin
1090: --
1091: if g_debug then

Line 1102: per_business_groups pbg

1098: into l_grp_eff_date,
1099: l_bus_grp,
1100: l_leg_code
1101: from pay_payroll_actions ppa,
1102: per_business_groups pbg
1103: where ppa.payroll_action_id = p_pactid
1104: and ppa.business_group_id = pbg.business_group_id;
1105: exception
1106: --