APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_ST_OPERATION_COMPONENTS

Line 799: FROM MSC_ST_OPERATION_COMPONENTS msoc

795: COMPONENT_SEQUENCE_ID,
796: BILL_SEQUENCE_ID,
797: ROUTING_SEQUENCE_ID,
798: SR_INSTANCE_ID
799: FROM MSC_ST_OPERATION_COMPONENTS msoc
800: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
801: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO;
802:
803: CURSOR c9_d IS

Line 811: FROM MSC_ST_OPERATION_COMPONENTS msoc

807: BILL_SEQUENCE_ID,
808: ROUTING_SEQUENCE_ID,
809: SR_INSTANCE_ID,
810: ORGANIZATION_ID
811: FROM MSC_ST_OPERATION_COMPONENTS msoc
812: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
813: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_YES
814: UNION ALL
815: SELECT DISTINCT

Line 823: MSC_ST_OPERATION_COMPONENTS msoc

819: moc.ROUTING_SEQUENCE_ID,
820: moc.SR_INSTANCE_ID,
821: moc.ORGANIZATION_ID
822: FROM MSC_OPERATION_COMPONENTS moc,
823: MSC_ST_OPERATION_COMPONENTS msoc
824: WHERE msoc.Bill_Sequence_ID= moc.Bill_Sequence_ID
825: AND msoc.Routing_Sequence_ID <> moc.Routing_Sequence_ID
826: AND msoc.Organization_ID= moc.Organization_ID
827: AND msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 881: FROM MSC_ST_OPERATION_COMPONENTS msoc

877: MSC_CL_COLLECTION.v_current_date,
878: MSC_CL_COLLECTION.v_current_user,
879: MSC_CL_COLLECTION.v_current_date,
880: MSC_CL_COLLECTION.v_current_user
881: FROM MSC_ST_OPERATION_COMPONENTS msoc
882: WHERE msoc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
883: AND msoc.DELETED_FLAG= MSC_UTIL.SYS_NO;
884:
885: COMMIT;