APPS.PQP_UTILITIES dependencies on PAY_USER_ROWS_F

Line 2189: FROM pay_user_rows_f

2185: IS
2186: SELECT user_row_id
2187: ,row_low_range_or_name
2188: ,row_high_range
2189: FROM pay_user_rows_f
2190: WHERE user_table_id = p_user_table_id
2191: AND TRUNC(p_effective_date) BETWEEN effective_start_date
2192: AND effective_end_date
2193: AND (

Line 2224: l_user_row_name pay_user_rows_f.row_low_range_or_name%TYPE;

2220: )
2221: );
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;

Line 2228: l_user_row_id pay_user_rows_f.user_row_id%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)
2231: := g_package_name || 'get_udt_data';
2232: l_row_high_range pay_user_rows_f.row_high_range%TYPE;

Line 2232: l_row_high_range pay_user_rows_f.row_high_range%TYPE;

2228: l_user_row_id pay_user_rows_f.user_row_id%TYPE;
2229: l_idx NUMBER;
2230: l_proc_name VARCHAR2(60)
2231: := g_package_name || 'get_udt_data';
2232: l_row_high_range pay_user_rows_f.row_high_range%TYPE;
2233: l_column_name VARCHAR2(240);
2234: BEGIN
2235: g_debug := hr_utility.debug_enabled;
2236: IF g_debug THEN