APPS.PQP_FTE_UTILITIES dependencies on FND_PRODUCT_INSTALLATIONS

Line 33: g_application_id fnd_product_installations.application_id%TYPE;

29: g_column_separator VARCHAR2(10):=' , ';
30: --
31: --
32: -- cache for get_installation_status
33: g_application_id fnd_product_installations.application_id%TYPE;
34: g_status fnd_product_installations.status%TYPE;
35:
36: -- cache for load_cached_constants
37: g_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;

Line 34: g_status fnd_product_installations.status%TYPE;

30: --
31: --
32: -- cache for get_installation_status
33: g_application_id fnd_product_installations.application_id%TYPE;
34: g_status fnd_product_installations.status%TYPE;
35:
36: -- cache for load_cached_constants
37: g_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;
38: g_annual_hours_col_id pay_user_columns.user_column_id%TYPE;

Line 388: FROM fnd_product_installations

384: CURSOR csr_is_installed
385: (p_application_id NUMBER
386: ) IS
387: SELECT status
388: FROM fnd_product_installations
389: WHERE application_id = p_application_id;
390:
391: l_status fnd_product_installations.status%TYPE;
392:

Line 391: l_status fnd_product_installations.status%TYPE;

387: SELECT status
388: FROM fnd_product_installations
389: WHERE application_id = p_application_id;
390:
391: l_status fnd_product_installations.status%TYPE;
392:
393: BEGIN -- get_installation_status
394:
395: IF g_debug THEN

Line 479: l_status fnd_product_installations.status%TYPE;

475: WHERE user_table_id = p_user_table_id
476: AND UPPER(user_column_name) = UPPER(p_user_column_name)
477: AND legislation_code = 'GB';
478:
479: l_status fnd_product_installations.status%TYPE;
480:
481:
482: BEGIN -- load_cached_constants
483: