DBA Data[Home] [Help]

APPS.OPI_OPM_COMMON_PKG dependencies on GL_PLCY_MST

Line 19: FROM ic_whse_mst a, sy_orgn_mst b, GL_PLCY_MST c

15: WHERE whse_code = l_whse_code;
16: CURSOR CUR_COST_MTHD(l_whse_code IN ic_whse_mst.whse_code%TYPE)
17: IS
18: SELECT b.orgn_code,c.GL_COST_MTHD
19: FROM ic_whse_mst a, sy_orgn_mst b, GL_PLCY_MST c
20: WHERE a.whse_code = l_whse_code
21: AND a.orgn_code = b.orgn_code
22: AND b.co_code = c.co_code;
23:

Line 216: FROM sy_orgn_mst b, GL_PLCY_MST c

212: IS
213: CURSOR CUR_COST_MTHD(l_orgn_code IN sy_orgn_mst.orgn_code%TYPE)
214: IS
215: SELECT b.CO_CODE,c.GL_COST_MTHD
216: FROM sy_orgn_mst b, GL_PLCY_MST c
217: WHERE b.orgn_code = l_orgn_code
218: AND b.co_code = c.co_code;
219:
220: /* Local Variable Declaration */