APPS.GML_PO_GLDIST dependencies on SY_ORGN_MST

Line 422: FROM sy_orgn_mst orgn, gl_plcy_mst plcy

418: X_co_code VARCHAR2(5);
419:
420: CURSOR Cur_base_curr IS
421: SELECT plcy.base_currency_code
422: FROM sy_orgn_mst orgn, gl_plcy_mst plcy
423: WHERE orgn.orgn_code = V_orgn_code and orgn.co_code = plcy.co_code;
424:
425: CURSOR Cur_orgn_mst IS
426: SELECT co_code

Line 427: FROM sy_orgn_mst

423: WHERE orgn.orgn_code = V_orgn_code and orgn.co_code = plcy.co_code;
424:
425: CURSOR Cur_orgn_mst IS
426: SELECT co_code
427: FROM sy_orgn_mst
428: WHERE orgn_code = V_orgn_code;
429:
430: /* RVK B1394532 */
431: CURSOR Cur_whse_co_code IS

Line 433: FROM sy_orgn_mst mst, ic_whse_mst ic

429:
430: /* RVK B1394532 */
431: CURSOR Cur_whse_co_code IS
432: SELECT mst.co_code, mst.orgn_code
433: FROM sy_orgn_mst mst, ic_whse_mst ic
434: WHERE ic.whse_code = v_to_whse and
435: mst.orgn_code = ic.orgn_code;
436:
437: CURSOR Cur_acctg_unit_id IS

Line 830: X_orgn_code sy_orgn_mst.orgn_code%TYPE;

826:
827: X_acctg_orgn VARCHAR2(10);
828: X_acctg_whse VARCHAR2(10);
829: X_map_orgn_ind gl_sevt_ttl.map_orgn_ind%TYPE;
830: X_orgn_code sy_orgn_mst.orgn_code%TYPE;
831: X_co_code sy_orgn_mst.co_code%TYPE;
832:
833: BEGIN
834:

Line 831: X_co_code sy_orgn_mst.co_code%TYPE;

827: X_acctg_orgn VARCHAR2(10);
828: X_acctg_whse VARCHAR2(10);
829: X_map_orgn_ind gl_sevt_ttl.map_orgn_ind%TYPE;
830: X_orgn_code sy_orgn_mst.orgn_code%TYPE;
831: X_co_code sy_orgn_mst.co_code%TYPE;
832:
833: BEGIN
834:
835: X_orgn_code := P_orgn_code;