APPS.PMI_COMMON_PKG dependencies on SY_ORGN_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 26: l_orgn_code sy_orgn_mst.orgn_code%TYPE;

22: AND b.co_code = c.co_code;
23:
24: /* Local Variable Declaration */
25: l_whse_code ic_whse_mst.whse_code%TYPE;
26: l_orgn_code sy_orgn_mst.orgn_code%TYPE;
27: l_cmpntcls_ind CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;
28: l_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;
29: l_total_cost NUMBER;
30: l_no_of_rows NUMBER;