APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_CL_OTHER_PULL

Line 4415: where (to_currency = MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE and

4411: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
4412:
4413: Begin
4414: select 1 into cnt from MSC_CURRENCY_CONVERSIONS
4415: where (to_currency = MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE and
4416: conv_type = MSC_CL_OTHER_PULL.G_MSC_CURR_CONV_TYPE)
4417: and rownum < 2;
4418:
4419: exception

Line 4416: conv_type = MSC_CL_OTHER_PULL.G_MSC_CURR_CONV_TYPE)

4412:
4413: Begin
4414: select 1 into cnt from MSC_CURRENCY_CONVERSIONS
4415: where (to_currency = MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE and
4416: conv_type = MSC_CL_OTHER_PULL.G_MSC_CURR_CONV_TYPE)
4417: and rownum < 2;
4418:
4419: exception
4420: when no_data_found then

Line 4437: AND mcc.conv_type = MSC_CL_OTHER_PULL.G_MSC_CURR_CONV_TYPE)

4433: ON (mcc.from_currency = mst.from_currency
4434: AND mcc.to_currency = mst.to_currency
4435: AND mcc.conv_date = mst.conv_date
4436: AND mcc.conv_type = mst.conv_type
4437: AND mcc.conv_type = MSC_CL_OTHER_PULL.G_MSC_CURR_CONV_TYPE)
4438: WHEN MATCHED THEN
4439: UPDATE SET mcc.conv_rate = mst.conv_rate,
4440: mcc.last_coll_instance_id = mst.sr_instance_id
4441: WHEN NOT MATCHED THEN

Line 5971: where conv_date > (sysdate + MSC_CL_OTHER_PULL.G_MSC_FUTURE_DAYS) or conv_date < (sysdate - MSC_CL_OTHER_PULL.G_MSC_PAST_DAYS)

5967: v_pbs := TO_NUMBER(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
5968:
5969: Loop
5970: Delete from MSC_CURRENCY_CONVERSIONS
5971: where conv_date > (sysdate + MSC_CL_OTHER_PULL.G_MSC_FUTURE_DAYS) or conv_date < (sysdate - MSC_CL_OTHER_PULL.G_MSC_PAST_DAYS)
5972: And rownum < v_pbs;
5973: Exit when sql%rowcount = 0;
5974:
5975: End loop;