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 371: FROM fnd_product_installations

367: CURSOR csr_is_installed
368: (p_application_id NUMBER
369: ) IS
370: SELECT status
371: FROM fnd_product_installations
372: WHERE application_id = p_application_id;
373:
374: l_status fnd_product_installations.status%TYPE;
375:

Line 374: l_status fnd_product_installations.status%TYPE;

370: SELECT status
371: FROM fnd_product_installations
372: WHERE application_id = p_application_id;
373:
374: l_status fnd_product_installations.status%TYPE;
375:
376: BEGIN -- get_installation_status
377:
378: IF g_debug THEN

Line 462: l_status fnd_product_installations.status%TYPE;

458: WHERE user_table_id = p_user_table_id
459: AND UPPER(user_column_name) = UPPER(p_user_column_name)
460: AND legislation_code = 'GB';
461:
462: l_status fnd_product_installations.status%TYPE;
463:
464:
465: BEGIN -- load_cached_constants
466: