APPS.PAY_BALANCE_UPLOAD dependencies on PER_BUSINESS_GROUPS_PERF

Line 606: per_business_groups_perf pbg

602: ) is
603: select upper(prt.run_type_name) run_type_name,
604: prt.run_type_id
605: from pay_run_types_f prt,
606: per_business_groups_perf pbg
607: where pbg.business_group_id = p_business_group_id
608: and p_effective_date between prt.effective_start_date
609: and prt.effective_end_date
610: and (pbg.business_group_id = prt.business_group_id

Line 620: per_business_groups_perf pbg

616: union all
617: select upper(prt.run_type_name) run_type_name,
618: prt.run_type_id
619: from pay_run_types_f prt,
620: per_business_groups_perf pbg
621: where pbg.business_group_id = p_business_group_id
622: and p_effective_date between prt.effective_start_date
623: and prt.effective_end_date
624: and (pbg.business_group_id = prt.business_group_id

Line 810: per_business_groups_perf pbg

806: --
807: select plr.rule_mode
808: into g_leg_rule
809: from pay_legislation_rules plr,
810: per_business_groups_perf pbg
811: where pbg.business_group_id = p_business_group
812: and plr.legislation_code = pbg.legislation_code
813: and plr.rule_type = 'TAX_UNIT';
814: --

Line 984: from per_business_groups_perf BG

980: (
981: p_business_group_id number
982: ) is
983: select BG.legislation_code
984: from per_business_groups_perf BG
985: where BG.business_group_id = p_business_group_id;
986: --
987: -- Holds the expiry date of the dimension.
988: --

Line 3054: from per_business_groups_perf BG

3050: ) is
3051: select BG.business_group_id
3052: ,BG.name
3053: ,BG.legislation_code
3054: from per_business_groups_perf BG
3055: where p_business_group_id is not null
3056: and BG.business_group_id = p_business_group_id
3057: union all
3058: select BG.business_group_id

Line 3061: from per_business_groups_perf BG

3057: union all
3058: select BG.business_group_id
3059: ,BG.name
3060: ,BG.legislation_code
3061: from per_business_groups_perf BG
3062: where p_business_group_id is null
3063: and upper(BG.name) = upper(p_name);
3064: --
3065: -- Retrieves payroll information NB. either the payroll_id or payroll_name

Line 5950: from per_business_groups_perf pbg,

5946: ) is
5947: select pbh.business_group_id,
5948: pbg.legislation_code,
5949: pbh.payroll_id
5950: from per_business_groups_perf pbg,
5951: pay_balance_batch_headers pbh
5952: where pbh.batch_id = p_batch_id
5953: and pbh.business_group_id = pbg.business_group_id;
5954: begin