APPS.GMS_PA_XFACE dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 70: SELECT * from pa_expenditure_items_all

66:
67: adl_rec gms_award_distributions%ROWTYPE;
68: x_flag varchar2(1);
69: CURSOR rev_item(x_expenditure_item_id NUMBER ) IS
70: SELECT * from pa_expenditure_items_all
71: WHERE adjusted_expenditure_item_id = x_expenditure_item_id ;
72:
73: CURSOR new_item(x_expenditure_item_id NUMBER ) IS
74: SELECT * from pa_expenditure_items_all

Line 74: SELECT * from pa_expenditure_items_all

70: SELECT * from pa_expenditure_items_all
71: WHERE adjusted_expenditure_item_id = x_expenditure_item_id ;
72:
73: CURSOR new_item(x_expenditure_item_id NUMBER ) IS
74: SELECT * from pa_expenditure_items_all
75: WHERE transferred_from_exp_item_id = x_expenditure_item_id ;
76:
77: BEGIN
78:

Line 184: from pa_expenditure_items_all

180: where award_id = dest_award_id ;
181:
182: CURSOR C_EXP(x_expenditure_item_id IN NUMBER ) IS
183: select expenditure_type,expenditure_item_date
184: from pa_expenditure_items_all
185: where expenditure_item_id = x_expenditure_item_id;
186:
187: BEGIN
188:

Line 296: SELECT * from pa_expenditure_items_all

292: x_exp_item_id NUMBER;
293: x_new_item_id NUMBER;
294: x_flag varchar2(1) ;
295: CURSOR rev_item(x_exp_item_id NUMBER ) IS
296: SELECT * from pa_expenditure_items_all
297: WHERE adjusted_expenditure_item_id = x_exp_item_id ;
298:
299: CURSOR new_item(x_exp_item_id NUMBER ) IS
300: SELECT * from pa_expenditure_items_all

Line 300: SELECT * from pa_expenditure_items_all

296: SELECT * from pa_expenditure_items_all
297: WHERE adjusted_expenditure_item_id = x_exp_item_id ;
298:
299: CURSOR new_item(x_exp_item_id NUMBER ) IS
300: SELECT * from pa_expenditure_items_all
301: WHERE transferred_from_exp_item_id = x_exp_item_id ;
302:
303: BEGIN
304: