APPS.HR_LEGISLATION dependencies on FND_PRODUCT_INSTALLATIONS

Line 1085: , fnd_product_installations b

1081: from dual
1082: where exists (
1083: select null
1084: from hr_s_application_ownerships a
1085: , fnd_product_installations b
1086: , fnd_application c
1087: where a.key_name = 'ASSIGNMENT_STATUS_TYPE_ID'
1088: and a.key_value = l_new_surrogate_key
1089: and a.product_name = c.application_short_name

Line 2130: , fnd_product_installations b

2126: from dual
2127: where exists
2128: (select null
2129: from hr_s_application_ownerships a
2130: , fnd_product_installations b
2131: , fnd_application c
2132: where a.key_name = 'BALANCE_TYPE_ID'
2133: and a.key_value = stu_rec.c_surrogate_key
2134: and a.product_name = c.application_short_name

Line 2146: , fnd_product_installations b

2142: from dual
2143: where exists
2144: (select null
2145: from hr_s_application_ownerships a
2146: , fnd_product_installations b
2147: , fnd_application c
2148: where a.key_name = 'BALANCE_TYPE_ID'
2149: and a.key_value = stu_rec.c_surrogate_key
2150: and a.product_name = c.application_short_name

Line 2205: from fnd_product_installations

2201: -- installed.
2202:
2203: select status
2204: into v_payroll_install_status
2205: from fnd_product_installations
2206: where application_id = 801;
2207:
2208: --
2209: -- Following checks only need to be made if the balance type

Line 3059: , fnd_product_installations b

3055: from dual
3056: where exists
3057: (select null
3058: from hr_s_application_ownerships a
3059: , fnd_product_installations b
3060: , fnd_application c
3061: where a.key_name = 'BALANCE_DIMENSION_ID'
3062: and a.key_value = stu_rec.c_surrogate_key
3063: and a.product_name = c.application_short_name

Line 3075: , fnd_product_installations b

3071: from dual
3072: where exists
3073: (select null
3074: from hr_s_application_ownerships a
3075: , fnd_product_installations b
3076: , fnd_application c
3077: where a.key_name = 'BALANCE_DIMENSION_ID'
3078: and a.key_value = stu_rec.c_surrogate_key
3079: and a.product_name = c.application_short_name

Line 5049: , fnd_product_installations b

5045: from dual
5046: where exists (
5047: select null
5048: from hr_s_application_ownerships a
5049: , fnd_product_installations b
5050: , fnd_application c
5051: where a.key_name = 'USER_ROW_ID'
5052: and a.key_value = r_distinct.c_surrogate_key
5053: and a.product_name = c.application_short_name

Line 5065: , fnd_product_installations b

5061: from dual
5062: where exists (
5063: select null
5064: from hr_s_application_ownerships a
5065: , fnd_product_installations b
5066: , fnd_application c
5067: where a.key_name = 'USER_ROW_ID'
5068: and a.key_value = r_distinct.c_surrogate_key
5069: and a.product_name = c.application_short_name

Line 5606: , fnd_product_installations b

5602: from dual
5603: where exists
5604: (select null
5605: from hr_s_application_ownerships a
5606: , fnd_product_installations b
5607: , fnd_application c
5608: where a.key_name = 'MONETARY_UNIT_ID'
5609: and a.key_value = stu_rec.c_surrogate_key
5610: and a.product_name = c.application_short_name