DBA Data[Home] [Help]

APPS.HR_ORGANIZATION dependencies on BEN_BENEFICIARIES_F

Line 1154: -- Do any rows exist in BEN_BENEFICIARIES_F

1150: null;
1151: end;
1152: --
1153: begin
1154: -- Do any rows exist in BEN_BENEFICIARIES_F
1155: hr_utility.set_location('hr_organization.org_predel_check', 6);
1156: select '1'
1157: into l_test_func
1158: from sys.dual

Line 1160: from BEN_BENEFICIARIES_F x

1156: select '1'
1157: into l_test_func
1158: from sys.dual
1159: where exists (select 1
1160: from BEN_BENEFICIARIES_F x
1161: where x.source_id = p_organization_id
1162: and x.source_type = 'O');
1163: --
1164: if SQL%ROWCOUNT >0 THEN