DBA Data[Home] [Help]

APPS.AS_RTTAP_OPPTY dependencies on AS_SALES_CREDITS_DENORM

Line 898: UPDATE AS_SALES_CREDITS_DENORM SCD

894: SL.last_update_login = FND_GLOBAL.USER_ID,
895: SL.owner_salesforce_id = NULL,
896: SL.owner_sales_group_id = NULL
897: WHERE SL.lead_id = G_LEAD_ID ;
898: UPDATE AS_SALES_CREDITS_DENORM SCD
899: SET SCD.object_version_number = nvl(scd.object_version_number,0) + 1,
900: SCD.last_update_date = SYSDATE,
901: SCD.last_updated_by = FND_GLOBAL.USER_ID,
902: SCD.last_update_login = FND_GLOBAL.USER_ID,

Line 923: UPDATE AS_SALES_CREDITS_DENORM SCD

919: SL.last_update_login = FND_GLOBAL.USER_ID,
920: SL.owner_salesforce_id = v_srep_id,
921: SL.owner_sales_group_id = v_grp_id
922: WHERE SL.lead_id = G_LEAD_ID ;
923: UPDATE AS_SALES_CREDITS_DENORM SCD
924: SET SCD.object_version_number = nvl(scd.object_version_number,0) + 1,
925: SCD.last_update_date = SYSDATE,
926: SCD.last_updated_by = FND_GLOBAL.USER_ID,
927: SCD.last_update_login = FND_GLOBAL.USER_ID,