APPS.ASN_MIG_SALES_CREDITS_PVT dependencies on AS_SALES_CREDITS_DENORM

Line 358: as_sales_credits_denorm SCD

354: ,SCD.salesforce_id
355: ,SCD.sales_group_id
356: ,RANK () OVER (PARTITION BY SCD.lead_id ORDER BY SCD.sales_credit_id) RK
357: FROM
358: as_sales_credits_denorm SCD
359: WHERE
360: SCD.lead_id BETWEEN pc_start_id AND pc_end_id
361: AND SCD.credit_type_id = pc_credit_type_id
362: AND SCD.salesforce_id IS NOT NULL

Line 2244: FROM as_sales_credits_denorm

2240:
2241:
2242: CURSOR c_lead_denorm_credits(p_lead_id NUMBER, p_credit_type_id NUMBER) IS
2243: SELECT salesforce_id, sales_group_id, employee_person_id, opp_open_status_flag
2244: FROM as_sales_credits_denorm
2245: WHERE lead_id = p_lead_id AND credit_type_id = p_credit_type_id
2246: AND partner_customer_id IS NULL;
2247:
2248: CURSOR c_bad_opp(p_lead_id NUMBER, p_credit_type_id NUMBER) IS