APPS.BEN_MANAGE_LIFE_EVENTS dependencies on PER_BUSINESS_GROUPS

Line 7879: from per_business_groups

7875: l_popl_enrt_typ_cycl_id number ;
7876: --
7877: cursor c_people_group_structure is
7878: select people_group_structure
7879: from per_business_groups
7880: where business_group_id = p_business_group_id;
7881: --
7882: l_id_flex_num per_business_groups.people_group_structure%TYPE;
7883: --

Line 7882: l_id_flex_num per_business_groups.people_group_structure%TYPE;

7878: select people_group_structure
7879: from per_business_groups
7880: where business_group_id = p_business_group_id;
7881: --
7882: l_id_flex_num per_business_groups.people_group_structure%TYPE;
7883: --
7884: --
7885: l_ler_override_id number;
7886: l_trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type;

Line 8934: l_bus_rec per_business_groups%rowtype;

8930: l_package varchar2(80);
8931: l_output_string nvarchar2(100);
8932: l_per_rec per_all_people_f%rowtype;
8933: l_ass_rec per_all_assignments_f%rowtype;
8934: l_bus_rec per_business_groups%rowtype;
8935: l_org_rec hr_all_organization_units%rowtype;
8936: l_org2_rec hr_all_organization_units%rowtype;
8937: l_pad_rec per_addresses%rowtype;
8938: l_loc_rec hr_locations_all%rowtype;

Line 9120: l_bus_rec per_business_groups%ROWTYPE;

9116: l_package VARCHAR2 (80);
9117: l_output_string NVARCHAR2 (100);
9118: l_per_rec per_all_people_f%ROWTYPE;
9119: l_ass_rec per_all_assignments_f%ROWTYPE;
9120: l_bus_rec per_business_groups%ROWTYPE;
9121: l_org_rec hr_all_organization_units%ROWTYPE;
9122: l_org2_rec hr_all_organization_units%ROWTYPE;
9123: l_pad_rec per_addresses%ROWTYPE;
9124: l_loc_rec hr_locations_all%ROWTYPE;