APPS.BEN_MANAGE_LIFE_EVENTS dependencies on PER_BUSINESS_GROUPS

Line 7473: from per_business_groups

7469: l_popl_enrt_typ_cycl_id number ;
7470: --
7471: cursor c_people_group_structure is
7472: select people_group_structure
7473: from per_business_groups
7474: where business_group_id = p_business_group_id;
7475: --
7476: l_id_flex_num per_business_groups.people_group_structure%TYPE;
7477: --

Line 7476: l_id_flex_num per_business_groups.people_group_structure%TYPE;

7472: select people_group_structure
7473: from per_business_groups
7474: where business_group_id = p_business_group_id;
7475: --
7476: l_id_flex_num per_business_groups.people_group_structure%TYPE;
7477: --
7478: --
7479: l_ler_override_id number;
7480: l_trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type;

Line 8526: l_bus_rec per_business_groups%rowtype;

8522: l_package varchar2(80);
8523: l_output_string varchar2(100);
8524: l_per_rec per_all_people_f%rowtype;
8525: l_ass_rec per_all_assignments_f%rowtype;
8526: l_bus_rec per_business_groups%rowtype;
8527: l_org_rec hr_all_organization_units%rowtype;
8528: l_org2_rec hr_all_organization_units%rowtype;
8529: l_pad_rec per_addresses%rowtype;
8530: l_loc_rec hr_locations_all%rowtype;

Line 8712: l_bus_rec per_business_groups%ROWTYPE;

8708: l_package VARCHAR2 (80);
8709: l_output_string VARCHAR2 (100);
8710: l_per_rec per_all_people_f%ROWTYPE;
8711: l_ass_rec per_all_assignments_f%ROWTYPE;
8712: l_bus_rec per_business_groups%ROWTYPE;
8713: l_org_rec hr_all_organization_units%ROWTYPE;
8714: l_org2_rec hr_all_organization_units%ROWTYPE;
8715: l_pad_rec per_addresses%ROWTYPE;
8716: l_loc_rec hr_locations_all%ROWTYPE;