APPS.OPI_PMI_COST dependencies on OPI_PMI_ORGN_PLCY_GTMP

Line 124: INSERT INTO opi_pmi_orgn_plcy_gtmp

120:
121:
122: -- GET THE FISCAL POLICY FOR EACH ORGANIZATION.DATE
123:
124: INSERT INTO opi_pmi_orgn_plcy_gtmp
125: (orgn_code, trans_date, co_code, cost_mthd, cost_basis)
126: SELECT /*+ ALL_ROWS */
127: od.orgn_code, od.trans_date, o.co_code, g.gl_cost_mthd, g.cost_basis
128: FROM

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;