DBA Data[Home] [Help]

APPS.HR_LEGISLATION_ELEMENTS dependencies on FND_APPLICATION

Line 379: , fnd_application c

375: where exists
376: (select null
377: from hr_s_application_ownerships a
378: , fnd_product_installations b
379: , fnd_application c
380: where a.key_name = 'CLASSIFICATION_ID'
381: and a.key_value = stu_rec.c_surrogate_key
382: and a.product_name = c.application_short_name
383: and c.application_id = b.application_id

Line 395: , fnd_application c

391: where exists
392: (select null
393: from hr_s_application_ownerships a
394: , fnd_product_installations b
395: , fnd_application c
396: where a.key_name = 'CLASSIFICATION_ID'
397: and a.key_value = stu_rec.c_surrogate_key
398: and a.product_name = c.application_short_name
399: and c.application_id = b.application_id

Line 1837: , fnd_application c

1833: where exists (
1834: select null
1835: from hr_s_application_ownerships a
1836: , fnd_product_installations b
1837: , fnd_application c
1838: where a.key_name = 'ELEMENT_TYPE_ID'
1839: and a.key_value = r_distinct.c_surrogate_key
1840: and a.product_name = c.application_short_name
1841: and c.application_id = b.application_id

Line 1853: , fnd_application c

1849: where exists (
1850: select null
1851: from hr_s_application_ownerships a
1852: , fnd_product_installations b
1853: , fnd_application c
1854: where a.key_name = 'ELEMENT_TYPE_ID'
1855: and a.key_value = r_distinct.c_surrogate_key
1856: and a.product_name = c.application_short_name
1857: and c.application_id = b.application_id

Line 2974: , fnd_application c

2970: where exists
2971: (select null
2972: from hr_s_application_ownerships a
2973: , fnd_product_installations b
2974: , fnd_application c
2975: where a.key_name = 'ELEMENT_SET_ID'
2976: and a.key_value = stu_rec.c_surrogate_key
2977: and a.product_name = c.application_short_name
2978: and c.application_id = b.application_id

Line 3569: , fnd_application c

3565: where exists
3566: (select null
3567: from hr_s_application_ownerships a
3568: , fnd_product_installations b
3569: , fnd_application c
3570: where a.key_name = 'USER_TABLE_ID'
3571: and a.key_value = stu_rec.c_surrogate_key
3572: and a.product_name = c.application_short_name
3573: and c.application_id = b.application_id

Line 3585: , fnd_application c

3581: where exists
3582: (select null
3583: from hr_s_application_ownerships a
3584: , fnd_product_installations b
3585: , fnd_application c
3586: where a.key_name = 'USER_TABLE_ID'
3587: and a.key_value = stu_rec.c_surrogate_key
3588: and a.product_name = c.application_short_name
3589: and c.application_id = b.application_id

Line 4087: , fnd_application c

4083: where exists
4084: (select null
4085: from hr_s_application_ownerships a
4086: , fnd_product_installations b
4087: , fnd_application c
4088: where a.key_name = 'USER_COLUMN_ID'
4089: and a.key_value = stu_rec.c_surrogate_key
4090: and a.product_name = c.application_short_name
4091: and c.application_id = b.application_id

Line 4103: , fnd_application c

4099: where exists
4100: (select null
4101: from hr_s_application_ownerships a
4102: , fnd_product_installations b
4103: , fnd_application c
4104: where a.key_name = 'USER_COLUMN_ID'
4105: and a.key_value = stu_rec.c_surrogate_key
4106: and a.product_name = c.application_short_name
4107: and c.application_id = b.application_id