DBA Data[Home] [Help]

APPS.PMI_COST_ANALZ_PACK dependencies on CM_CLDR_HDR

Line 18: cost_mthd_code_v IN cm_cldr_hdr.cost_mthd_code%TYPE,

14: cost_period_v cm_cldr_dtl.period_code%TYPE := NULL;
15:
16: CURSOR get_cal_per_cur(
17: cost_whse_v IN cm_whse_asc.cost_whse_code%TYPE,
18: cost_mthd_code_v IN cm_cldr_hdr.cost_mthd_code%TYPE,
19: cost_date_v IN DATE)
20: IS
21: SELECT d.calendar_code, d.period_code
22: FROM cm_cldr_dtl d,

Line 23: cm_cldr_hdr h,

19: cost_date_v IN DATE)
20: IS
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

Line 387: cm_cldr_hdr h,

383: /* Determine the appropriate cost calendar/period */
384: SELECT d.calendar_code, d.period_code
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