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 43: SELECT form_name FROM JAI_OPM_OSP_HDRS

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