APPS.PER_PDS_BUS dependencies on PER_BUSINESS_GROUPS

Line 768: l_legislation_code per_business_groups.legislation_code%TYPE;

764: ) is
765: --
766: l_api_updating boolean;
767: l_assigned_payroll boolean;
768: l_legislation_code per_business_groups.legislation_code%TYPE;
769: l_max_end_date per_periods_of_service.final_process_date%TYPE;
770: l_proc varchar2(72)
771: := g_package||'chk_last_standard_process_date';
772: --

Line 775: from per_business_groups bus

771: := g_package||'chk_last_standard_process_date';
772: --
773: cursor csr_get_legislation_code is
774: select bus.legislation_code
775: from per_business_groups bus
776: where bus.business_group_id = p_business_group_id;
777: --
778: --
779: begin

Line 981: l_legislation_code per_business_groups.legislation_code%TYPE;

977: ) is
978: --
979: l_proc varchar2(72) := g_package||'chk_at_date_lsp_date';
980: l_api_updating boolean;
981: l_legislation_code per_business_groups.legislation_code%TYPE;
982: --
983: cursor csr_get_legislation_code is
984: select bus.legislation_code
985: from per_business_groups bus

Line 985: from per_business_groups bus

981: l_legislation_code per_business_groups.legislation_code%TYPE;
982: --
983: cursor csr_get_legislation_code is
984: select bus.legislation_code
985: from per_business_groups bus
986: where bus.business_group_id = p_business_group_id;
987: --
988: begin
989: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 2645: from per_business_groups pbg

2641: -- Declare cursor
2642: --
2643: cursor csr_leg_code is
2644: select pbg.legislation_code
2645: from per_business_groups pbg
2646: , per_periods_of_service pds
2647: where pds.period_of_service_id = p_period_of_service_id
2648: and pbg.business_group_id = pds.business_group_id;
2649: --