APPS.OTA_TIMEZONE_UPGRADE dependencies on FND_PRODUCT_INSTALLATIONS

Line 51: l_installed fnd_product_installations.status%TYPE;

47: PROCEDURE validate_proc_for_tz_upg(do_upg OUT nocopy VARCHAR2)
48: IS
49: ota_application_id constant NUMBER := 810;
50: ota_status_installed constant VARCHAR2(2) := 'I';
51: l_installed fnd_product_installations.status%TYPE;
52:
53: CURSOR csr_ota_installed IS
54: SELECT fpi.status
55: FROM fnd_product_installations fpi

Line 55: FROM fnd_product_installations fpi

51: l_installed fnd_product_installations.status%TYPE;
52:
53: CURSOR csr_ota_installed IS
54: SELECT fpi.status
55: FROM fnd_product_installations fpi
56: WHERE fpi.application_id = ota_application_id;
57:
58: l_do_submit VARCHAR2(10) := 'FALSE';
59: l_raise_error boolean := FALSE;