APPS.BSC_METADATA_DESC dependencies on BSC_SYS_CALENDARS_VL

Line 394: , BSC_SYS_CALENDARS_VL B

390: SELECT A.NAME, A.PERIODICITY_TYPE, A.PERIOD_TYPE_ID, A.RECORD_TYPE_ID
391: , A.CALENDAR_ID
392: , B.NAME CALENDAR_NAME , B.FISCAL_YEAR
393: FROM BSC_SYS_PERIODICITIES_VL A
394: , BSC_SYS_CALENDARS_VL B
395: WHERE A.CALENDAR_ID (+) = B.CALENDAR_ID
396: AND A.PERIODICITY_ID = l_periodicity_id;
397:
398: -------------------------------------

Line 692: put_line('...... ERROR. Periodicity Id <'||l_periodicity_id||'> assigned to a invalide Calendar Id in table BSC_SYS_PERIODICITIES_VL . Calendar Id <' || bsc_Per_cd.CALENDAR_ID || '> does not exists IN TABLE BSC_SYS_CALENDARS_VL. ' );

688: IF bsc_Per_cd.CALENDAR_NAME IS NOT NULL THEN
689: put_line('...... CALENDAR_NAME is <'||bsc_Per_cd.CALENDAR_NAME ||'> ' );
690: put_line('...... FISCAL_YEAR is <'||bsc_Per_cd.FISCAL_YEAR ||'> ' );
691: ELSE
692: put_line('...... ERROR. Periodicity Id <'||l_periodicity_id||'> assigned to a invalide Calendar Id in table BSC_SYS_PERIODICITIES_VL . Calendar Id <' || bsc_Per_cd.CALENDAR_ID || '> does not exists IN TABLE BSC_SYS_CALENDARS_VL. ' );
693: END IF;
694: END LOOP;
695: IF (l_not_found_msg2 IS NOT NULL) THEN
696: put_line(l_not_found_msg2);