DBA Data[Home] [Help]

APPS.HR_LEGISLATION_BENEFITS dependencies on FND_PRODUCT_INSTALLATIONS

Line 395: , fnd_product_installations b

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

Line 411: , fnd_product_installations b

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

Line 814: , fnd_product_installations b

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

Line 1209: , fnd_product_installations b

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