APPS.PQP_FTE_UTILITIES dependencies on PAY_USER_TABLES

Line 37: g_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;

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;
39: g_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
40: g_not_cached_constants BOOLEAN:=TRUE;
41:

Line 448: FROM pay_user_tables

444: g_package_name||'load_cached_constants';
445:
446: CURSOR csr_pqp_contract_table IS
447: SELECT user_table_id
448: FROM pay_user_tables
449: WHERE user_table_name = 'PQP_CONTRACT_TYPES'
450: AND legislation_code = 'GB';
451:
452: CURSOR csr_relevant_columns

Line 1352: l_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;

1348: l_proc_name VARCHAR2(61):= 'get_contract_details';
1349: l_contract_details csr_contract_details%ROWTYPE;
1350: l_assignment_contract csr_assignment_contract%ROWTYPE;
1351:
1352: l_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;
1353: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;
1354: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
1355:
1356: BEGIN -- get_contract_details

Line 1664: l_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;

1660:
1661: i BINARY_INTEGER:=0;
1662: l_max_iterations BINARY_INTEGER:= 10000;
1663:
1664: l_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;
1665: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;
1666: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
1667:
1668: