APPS.PQH_GSP_DEFAULT dependencies on PER_BUSINESS_GROUPS

Line 34: l_legislation_code per_business_groups.legislation_code%type;

30: l_procd_dt date;
31: l_strtd_dt date;
32: l_voidd_dt date;
33: l_Assignment_id Per_All_Assignments_F.Assignment_Id%TYPE;
34: l_legislation_code per_business_groups.legislation_code%type;
35: l_return_status varchar2(1);
36:
37: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
38: l_ptnl_ler_for_per_ovn ben_ptnl_ler_for_per.object_version_number%type;

Line 50: from per_business_groups bg, ben_per_in_ler pil

46: and per.ptnl_ler_for_per_id = ptnl.ptnl_ler_for_per_id;
47:
48: cursor lesgislation_info is
49: Select legislation_code
50: from per_business_groups bg, ben_per_in_ler pil
51: where pil.business_group_id = bg.business_group_id
52: and pil.per_in_ler_id = p_per_in_ler_id;
53: begin
54: -- This routine will be called by benmngle run to determine whether out of electable choice progressions