APPS.PAY_RUN_BALANCE_BUILD dependencies on PER_BUSINESS_GROUPS

Line 99: per_business_groups pbg,

95: ppa.legislative_parameters),
96: 'BOTH') balance_level,
97: pbd.dimension_level
98: from pay_payroll_actions ppa,
99: per_business_groups pbg,
100: pay_defined_balances pdb,
101: pay_balance_dimensions pbd
102: where ppa.payroll_action_id = p_pact_id
103: and ppa.business_group_id = pbg.business_group_id

Line 261: per_business_groups pbg

257: g_leg_code,
258: g_bus_grp,
259: g_att_name
260: from pay_payroll_actions pa1,
261: per_business_groups pbg
262: where pa1.payroll_action_id = p_pact_id
263: and pa1.business_group_id = pbg.business_group_id;
264: --
265: begin

Line 521: per_business_groups_perf pbg

517: pbg.legislation_code
518: from pay_assignment_actions paa,
519: pay_payroll_actions ppa,
520: pay_run_types_f prt,
521: per_business_groups_perf pbg
522: where paa.assignment_id = p_assid
523: and paa.payroll_action_id = ppa.payroll_action_id
524: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
525: and ppa.business_group_id = pbg.business_group_id

Line 882: l_leg_code per_business_groups.legislation_code%type;

878: l_grp_eff_date date;
879: l_bus_grp pay_payroll_actions.business_group_id%type;
880: l_run_bal_status pay_balance_validation.run_balance_status%type;
881: l_bal_load_date pay_balance_validation.balance_load_date%type;
882: l_leg_code per_business_groups.legislation_code%type;
883: begin
884: --
885: begin
886: select ppa.effective_date,

Line 893: per_business_groups pbg

889: into l_grp_eff_date,
890: l_bus_grp,
891: l_leg_code
892: from pay_payroll_actions ppa,
893: per_business_groups pbg
894: where ppa.payroll_action_id = p_pactid
895: and ppa.business_group_id = pbg.business_group_id;
896: exception
897: --