APPS.PV_ASSIGN_UTIL_PVT dependencies on AS_SALES_CREDITS

Line 1718: FROM as_sales_credits

1714: -- Quota Sales Credits
1715: -- ----------------------------------------------------------------------------
1716: CURSOR lc_get_sales_credit_count(pc_salesforce_id NUMBER, pc_lead_id NUMBER) IS
1717: SELECT COUNT(*) sales_credit_count
1718: FROM as_sales_credits
1719: WHERE lead_id = pc_lead_id AND
1720: salesforce_id = pc_salesforce_id AND
1721: credit_type_id = 1 AND
1722: NVL(credit_amount, 0) > 0;

Line 1729: FROM as_sales_credits

1725: -- Non-Quota Sales Credits
1726: -- ----------------------------------------------------------------------------
1727: CURSOR lc_get_nonq_sales_credit(pc_salesforce_id NUMBER, pc_lead_id NUMBER) IS
1728: SELECT sales_credit_id
1729: FROM as_sales_credits
1730: WHERE lead_id = pc_lead_id AND
1731: salesforce_id = pc_salesforce_id AND
1732: credit_type_id = 2 AND
1733: NVL(credit_amount, 0) > 0;

Line 2076: Debug('Deleting Sales Credits from as_sales_credits');

2072:
2073: -- ----------------------------------------------------------------
2074: -- Remove non-quota sales crdits
2075: -- ----------------------------------------------------------------
2076: Debug('Deleting Sales Credits from as_sales_credits');
2077: DELETE FROM as_sales_credits
2078: WHERE lead_id = p_lead_id AND
2079: salesforce_id = p_resource_id AND
2080: credit_type_id = 2;

Line 2077: DELETE FROM as_sales_credits

2073: -- ----------------------------------------------------------------
2074: -- Remove non-quota sales crdits
2075: -- ----------------------------------------------------------------
2076: Debug('Deleting Sales Credits from as_sales_credits');
2077: DELETE FROM as_sales_credits
2078: WHERE lead_id = p_lead_id AND
2079: salesforce_id = p_resource_id AND
2080: credit_type_id = 2;
2081: