APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PAY_USER_COLUMNS

Line 132: FROM pay_user_columns puc

128: ORDER BY pur.row_low_range_or_name;
129:
130: CURSOR col_cur (in_claim_date IN DATE)IS
131: SELECT puc.user_column_name
132: FROM pay_user_columns puc
133: ,pay_user_tables put
134: ,pay_user_column_instances_f puci
135: WHERE puc.user_table_id = put.user_table_id
136: AND put.user_table_name = p_table_name

Line 154: l_col pay_user_columns.USER_COLUMN_NAME%TYPE ;

150:
151: l_value t_value;
152: l_temp NUMBER;
153: l_row pay_user_rows.ROW_LOW_RANGE_OR_NAME%TYPE ;
154: l_col pay_user_columns.USER_COLUMN_NAME%TYPE ;
155: l_val_to_return NUMBER;
156: l_temp_num NUMBER;
157: l_counter NUMBER := 0;
158: l_effective_date DATE;

Line 1247: , pay_user_columns C

1243: hr_utility.set_location ('hruserdt.get_table_value', 4);
1244: SELECT CINST.value
1245: INTO l_value
1246: FROM pay_user_column_instances_f CINST
1247: , pay_user_columns C
1248: , pay_user_rows_f R
1249: , pay_user_tables TAB
1250: WHERE TAB.user_table_id = l_table_id
1251: AND C.user_table_id = TAB.user_table_id

Line 1297: , pay_user_columns C

1293:
1294: SELECT CINST.value
1295: INTO l_value
1296: FROM pay_user_column_instances_f CINST
1297: , pay_user_columns C
1298: , pay_user_rows_f R
1299: , pay_user_tables TAB
1300: WHERE TAB.user_table_id = l_table_id
1301: AND C.user_table_id = TAB.user_table_id

Line 1347: , pay_user_columns C

1343: hr_utility.set_location ('hruserdt.get_table_value', 5);
1344: select CINST.value
1345: into l_value
1346: from pay_user_column_instances_f CINST
1347: , pay_user_columns C
1348: , pay_user_rows_f R
1349: , pay_user_tables TAB
1350: where TAB.user_table_id = l_table_id
1351: and C.user_table_id = TAB.user_table_id