2458: last_update_login = FND_GLOBAL.conc_login_id
2459: where ascr.lead_id = l_lead_id(i) and NVL(CREDIT_PERCENT,0) <> 100
2460: and CREDIT_TYPE_ID in
2461: ( select SALES_CREDIT_TYPE_ID
2462: from oe_sales_credit_types
2463: where QUOTA_FLAG = 'N');
2464:
2465: -- delete duplicate non quota credits
2466: -- This is repeated inside the loop to
2478: FROM as_sales_credits ascr1
2479: WHERE ascr1.lead_id = l_lead_id(i)
2480: AND ascr1.credit_type_id in
2481: ( SELECT sales_credit_type_id
2482: FROM oe_sales_credit_types
2483: WHERE quota_flag = 'N')
2484: GROUP BY lead_id,lead_line_id,salesforce_id,salesgroup_id,credit_type_id
2485: HAVING COUNT(sales_credit_id) > 1
2486: ) duplines
2926: FROM as_sales_credits ascr1
2927: WHERE ascr1.lead_id = l_lead_id(i)
2928: AND ascr1.credit_type_id in
2929: ( SELECT sales_credit_type_id
2930: FROM oe_sales_credit_types
2931: WHERE quota_flag = 'N')
2932: GROUP BY lead_id,lead_line_id,salesforce_id,salesgroup_id,credit_type_id
2933: HAVING COUNT(sales_credit_id) > 1
2934: ) duplines