APPS.JAI_OPM_GMD_TRIGGER_PKG dependencies on JAI_OPM_OSP_HDRS

Line 18: FROM JAI_OPM_OSP_HDRS

14: PROCEDURE ARU_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
15:
16: Cursor C_chk_hdr IS
17: SELECT po_id
18: FROM JAI_OPM_OSP_HDRS
19: WHERE osp_header_id = pr_new.batch_id ;
20:
21: Cursor C_batch_no is
22: SELECT batch_no, batch_status --, wip_whse_code

Line 42: SELECT form_name FROM JAI_OPM_OSP_HDRS

38: FROM JAI_OPM_OSP_EXC_RATES
39: WHERE form_name = P_Form_Name;
40:
41: Cursor C_Form_name IS
42: SELECT form_name FROM JAI_OPM_OSP_HDRS
43: WHERE osp_header_id = pr_new.batch_id;
44:
45: Cursor C_Inv_Ind(cp_organization_id number, cp_inventory_item_id number) IS
46: select decode(inventory_item_flag, 'Y', 0, 1) noninv_ind