DBA Data[Home] [Help]

APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_SR_LOOKUPS

Line 3831: UPDATE MSC_SR_LOOKUPS

3827:
3828: BEGIN
3829:
3830: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
3831: UPDATE MSC_SR_LOOKUPS
3832: SET
3833: MEANING = c_rec.MEANING,
3834: DESCRIPTION = c_rec.DESCRIPTION,
3835: FROM_DATE = c_rec.FROM_DATE,

Line 3848: INSERT INTO MSC_SR_LOOKUPS (

3844:
3845: END IF;
3846:
3847: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) OR (MSC_CL_COLLECTION.v_is_legacy_refresh AND SQL%NOTFOUND) THEN
3848: INSERT INTO MSC_SR_LOOKUPS (
3849: LOOKUP_TYPE,
3850: LOOKUP_CODE,
3851: MEANING,
3852: DESCRIPTION,