DBA Data[Home] [Help]

APPS.GML_PO_RECV1_PKG dependencies on GL_PLCY_MST

Line 150: v_org_id gl_plcy_mst.org_id%TYPE;

146:
147: PROCEDURE sum_recv AS
148: v_po_no po_ordr_hdr.po_no%TYPE;
149: v_line_no po_ordr_dtl.line_no%TYPE;
150: v_org_id gl_plcy_mst.org_id%TYPE;
151: v_orgn_code po_ordr_hdr.orgn_code%TYPE;
152: v_returned_qty po_rtrn_dtl.return_qty1%TYPE;
153: v_received_qty po_recv_dtl.recv_qty1%TYPE;
154: v_status po_ordr_dtl.po_status%TYPE;

Line 197: FROM gl_plcy_mst g, sy_orgn_mst o

193: line_id = vc_line_id;
194:
195: CURSOR org_cur IS
196: SELECT g.org_id
197: FROM gl_plcy_mst g, sy_orgn_mst o
198: WHERE o.orgn_code = v_orgn_code
199: AND o.co_code = g.co_code;
200:
201: /* Added these 2 cursors for Bug# 1094230 */