APPS.GML_VALIDATE_PO dependencies on SY_ORGN_MST

Line 4: FUNCTION val_orgn_code (v_orgn_code IN SY_ORGN_MST.ORGN_CODE%TYPE)

1: PACKAGE BODY GML_VALIDATE_PO AS
2: /* $Header: GMLPOVAB.pls 115.7 99/10/26 11:36:32 porting ship $ */
3:
4: FUNCTION val_orgn_code (v_orgn_code IN SY_ORGN_MST.ORGN_CODE%TYPE)
5: /*========================================================================
6: | |
7: | FUNCTION NAME val_orgn_code |
8: | |

Line 24: FROM sy_orgn_mst

20: v_dummy NUMBER;
21:
22: CURSOR op_orgn_cur IS
23: SELECT 1
24: FROM sy_orgn_mst
25: WHERE orgn_code = v_orgn_code
26: AND delete_mark = 0;
27:
28: BEGIN

Line 169: from sy_orgn_mst

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
172: where whse_code=v_whse_code));
173:

Line 178: from sy_orgn_mst

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:
181: BEGIN
182: OPEN whse_cur;

Line 672: v_orgn_code IN sy_orgn_mst.orgn_code%TYPE)

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);
676:

Line 679: FROM sy_orgn_mst orgn,

675: err_msg VARCHAR2(100);
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: