APPS.AS_RTTAP_OPPTY dependencies on AS_SALES_CREDITS

Line 836: FROM AS_SALES_CREDITS

832: (SELECT rownum ROW_NUM,b.COLUMN_VALUE GRP FROM TABLE(CAST(p_WinningTerrMember_tbl.group_id AS jtf_terr_number_list)) b) GRPTAB
833: WHERE RESTAB.ROW_NUM = GRPTAB.ROW_NUM
834: )
835: AND NOT EXISTS (SELECT 'X'
836: FROM AS_SALES_CREDITS
837: WHERE salesforce_id = ACC.salesforce_id
838: AND salesgroup_id = ACC.sales_group_id
839: AND lead_id = G_LEAD_ID) ;
840:

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,