APPS.HR_LEGISLATION dependencies on FND_PRODUCT_INSTALLATIONS

Line 880: , fnd_product_installations b

876: from dual
877: where exists (
878: select null
879: from hr_s_application_ownerships a
880: , fnd_product_installations b
881: , fnd_application c
882: where a.key_name = 'ASSIGNMENT_STATUS_TYPE_ID'
883: and a.key_value = l_new_surrogate_key
884: and a.product_name = c.application_short_name

Line 1913: , fnd_product_installations b

1909: from dual
1910: where exists
1911: (select null
1912: from hr_s_application_ownerships a
1913: , fnd_product_installations b
1914: , fnd_application c
1915: where a.key_name = 'BALANCE_TYPE_ID'
1916: and a.key_value = stu_rec.c_surrogate_key
1917: and a.product_name = c.application_short_name

Line 1929: , fnd_product_installations b

1925: from dual
1926: where exists
1927: (select null
1928: from hr_s_application_ownerships a
1929: , fnd_product_installations b
1930: , fnd_application c
1931: where a.key_name = 'BALANCE_TYPE_ID'
1932: and a.key_value = stu_rec.c_surrogate_key
1933: and a.product_name = c.application_short_name

Line 1988: from fnd_product_installations

1984: -- installed.
1985:
1986: select status
1987: into v_payroll_install_status
1988: from fnd_product_installations
1989: where application_id = 801;
1990:
1991: --
1992: -- Following checks only need to be made if the balance type

Line 2813: , fnd_product_installations b

2809: from dual
2810: where exists
2811: (select null
2812: from hr_s_application_ownerships a
2813: , fnd_product_installations b
2814: , fnd_application c
2815: where a.key_name = 'BALANCE_DIMENSION_ID'
2816: and a.key_value = stu_rec.c_surrogate_key
2817: and a.product_name = c.application_short_name

Line 2829: , fnd_product_installations b

2825: from dual
2826: where exists
2827: (select null
2828: from hr_s_application_ownerships a
2829: , fnd_product_installations b
2830: , fnd_application c
2831: where a.key_name = 'BALANCE_DIMENSION_ID'
2832: and a.key_value = stu_rec.c_surrogate_key
2833: and a.product_name = c.application_short_name

Line 4799: , fnd_product_installations b

4795: from dual
4796: where exists (
4797: select null
4798: from hr_s_application_ownerships a
4799: , fnd_product_installations b
4800: , fnd_application c
4801: where a.key_name = 'USER_ROW_ID'
4802: and a.key_value = r_distinct.c_surrogate_key
4803: and a.product_name = c.application_short_name

Line 4815: , fnd_product_installations b

4811: from dual
4812: where exists (
4813: select null
4814: from hr_s_application_ownerships a
4815: , fnd_product_installations b
4816: , fnd_application c
4817: where a.key_name = 'USER_ROW_ID'
4818: and a.key_value = r_distinct.c_surrogate_key
4819: and a.product_name = c.application_short_name

Line 5356: , fnd_product_installations b

5352: from dual
5353: where exists
5354: (select null
5355: from hr_s_application_ownerships a
5356: , fnd_product_installations b
5357: , fnd_application c
5358: where a.key_name = 'MONETARY_UNIT_ID'
5359: and a.key_value = stu_rec.c_surrogate_key
5360: and a.product_name = c.application_short_name