APPS.PQP_UTILITIES dependencies on PAY_USER_TABLES

Line 2073: l_table_name pay_user_tables.user_table_name%TYPE;

2069: RETURN NUMBER
2070: IS
2071: l_proc_name VARCHAR2(61)
2072: := g_package_name || 'pqp_gb_get_table_value_id';
2073: l_table_name pay_user_tables.user_table_name%TYPE;
2074: l_retval NUMBER;
2075: BEGIN
2076: --
2077: IF g_debug THEN

Line 2152: FROM pay_user_tables tbls

2148: IS
2149: CURSOR csr_get_table_id(p_udt_name IN VARCHAR2)
2150: IS
2151: SELECT tbls.user_table_id
2152: FROM pay_user_tables tbls
2153: WHERE tbls.user_table_name = p_udt_name
2154: AND (
2155: (business_group_id IS NULL AND legislation_code IS NULL)
2156: OR (legislation_code IS NOT NULL AND legislation_code = 'GB')

Line 2226: l_user_table_id pay_user_tables.user_table_id%TYPE;

2222:
2223: l_user_column_name pay_user_columns.user_column_name%TYPE;
2224: l_user_row_name pay_user_rows_f.row_low_range_or_name%TYPE;
2225: l_matrix_value pay_user_column_instances_f.VALUE%TYPE;
2226: l_user_table_id pay_user_tables.user_table_id%TYPE;
2227: l_user_column_id pay_user_columns.user_column_id%TYPE;
2228: l_user_row_id pay_user_rows_f.user_row_id%TYPE;
2229: l_idx NUMBER;
2230: l_proc_name VARCHAR2(60)

Line 2337: FROM pay_user_tables udt

2333: IS
2334: CURSOR csr_get_range_match(p_table_name IN VARCHAR2)
2335: IS
2336: SELECT udt.range_or_match
2337: FROM pay_user_tables udt
2338: WHERE user_table_name = p_table_name;
2339:
2340: l_range_match csr_get_range_match%ROWTYPE;
2341: l_return_value pay_user_column_instances_f.VALUE%TYPE;