APPS.PER_PDS_BUS dependencies on PER_BUSINESS_GROUPS

Line 789: l_legislation_code per_business_groups.legislation_code%TYPE;

785: ) is
786: --
787: l_api_updating boolean;
788: l_assigned_payroll boolean;
789: l_legislation_code per_business_groups.legislation_code%TYPE;
790: l_max_end_date per_periods_of_service.final_process_date%TYPE;
791: l_proc varchar2(72)
792: := g_package||'chk_last_standard_process_date';
793: --

Line 796: from per_business_groups bus

792: := g_package||'chk_last_standard_process_date';
793: --
794: cursor csr_get_legislation_code is
795: select bus.legislation_code
796: from per_business_groups bus
797: where bus.business_group_id = p_business_group_id;
798: --
799: --
800: begin

Line 1002: l_legislation_code per_business_groups.legislation_code%TYPE;

998: ) is
999: --
1000: l_proc varchar2(72) := g_package||'chk_at_date_lsp_date';
1001: l_api_updating boolean;
1002: l_legislation_code per_business_groups.legislation_code%TYPE;
1003: --
1004: cursor csr_get_legislation_code is
1005: select bus.legislation_code
1006: from per_business_groups bus

Line 1006: from per_business_groups bus

1002: l_legislation_code per_business_groups.legislation_code%TYPE;
1003: --
1004: cursor csr_get_legislation_code is
1005: select bus.legislation_code
1006: from per_business_groups bus
1007: where bus.business_group_id = p_business_group_id;
1008: --
1009: begin
1010: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 2666: from per_business_groups pbg

2662: -- Declare cursor
2663: --
2664: cursor csr_leg_code is
2665: select pbg.legislation_code
2666: from per_business_groups pbg
2667: , per_periods_of_service pds
2668: where pds.period_of_service_id = p_period_of_service_id
2669: and pbg.business_group_id = pds.business_group_id;
2670: --