eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LEGISLATION_ELEMENTS dependencies on FND_PRODUCT_INSTALLATIONS

Line 378: , fnd_product_installations b

374: from dual
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

Line 394: , fnd_product_installations b

390: from dual
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

Line 1836: , fnd_product_installations b

1832: from dual
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

Line 1852: , fnd_product_installations b

1848: from dual
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

Line 2240: FROM fnd_product_installations

2236: -- It causes too many side-effects to deliver with HR.
2237: --
2238: SELECT status
2239: INTO l_payroll_install_status
2240: FROM fnd_product_installations
2241: WHERE application_id = 801;
2242:
2243: delete_live_children;
2244:

Line 2973: , fnd_product_installations b

2969: from dual
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

Line 3568: , fnd_product_installations b

3564: from dual
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

Line 3584: , fnd_product_installations b

3580: from dual
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

Line 4086: , fnd_product_installations b

4082: from dual
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

Line 4102: , fnd_product_installations b

4098: from dual
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