DBA Data[Home] [Help]

APPS.JAI_OPM_GMD_TRIGGER_PKG dependencies on GME_BATCH_HEADER

Line 24: from gme_batch_header

20:
21: Cursor C_batch_no is
22: SELECT batch_no, batch_status --, wip_whse_code
23: , ja_osp_batch
24: from gme_batch_header
25: WHERE batch_id =pr_new.batch_id;
26:
27: Cursor C_Rec_Exist IS SELECT rowid, unit_price FROM JAI_OPM_OSP_DTLS
28: WHERE osp_header_id = pr_new.batch_id

Line 78: l_ja_osp_batch gme_batch_header.ja_osp_batch%type;

74: l_excise_payable NUMBER;
75: l_noninv_ind Number(1);
76: l_whse_orgn varchar2(4);
77: l_batch_no varchar2(32);
78: l_ja_osp_batch gme_batch_header.ja_osp_batch%type;
79:
80: v_file_name varchar2(30);
81: ln_po_id number;
82: