DBA Data[Home] [Help]

APPS.OPI_DBI_RES_OPM_PKG dependencies on CM_CLDR_DTL

Line 186: cm_cldr_dtl dtl

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
190: AND dtl.start_date <= sysdate

Line 346: cm_cldr_dtl dtl

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
350: AND hdr.calendar_code = dtl.calendar_code

Line 544: cm_cldr_dtl dtl

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
548: AND dtl.start_date <= sysdate

Line 718: cm_cldr_dtl dtl

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
722: AND dtl.start_date <= sysdate

Line 876: cm_cldr_dtl dtl

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
880: AND hdr.calendar_code = dtl.calendar_code

Line 1082: cm_cldr_dtl dtl

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
1086: AND dtl.start_date <= sysdate