APPS.PQP_UTILITIES dependencies on PAY_USER_COLUMNS

Line 2168: FROM pay_user_columns

2164: ,p_user_column_name IN VARCHAR2)
2165: IS
2166: SELECT user_column_id
2167: ,user_column_name
2168: FROM pay_user_columns
2169: WHERE user_table_id = p_user_table_id
2170: AND user_column_name like p_user_column_name
2171: AND (
2172: (business_group_id IS NULL AND legislation_code IS NULL)

Line 2223: l_user_column_name pay_user_columns.user_column_name%TYPE;

2219: AND business_group_id = p_business_group_id
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;

Line 2227: l_user_column_id pay_user_columns.user_column_id%TYPE;

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)
2231: := g_package_name || 'get_udt_data';