APPS.BSC_PERIODICITIES_PVT dependencies on BSC_SYS_PERIODICITIES_TL

Line 89: INSERT INTO BSC_SYS_PERIODICITIES_TL (

85: , l_Periodicities_Rec_Type.Short_Name
86: );
87:
88: -- Insert into Periodicity transalatable tables
89: INSERT INTO BSC_SYS_PERIODICITIES_TL (
90: PERIODICITY_ID
91: , LANGUAGE
92: , SOURCE_LANG
93: , NAME

Line 115: FROM BSC_SYS_PERIODICITIES_TL T

111: WHERE L.INSTALLED_FLAG IN ('I', 'B')
112: AND NOT EXISTS
113: (
114: SELECT NULL
115: FROM BSC_SYS_PERIODICITIES_TL T
116: WHERE T.PERIODICITY_ID = l_Periodicities_Rec_Type.Periodicity_Id
117: AND T.LANGUAGE = L.LANGUAGE_CODE
118: );
119:

Line 200: , BSC_SYS_PERIODICITIES_TL TL

196: , TL.LAST_UPDATE_DATE
197: , TL.LAST_UPDATE_LOGIN
198: FROM
199: BSC_SYS_PERIODICITIES B
200: , BSC_SYS_PERIODICITIES_TL TL
201: WHERE
202: B.PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id
203: AND TL.PERIODICITY_ID = B.PERIODICITY_ID
204: AND TL.LANGUAGE = USERENV('LANG');

Line 361: UPDATE bsc_sys_periodicities_tl t

357: ,b.custom_code = l_Periodicities_Rec_Type.Custom_Code
358: WHERE b.periodicity_id = l_Periodicities_Rec_Type.Periodicity_id;
359:
360:
361: UPDATE bsc_sys_periodicities_tl t
362: SET t.name = l_Periodicities_Rec_Type.Name
363: ,t.last_updated_by = l_Periodicities_Rec_Type.Last_Updated_By
364: ,t.last_update_date = l_Periodicities_Rec_Type.Last_Update_Date
365: ,t.last_update_login = l_Periodicities_Rec_Type.Last_Update_Login

Line 504: DELETE BSC_SYS_PERIODICITIES_TL

500:
501: DELETE BSC_SYS_PERIODS
502: WHERE PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;
503:
504: DELETE BSC_SYS_PERIODICITIES_TL
505: WHERE PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;
506:
507: DELETE BSC_SYS_PERIODICITIES
508: WHERE PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;