APPS.PER_PDP_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: from per_business_groups pbg

25: -- Declare cursor
26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , per_periods_of_placement pdp
31: where pdp.period_of_placement_id = p_period_of_placement_id
32: and pbg.business_group_id = pdp.business_group_id;
33: --

Line 93: from per_business_groups pbg

89: -- Declare cursor
90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , per_periods_of_placement pdp
95: where pdp.period_of_placement_id = p_period_of_placement_id
96: and pbg.business_group_id = pdp.business_group_id;
97: --

Line 762: l_legislation_code per_business_groups.legislation_code%TYPE;

758: ) is
759: --
760: l_api_updating boolean;
761: l_assigned_payroll boolean;
762: l_legislation_code per_business_groups.legislation_code%TYPE;
763: l_max_end_date date;
764: l_proc varchar2(72)
765: := g_package||'chk_last_standard_process_date';
766: --

Line 769: from per_business_groups_perf bus

765: := g_package||'chk_last_standard_process_date';
766: --
767: cursor csr_get_legislation_code is
768: select bus.legislation_code
769: from per_business_groups_perf bus
770: where bus.business_group_id = p_business_group_id
771: and rownum = 1;
772: -- Bug 3387328. Used _perf view to increase perfomance.
773: --

Line 956: l_legislation_code per_business_groups.legislation_code%TYPE;

952: ) is
953: --
954: l_proc varchar2(72) := g_package||'chk_at_date_lsp_date';
955: l_api_updating boolean;
956: l_legislation_code per_business_groups.legislation_code%TYPE;
957: --
958: cursor csr_get_legislation_code is
959: select bus.legislation_code
960: from per_business_groups_perf bus

Line 960: from per_business_groups_perf bus

956: l_legislation_code per_business_groups.legislation_code%TYPE;
957: --
958: cursor csr_get_legislation_code is
959: select bus.legislation_code
960: from per_business_groups_perf bus
961: where bus.business_group_id = p_business_group_id
962: and rownum = 1;
963: -- Bug 3387328. Used _perf view to improve performance.
964: --