APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_USER_ROWS_F

Line 73: ,pay_user_rows_f pur

69: )
70: IS
71: SELECT pur.user_row_id,pur.row_low_range_or_name,put.user_table_id
72: FROM pay_user_tables put
73: ,pay_user_rows_f pur
74: WHERE put.range_or_match = 'M'
75: AND put.user_table_name ='PQP_TRAVEL_PURPOSE'
76: AND put.user_table_id = pur.user_table_id
77: AND cp_effective_date BETWEEN pur.effective_start_date

Line 2480: ,pay_user_rows_f pur

2476: CURSOR c_get_purpose_name
2477: IS
2478: SELECT pur.row_low_range_or_name
2479: FROM pay_user_tables put
2480: ,pay_user_rows_f pur
2481: WHERE put.range_or_match = 'M'
2482: AND put.user_table_name ='PQP_TRAVEL_PURPOSE'
2483: AND put.user_table_id = pur.user_table_id
2484: AND pur.user_row_id= p_field_id;

Line 2602: ,pay_user_rows_f pur

2598: CURSOR c_get_purpose_name
2599: IS
2600: SELECT pur.row_low_range_or_name
2601: FROM pay_user_tables put
2602: ,pay_user_rows_f pur
2603: WHERE put.range_or_match = 'M'
2604: AND put.user_table_name ='PQP_TRAVEL_PURPOSE'
2605: AND put.user_table_id = pur.user_table_id
2606: AND pur.user_row_id= p_code;