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 1816: , fnd_application c

1812: where exists (
1813: select null
1814: from hr_s_application_ownerships a
1815: , fnd_product_installations b
1816: , fnd_application c
1817: where a.key_name = 'ELEMENT_TYPE_ID'
1818: and a.key_value = r_distinct.c_surrogate_key
1819: and a.product_name = c.application_short_name
1820: and c.application_id = b.application_id

Line 1832: , fnd_application c

1828: where exists (
1829: select null
1830: from hr_s_application_ownerships a
1831: , fnd_product_installations b
1832: , fnd_application c
1833: where a.key_name = 'ELEMENT_TYPE_ID'
1834: and a.key_value = r_distinct.c_surrogate_key
1835: and a.product_name = c.application_short_name
1836: and c.application_id = b.application_id

Line 2942: , fnd_application c

2938: where exists
2939: (select null
2940: from hr_s_application_ownerships a
2941: , fnd_product_installations b
2942: , fnd_application c
2943: where a.key_name = 'ELEMENT_SET_ID'
2944: and a.key_value = stu_rec.c_surrogate_key
2945: and a.product_name = c.application_short_name
2946: and c.application_id = b.application_id

Line 3537: , fnd_application c

3533: where exists
3534: (select null
3535: from hr_s_application_ownerships a
3536: , fnd_product_installations b
3537: , fnd_application c
3538: where a.key_name = 'USER_TABLE_ID'
3539: and a.key_value = stu_rec.c_surrogate_key
3540: and a.product_name = c.application_short_name
3541: and c.application_id = b.application_id

Line 3553: , fnd_application c

3549: where exists
3550: (select null
3551: from hr_s_application_ownerships a
3552: , fnd_product_installations b
3553: , fnd_application c
3554: where a.key_name = 'USER_TABLE_ID'
3555: and a.key_value = stu_rec.c_surrogate_key
3556: and a.product_name = c.application_short_name
3557: and c.application_id = b.application_id

Line 4055: , fnd_application c

4051: where exists
4052: (select null
4053: from hr_s_application_ownerships a
4054: , fnd_product_installations b
4055: , fnd_application c
4056: where a.key_name = 'USER_COLUMN_ID'
4057: and a.key_value = stu_rec.c_surrogate_key
4058: and a.product_name = c.application_short_name
4059: and c.application_id = b.application_id

Line 4071: , fnd_application c

4067: where exists
4068: (select null
4069: from hr_s_application_ownerships a
4070: , fnd_product_installations b
4071: , fnd_application c
4072: where a.key_name = 'USER_COLUMN_ID'
4073: and a.key_value = stu_rec.c_surrogate_key
4074: and a.product_name = c.application_short_name
4075: and c.application_id = b.application_id