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 759: l_legislation_code per_business_groups.legislation_code%TYPE;

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

Line 766: from per_business_groups_perf bus

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

Line 953: l_legislation_code per_business_groups.legislation_code%TYPE;

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

Line 957: from per_business_groups_perf bus

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