DBA Data[Home] [Help]

APPS.HR_LEGISLATION_BENEFITS dependencies on FND_APPLICATION

Line 396: , fnd_application c

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
399: and a.product_name = c.application_short_name
400: and c.application_id = b.application_id

Line 412: , fnd_application c

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
415: and a.product_name = c.application_short_name
416: and c.application_id = b.application_id

Line 815: , fnd_application c

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
818: and a.product_name = c.application_short_name
819: and c.application_id = b.application_id

Line 1210: , fnd_application c

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
1213: and a.product_name = c.application_short_name
1214: and c.application_id = b.application_id