APPS.PER_PEM_BUS dependencies on PER_BUSINESS_GROUPS

Line 107: from per_business_groups pbg

103: -- Declare cursor
104: --
105: cursor csr_sec_grp is
106: select pbg.security_group_id
107: from per_business_groups pbg
108: , per_previous_employers pem
109: where pem.previous_employer_id = p_previous_employer_id
110: and pbg.business_group_id = pem.business_group_id;
111: --

Line 169: from per_business_groups pbg

165: -- Declare cursor
166: --
167: cursor csr_leg_code is
168: select pbg.legislation_code
169: from per_business_groups pbg
170: , per_previous_employers pem
171: where pem.previous_employer_id = p_previous_employer_id
172: and pbg.business_group_id (+) = pem.business_group_id;
173: --

Line 1211: l_leg_code per_business_groups.legislation_code%TYPE;

1207:
1208: l_proc varchar2(72) := g_package||'chk_start_end_dates';
1209: l_api_updating boolean;
1210:
1211: l_leg_code per_business_groups.legislation_code%TYPE;
1212: CURSOR leg_code IS
1213: SELECT legislation_code
1214: FROM per_business_groups
1215: WHERE business_group_id = p_business_group_id;

Line 1214: FROM per_business_groups

1210:
1211: l_leg_code per_business_groups.legislation_code%TYPE;
1212: CURSOR leg_code IS
1213: SELECT legislation_code
1214: FROM per_business_groups
1215: WHERE business_group_id = p_business_group_id;
1216:
1217: begin
1218: hr_utility.set_location('Entering:'||l_proc, 5);