APPS.HR_ORGANIZATION dependencies on PER_ASSIGNMENTS_F

Line 1194: -- Doing check on PER_ASSIGNMENTS_F.

1190: --
1191: begin
1192: --
1193: begin
1194: -- Doing check on PER_ASSIGNMENTS_F.
1195: hr_utility.set_location('hr_organization.hr_weak_bg_chk',1);
1196: select '1'
1197: into l_test_func
1198: from sys.dual

Line 1200: from PER_ASSIGNMENTS_F x

1196: select '1'
1197: into l_test_func
1198: from sys.dual
1199: where exists ( select 1
1200: from PER_ASSIGNMENTS_F x
1201: where x.SOURCE_ORGANIZATION_ID = p_organization_id);
1202: --
1203: if SQL%ROWCOUNT >0 THEN
1204: hr_utility.set_message(801,'HR_6718_BG_ASS_EXIST');

Line 1213: -- Doing check on PER_ASSIGNMENTS_F.

1209: null;
1210: end;
1211: --
1212: begin
1213: -- Doing check on PER_ASSIGNMENTS_F.
1214: hr_utility.set_location('hr_organization.hr_weak_bg_chk',2);
1215: select '1'
1216: into l_test_func
1217: from sys.dual

Line 1219: from PER_ASSIGNMENTS_F x

1215: select '1'
1216: into l_test_func
1217: from sys.dual
1218: where exists ( select 1
1219: from PER_ASSIGNMENTS_F x
1220: where x.ORGANIZATION_ID = p_organization_id);
1221: --
1222: if SQL%ROWCOUNT >0 THEN
1223: hr_utility.set_message(801,'HR_6718_BG_ASS_EXIST');