APPS.OPI_PMI_COST dependencies on OPI_PMI_CLDR_SUM_GTMP

Line 50: INSERT INTO opi_pmi_cldr_sum_gtmp (

46: pv_prior_period_code := NULL;
47: pv_prior_period_status := NULL;
48: END IF;
49:
50: INSERT INTO opi_pmi_cldr_sum_gtmp (
51: co_code,
52: cost_mthd,
53: calendar_code,
54: period_code,

Line 141: FROM opi_pmi_cldr_sum_gtmp c, opi_pmi_orgn_plcy_gtmp o

137: INSERT INTO opi_pmi_orgn_per_gtmp
138: (orgn_code, trans_date, calendar_code, period_code, period_status)
139: SELECT /*+ ALL_ROWS */ o.orgn_code, o.trans_date,
140: c.prior_calendar_code, c.prior_period_code, c.prior_period_status
141: FROM opi_pmi_cldr_sum_gtmp c, opi_pmi_orgn_plcy_gtmp o
142: WHERE o.cost_basis = 0
143: AND c.co_code = o.co_code
144: AND c.cost_mthd = o.cost_mthd
145: AND o.trans_date BETWEEN c.start_date AND c.end_date;

Line 156: FROM opi_pmi_cldr_sum_gtmp c, opi_pmi_orgn_plcy_gtmp o

152: calendar_code, period_code, period_status)
153: SELECT /*+ ALL_ROWS */
154: o.orgn_code, o.trans_date, o.co_code, o.cost_mthd, o.cost_basis,
155: c.calendar_code, c.period_code, c.period_status
156: FROM opi_pmi_cldr_sum_gtmp c, opi_pmi_orgn_plcy_gtmp o
157: WHERE o.cost_basis = 1
158: AND c.co_code = o.co_code
159: AND c.cost_mthd = o.cost_mthd
160: AND o.trans_date BETWEEN c.start_date AND c.end_date;