APPS.PAY_BALANCE_UPLOAD dependencies on PER_BUSINESS_GROUPS_PERF

Line 604: per_business_groups_perf pbg

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

Line 618: per_business_groups_perf pbg

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

Line 808: per_business_groups_perf pbg

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

Line 982: from per_business_groups_perf BG

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

Line 2761: from per_business_groups_perf BG

2757: ) is
2758: select BG.business_group_id
2759: ,BG.name
2760: ,BG.legislation_code
2761: from per_business_groups_perf BG
2762: where p_business_group_id is not null
2763: and BG.business_group_id = p_business_group_id
2764: union all
2765: select BG.business_group_id

Line 2768: from per_business_groups_perf BG

2764: union all
2765: select BG.business_group_id
2766: ,BG.name
2767: ,BG.legislation_code
2768: from per_business_groups_perf BG
2769: where p_business_group_id is null
2770: and upper(BG.name) = upper(p_name);
2771: --
2772: -- Retrieves payroll information NB. either the payroll_id or payroll_name

Line 5657: from per_business_groups_perf pbg,

5653: ) is
5654: select pbh.business_group_id,
5655: pbg.legislation_code,
5656: pbh.payroll_id
5657: from per_business_groups_perf pbg,
5658: pay_balance_batch_headers pbh
5659: where pbh.batch_id = p_batch_id
5660: and pbh.business_group_id = pbg.business_group_id;
5661: begin