APPS.OPI_PMI_COST dependencies on CM_CLDR_DTL

Line 16: cm_cldr_dtl dtl,

12: dtl.start_date,
13: dtl.end_date,
14: dtl.period_status
15: FROM
16: cm_cldr_dtl dtl,
17: cm_cldr_hdr hdr
18: WHERE
19: hdr.calendar_code = dtl.calendar_code
20: AND hdr.delete_mark = 0

Line 28: pv_prior_period_code cm_cldr_dtl.period_code%TYPE;

24:
25: pv_prior_cost_mthd_code cm_cldr_hdr.cost_mthd_code%TYPE;
26: pv_prior_co_code cm_cldr_hdr.co_code%TYPE;
27: pv_prior_calendar_code cm_cldr_hdr.calendar_code%TYPE;
28: pv_prior_period_code cm_cldr_dtl.period_code%TYPE;
29: pv_prior_period_status cm_cldr_dtl.period_status%TYPE;
30: pv_sql varchar2(10000);
31: BEGIN
32: -- BUILD COST CALENDAR SUMMARY TABLE, adding PRIOR PERIOD

Line 29: pv_prior_period_status cm_cldr_dtl.period_status%TYPE;

25: pv_prior_cost_mthd_code cm_cldr_hdr.cost_mthd_code%TYPE;
26: pv_prior_co_code cm_cldr_hdr.co_code%TYPE;
27: pv_prior_calendar_code cm_cldr_hdr.calendar_code%TYPE;
28: pv_prior_period_code cm_cldr_dtl.period_code%TYPE;
29: pv_prior_period_status cm_cldr_dtl.period_status%TYPE;
30: pv_sql varchar2(10000);
31: BEGIN
32: -- BUILD COST CALENDAR SUMMARY TABLE, adding PRIOR PERIOD
33: