APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PAY_USER_ROWS

Line 121: FROM pay_user_rows_f pur,pay_user_tables put

117: RETURN NUMBER IS
118:
119: CURSOR row_cur (in_claim_date IN DATE) IS
120: SELECT pur.row_low_range_or_name
121: FROM pay_user_rows_f pur,pay_user_tables put
122: WHERE pur.user_table_id = put.user_table_id
123: AND put.user_table_name = p_table_name
124: AND (put.business_group_id = p_business_group_id
125: OR put.legislation_code IS NOT NULL)

Line 153: l_row pay_user_rows.ROW_LOW_RANGE_OR_NAME%TYPE ;

149: INDEX BY BINARY_INTEGER;
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;

Line 1248: , pay_user_rows_f R

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
1252: AND nvl (C.business_group_id,

Line 1298: , pay_user_rows_f R

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
1302: AND nvl (C.business_group_id,

Line 1348: , pay_user_rows_f R

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
1352: and nvl (C.business_group_id,