APPS.PMI_COST_ANALZ_PACK dependencies on IC_WHSE_MST

Line 25: ic_whse_mst w

21: SELECT d.calendar_code, d.period_code
22: FROM cm_cldr_dtl d,
23: cm_cldr_hdr h,
24: sy_orgn_mst o,
25: ic_whse_mst w
26: WHERE
27: w.whse_code = cost_whse_v
28: AND w.orgn_code = o.orgn_code
29: AND o.co_code = h.co_code

Line 389: ic_whse_mst w

385: INTO cost_calendar_v, cost_period_v
386: FROM cm_cldr_dtl d,
387: cm_cldr_hdr h,
388: sy_orgn_mst o,
389: ic_whse_mst w
390: WHERE
391: w.whse_code = cost_whse_v
392: AND w.orgn_code = o.orgn_code
393: AND o.co_code = h.co_code

Line 974: whse_code_vi IN ic_whse_mst.whse_code%TYPE)

970:
971: END gmca_cost_whse;
972:
973: FUNCTION gmca_whse_currency(
974: whse_code_vi IN ic_whse_mst.whse_code%TYPE)
975: RETURN VARCHAR2
976: IS
977: currency_v gl_plcy_mst.base_currency_code%TYPE := null;
978: CURSOR whse_currency_cur(

Line 979: whse_code_vi IN ic_whse_mst.whse_code%TYPE)

975: RETURN VARCHAR2
976: IS
977: currency_v gl_plcy_mst.base_currency_code%TYPE := null;
978: CURSOR whse_currency_cur(
979: whse_code_vi IN ic_whse_mst.whse_code%TYPE)
980: IS
981: SELECT base_currency_code
982: FROM
983: gl_plcy_mst p,

Line 985: ic_whse_mst w

981: SELECT base_currency_code
982: FROM
983: gl_plcy_mst p,
984: sy_orgn_mst o,
985: ic_whse_mst w
986: WHERE
987: w.whse_code = whse_code_vi
988: AND w.orgn_code = o.orgn_code
989: AND o.co_code = p.co_code ;