DBA Data[Home] [Help]

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 2494: ,pay_user_rows_f pur

2490: CURSOR c_get_purpose_name
2491: IS
2492: SELECT pur.row_low_range_or_name
2493: FROM pay_user_tables put
2494: ,pay_user_rows_f pur
2495: WHERE put.range_or_match = 'M'
2496: AND put.user_table_name ='PQP_TRAVEL_PURPOSE'
2497: AND put.user_table_id = pur.user_table_id
2498: AND pur.user_row_id= p_field_id;

Line 2616: ,pay_user_rows_f pur

2612: CURSOR c_get_purpose_name
2613: IS
2614: SELECT pur.row_low_range_or_name
2615: FROM pay_user_tables put
2616: ,pay_user_rows_f pur
2617: WHERE put.range_or_match = 'M'
2618: AND put.user_table_name ='PQP_TRAVEL_PURPOSE'
2619: AND put.user_table_id = pur.user_table_id
2620: AND pur.user_row_id= p_code;