APPS.HR_LEGISLATION_BENEFITS dependencies on BEN_VALID_DEPENDENT_TYPES

Line 1108: hr_legislation.insert_hr_stu_exceptions('ben_valid_dependent_types'

1104: -- not be raised more than once.
1105:
1106: rollback to vdt;
1107:
1108: hr_legislation.insert_hr_stu_exceptions('ben_valid_dependent_types'
1109: , stu_rec.c_surrogate_key
1110: , exception_type
1111: , stu_rec.c_true_key);
1112:

Line 1126: from ben_valid_dependent_types

1122:
1123:
1124: select distinct valid_dependent_type_id
1125: into l_new_surrogate_key
1126: from ben_valid_dependent_types
1127: where contact_type||coverage_type = stu_rec.c_true_key
1128: and business_group_id is null
1129: and ( (legislation_code is null
1130: and stu_rec.c_leg_code is null)

Line 1136: select ben_valid_dependent_types_s.nextval

1132:
1133: EXCEPTION WHEN NO_DATA_FOUND THEN
1134:
1135:
1136: select ben_valid_dependent_types_s.nextval
1137: into l_new_surrogate_key
1138: from dual;
1139:
1140: END;

Line 1255: from ben_valid_dependent_types a

1251: -- already been created by a user.
1252:
1253: select distinct null
1254: into l_null_return
1255: from ben_valid_dependent_types a
1256: where a.business_group_id is not null
1257: and a.contact_type||a.coverage_type = stu_rec.c_true_key
1258: and exists (select null from per_business_groups b
1259: where b.business_group_id = a.business_group_id

Line 1285: from ben_valid_dependent_types

1281: BEGIN
1282:
1283: select distinct null
1284: into l_null_return
1285: from ben_valid_dependent_types
1286: where contact_type||coverage_type = stu_rec.c_true_key
1287: and nvl(legislation_code,'x') <> nvl(stu_rec.c_leg_code,'x')
1288: and (
1289: legislation_code is null

Line 1330: update ben_valid_dependent_types

1326: return;
1327: END IF;
1328:
1329:
1330: update ben_valid_dependent_types
1331: set business_group_id = stu_rec.business_group_id
1332: , legislation_code = stu_rec.c_leg_code
1333: , contact_type = stu_rec.contact_type
1334: , coverage_type = stu_rec.coverage_type

Line 1346: insert into ben_valid_dependent_types

1342:
1343: IF SQL%NOTFOUND THEN
1344:
1345:
1346: insert into ben_valid_dependent_types
1347: ( valid_dependent_type_id
1348: , business_group_id
1349: , legislation_code
1350: , contact_type