DBA Data[Home] [Help]

APPS.FEM_DIMENSION_MIGRATION_PKG dependencies on FEM_CALENDARS_VL

Line 1526: ' FROM FEM_CALENDARS_VL@'||p_source_db_link||' A'||

1522: ' CALENDAR_NAME, DESCRIPTION, ENABLED_FLAG,'||
1523: ' CALENDAR_DISPLAY_CODE,'||
1524: ' PERSONAL_FLAG,'||
1525: ' READ_ONLY_FLAG'||
1526: ' FROM FEM_CALENDARS_VL@'||p_source_db_link||' A'||
1527: ' WHERE NOT EXISTS (SELECT 1'||
1528: ' FROM FEM_CALENDARS_VL'||
1529: ' WHERE CALENDAR_DISPLAY_CODE = A.CALENDAR_DISPLAY_CODE)';
1530:

Line 1528: ' FROM FEM_CALENDARS_VL'||

1524: ' PERSONAL_FLAG,'||
1525: ' READ_ONLY_FLAG'||
1526: ' FROM FEM_CALENDARS_VL@'||p_source_db_link||' A'||
1527: ' WHERE NOT EXISTS (SELECT 1'||
1528: ' FROM FEM_CALENDARS_VL'||
1529: ' WHERE CALENDAR_DISPLAY_CODE = A.CALENDAR_DISPLAY_CODE)';
1530:
1531: TYPE INSERT_CAL_CURSOR_TYPE IS REF CURSOR;
1532:

Line 1571: FROM FEM_CALENDARS_VL

1567: BEGIN
1568:
1569: SELECT CALENDAR_NAME
1570: INTO l_dup_cal_name
1571: FROM FEM_CALENDARS_VL
1572: WHERE CALENDAR_NAME = l_cal_name(i);
1573:
1574: EXCEPTION
1575: WHEN NO_DATA_FOUND THEN