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 1815: , fnd_product_installations b

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

Line 1831: , fnd_product_installations b

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

Line 2208: FROM fnd_product_installations

2204: -- It causes too many side-effects to deliver with HR.
2205: --
2206: SELECT status
2207: INTO l_payroll_install_status
2208: FROM fnd_product_installations
2209: WHERE application_id = 801;
2210:
2211: delete_live_children;
2212:

Line 2941: , fnd_product_installations b

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

Line 3536: , fnd_product_installations b

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

Line 3552: , fnd_product_installations b

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

Line 4054: , fnd_product_installations b

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

Line 4070: , fnd_product_installations b

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