APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_CL_OTHER_PULL

Line 4277: where (to_currency = MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE and

4273: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
4274:
4275: Begin
4276: select 1 into cnt from MSC_CURRENCY_CONVERSIONS
4277: where (to_currency = MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE and
4278: conv_type = MSC_CL_OTHER_PULL.G_MSC_CURR_CONV_TYPE)
4279: and rownum < 2;
4280:
4281: exception

Line 4278: conv_type = MSC_CL_OTHER_PULL.G_MSC_CURR_CONV_TYPE)

4274:
4275: Begin
4276: select 1 into cnt from MSC_CURRENCY_CONVERSIONS
4277: where (to_currency = MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE and
4278: conv_type = MSC_CL_OTHER_PULL.G_MSC_CURR_CONV_TYPE)
4279: and rownum < 2;
4280:
4281: exception
4282: when no_data_found then

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

4295: ON (mcc.from_currency = mst.from_currency
4296: AND mcc.to_currency = mst.to_currency
4297: AND mcc.conv_date = mst.conv_date
4298: AND mcc.conv_type = mst.conv_type
4299: AND mcc.conv_type = MSC_CL_OTHER_PULL.G_MSC_CURR_CONV_TYPE)
4300: WHEN MATCHED THEN
4301: UPDATE SET mcc.conv_rate = mst.conv_rate,
4302: mcc.last_coll_instance_id = mst.sr_instance_id
4303: WHEN NOT MATCHED THEN

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

4509: v_pbs := TO_NUMBER(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
4510:
4511: Loop
4512: Delete from MSC_CURRENCY_CONVERSIONS
4513: where conv_date > (sysdate + MSC_CL_OTHER_PULL.G_MSC_FUTURE_DAYS) or conv_date < (sysdate - MSC_CL_OTHER_PULL.G_MSC_PAST_DAYS)
4514: And rownum < v_pbs;
4515: Exit when sql%rowcount = 0;
4516:
4517: End loop;