APPS.PQP_HRTCA_INTEGRATION dependencies on PER_BUSINESS_GROUPS

Line 95: FROM per_business_groups pbg

91:
92: -- Cursor to get the leg. code
93: CURSOR csr_bg_code (c_bg_grp_id IN Number) IS
94: SELECT pbg.legislation_code
95: FROM per_business_groups pbg
96: WHERE pbg.business_group_id = c_bg_grp_id;
97:
98: -- Cursor to get the TCA location
99: CURSOR csr_hz_loc (c_location_id IN Number) IS

Line 3165: l_business_group_id per_business_groups.business_group_id%TYPE;

3161: csr_dt csr_oss_t;
3162: l_concat_add_string Varchar2(1000);
3163: l_HZ_Loc_Row Hz_Locations%ROWTYPE;
3164: l_HR_Address_Rec Per_addresses%ROWTYPE;
3165: l_business_group_id per_business_groups.business_group_id%TYPE;
3166: l_effective_date Date;
3167: BEGIN
3168: -- Get the HZ Locations details based on the id
3169: OPEN csr_hz_loc (c_location_id => p_location_id);

Line 3228: l_business_group_id per_business_groups.business_group_id%TYPE;

3224: TYPE csr_oss_t IS REF CURSOR;
3225: csr_dt csr_oss_t;
3226: l_HZ_Loc_Row Hz_Locations%ROWTYPE;
3227: l_HR_Address_Rec Per_addresses%ROWTYPE;
3228: l_business_group_id per_business_groups.business_group_id%TYPE;
3229: l_effective_date Date;
3230: l_return_value Varchar2(150);
3231:
3232: BEGIN