APPS.HR_LEGISLATION_BENEFITS dependencies on HR_S_APPLICATION_OWNERSHIPS

Line 168: update hr_s_application_ownerships

164:
165: update hr_s_cobra_qfying_events_f
166: set qualifying_event_id = qualifying_event_id - 50000000;
167:
168: update hr_s_application_ownerships
169: set key_value = key_value - 50000000
170: where key_name = 'QUALIFYING_EVENT_ID';
171:
172: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 279: update hr_s_application_ownerships

275: update hr_s_cobra_qfying_events_f
276: set qualifying_event_id = l_new_cqe_id
277: where qualifying_event_id = r_distinct.c_surrogate_key;
278:
279: update hr_s_application_ownerships
280: set key_value = to_char(l_new_cqe_id)
281: where key_value = to_char(r_distinct.c_surrogate_key)
282: and key_name = 'QUALIFYING_EVENT_ID';
283:

Line 394: from hr_s_application_ownerships a

390: into l_null_return
391: from dual
392: where exists
393: (select null
394: from hr_s_application_ownerships a
395: , fnd_product_installations b
396: , fnd_application c
397: where a.key_name = 'QUALIFYING_EVENT_ID'
398: and a.key_value = r_distinct.c_surrogate_key

Line 410: from hr_s_application_ownerships a

406: into l_null_return
407: from dual
408: where exists
409: (select null
410: from hr_s_application_ownerships a
411: , fnd_product_installations b
412: , fnd_application c
413: where a.key_name = 'QUALIFYING_EVENT_ID'
414: and a.key_value = r_distinct.c_surrogate_key

Line 654: update hr_s_application_ownerships

650:
651: update hr_s_benefit_classifications
652: set benefit_classification_id=benefit_classification_id-50000000;
653:
654: update hr_s_application_ownerships
655: set key_value = key_value - 50000000
656: where key_name = 'BENEFIT_CLASSIFICATION_ID';
657:
658: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 746: update hr_s_application_ownerships

742: set benefit_classification_id = l_new_surrogate_key
743: where benefit_classification_id = stu_rec.c_surrogate_key;
744:
745:
746: update hr_s_application_ownerships
747: set key_value = to_char(l_new_surrogate_key)
748: where key_value = to_char(stu_rec.c_surrogate_key)
749: and key_name = 'BENEFIT_CLASSIFICATION_ID';
750:

Line 813: from hr_s_application_ownerships a

809: into l_null_return
810: from dual
811: where exists
812: (select null
813: from hr_s_application_ownerships a
814: , fnd_product_installations b
815: , fnd_application c
816: where a.key_name = 'BENEFIT_CLASSIFICATION_ID'
817: and a.key_value = stu_rec.c_surrogate_key

Line 1148: update hr_s_application_ownerships

1144: update hr_s_valid_dependent_types
1145: set valid_dependent_type_id = l_new_surrogate_key
1146: where valid_dependent_type_id = stu_rec.c_surrogate_key;
1147:
1148: update hr_s_application_ownerships
1149: set key_value = to_char(l_new_surrogate_key)
1150: where key_value = to_char(stu_rec.c_surrogate_key)
1151: and key_name = 'VALID_DEPENDENT_TYPE_ID';
1152:

Line 1208: from hr_s_application_ownerships a

1204: into l_null_return
1205: from dual
1206: where exists
1207: (select null
1208: from hr_s_application_ownerships a
1209: , fnd_product_installations b
1210: , fnd_application c
1211: where a.key_name = 'VALID_DEPENDENT_TYPE_ID'
1212: and a.key_value = stu_rec.c_surrogate_key