APPS.OPI_DBI_RES_OPM_PKG dependencies on CM_CLDR_HDR_B

Line 185: cm_cldr_hdr_b hdr,

181: dtl.period_code,
182: dtl.start_date,
183: dtl.end_date
184: FROM
185: cm_cldr_hdr_b hdr,
186: cm_cldr_dtl dtl
187: WHERE
188: hdr.calendar_code = dtl.calendar_code
189: AND dtl.end_date >= g_global_start_date

Line 345: cm_cldr_hdr_b hdr,

341: dtl.start_date,
342: dtl.end_date
343: FROM
344: gl_plcy_mst pol,
345: cm_cldr_hdr_b hdr,
346: cm_cldr_dtl dtl
347: WHERE
348: hdr.co_code = pol.co_code
349: AND hdr.cost_mthd_code = pol.gl_cost_mthd

Line 543: cm_cldr_hdr_b hdr,

539: dtl.period_code,
540: dtl.start_date,
541: dtl.end_date
542: FROM
543: cm_cldr_hdr_b hdr,
544: cm_cldr_dtl dtl
545: WHERE
546: hdr.calendar_code = dtl.calendar_code
547: AND dtl.end_date >= g_global_start_date

Line 717: cm_cldr_hdr_b hdr,

713: dtl.period_code,
714: dtl.start_date,
715: dtl.end_date
716: FROM
717: cm_cldr_hdr_b hdr,
718: cm_cldr_dtl dtl
719: WHERE
720: hdr.calendar_code = dtl.calendar_code
721: AND dtl.end_date >= g_global_start_date

Line 875: cm_cldr_hdr_b hdr,

871: dtl.start_date,
872: dtl.end_date
873: FROM
874: gl_plcy_mst pol,
875: cm_cldr_hdr_b hdr,
876: cm_cldr_dtl dtl
877: WHERE
878: hdr.co_code = pol.co_code
879: AND hdr.cost_mthd_code = pol.gl_cost_mthd

Line 1081: cm_cldr_hdr_b hdr,

1077: dtl.period_code,
1078: dtl.start_date,
1079: dtl.end_date
1080: FROM
1081: cm_cldr_hdr_b hdr,
1082: cm_cldr_dtl dtl
1083: WHERE
1084: hdr.calendar_code = dtl.calendar_code
1085: AND dtl.end_date >= g_global_start_date