DBA Data[Home] [Help]

APPS.GMF_MIGRATION dependencies on CM_CLDR_DTL

Line 2762: * data in CM_CLDR_HDR_B AND CM_CLDR_DTL to GMF_CALENDAR_ASSIGNMENTS *

2758: * Migrate_Cost_Calendars *
2759: * *
2760: * DESCRIPTION: *
2761: * This PL/SQL procedure is used to transform the Cost Calendars *
2762: * data in CM_CLDR_HDR_B AND CM_CLDR_DTL to GMF_CALENDAR_ASSIGNMENTS *
2763: * and GMF_PERIOD_STATUSES *
2764: * *
2765: * PARAMETERS: *
2766: * P_migration_run_id - id to use to right to migration log *

Line 3451: cm_cldr_dtl b

3447: WHERE g.delete_mark <> 1
3448: AND EXISTS (
3449: SELECT 'X'
3450: FROM gmf_calendar_assignments a,
3451: cm_cldr_dtl b
3452: WHERE a.calendar_code = b.calendar_code
3453: AND a.calendar_code = g.calendar_code
3454: AND a.legal_entity_id = g.legal_entity_id
3455: AND a.cost_Type_id = g.cost_type_id

Line 3464: cm_cldr_dtl n

3460: m.calendar_code,
3461: min(n.start_date) mindate,
3462: max(n.end_date) maxdate
3463: FROM gmf_calendar_assignments m,
3464: cm_cldr_dtl n
3465: WHERE m.calendar_code = n.calendar_code
3466: AND m.calendar_code = i.calendar_code
3467: AND m.legal_entity_id = i.legal_entity_id
3468: AND m.cost_type_id = i.cost_type_id

Line 3562: cm_cldr_dtl b,

3558: b.last_update_login,
3559: b.text_code,
3560: decode(a.delete_mark + b.delete_mark, 0, 0, 1)
3561: FROM gmf_calendar_assignments a,
3562: cm_cldr_dtl b,
3563: cm_cldr_hdr_b h
3564: WHERE a.calendar_code = b.calendar_code
3565: AND b.calendar_code = h.calendar_code
3566: AND h.co_code IS NOT NULL