DBA Data[Home] [Help]

APPS.PQP_UTILITIES dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 2211: FROM pay_user_column_instances_f

2207: IS
2208: SELECT VALUE
2209: ,effective_start_date
2210: ,effective_end_date
2211: FROM pay_user_column_instances_f
2212: WHERE user_column_id = p_user_column_id
2213: AND user_row_id = p_user_row_id
2214: AND (
2215: (business_group_id IS NULL AND legislation_code IS NULL)

Line 2225: l_matrix_value pay_user_column_instances_f.VALUE%TYPE;

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;
2229: l_idx NUMBER;

Line 2341: l_return_value pay_user_column_instances_f.VALUE%TYPE;

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;
2342: l_proc_name VARCHAR2(70)
2343: := g_package_name || 'get_udt_value';
2344: i NUMBER;
2345: BEGIN