APPS.GML_VALIDATE_PO dependencies on GL_PLCY_MST

Line 167: from gl_plcy_mst

163: v_org_sob NUMBER;
164:
165: CURSOR whse_cur IS
166: SELECT distinct sob_id
167: from gl_plcy_mst
168: where co_code = (select co_code
169: from sy_orgn_mst
170: where orgn_code = (select orgn_code
171: from ic_whse_mst

Line 176: from gl_plcy_mst

172: where whse_code=v_whse_code));
173:
174: CURSOR org_cur IS
175: SELECT distinct sob_id
176: from gl_plcy_mst
177: where co_code = (select co_code
178: from sy_orgn_mst
179: where orgn_code = v_orgn_code);
180:

Line 671: (v_base_currency_code OUT gl_plcy_mst.base_currency_code%TYPE,

667: | 10/22/97 Kenny Jiang created |
668: | | =========================================================================*/
669:
670: PROCEDURE get_base_currency
671: (v_base_currency_code OUT gl_plcy_mst.base_currency_code%TYPE,
672: v_orgn_code IN sy_orgn_mst.orgn_code%TYPE)
673: IS
674: err_num NUMBER;
675: err_msg VARCHAR2(100);

Line 680: gl_plcy_mst plcy

676:
677: CURSOR base_currency_cur IS
678: SELECT plcy.base_currency_code
679: FROM sy_orgn_mst orgn,
680: gl_plcy_mst plcy
681: WHERE orgn.orgn_code = v_orgn_code AND
682: orgn.co_code = plcy.co_code;
683:
684: BEGIN