DBA Data[Home] [Help]

APPS.ASO_OPP_QTE_PUB dependencies on AS_SALES_CREDITS

Line 179: -- AS_SALES_CREDITS

175: WHERE lead_id = p_lead_id
176: AND inventory_item_id IS NOT NULL
177: AND organization_id IS NOT NULL;
178:
179: -- AS_SALES_CREDITS
180: CURSOR C_sales_credits (p_lead_id NUMBER, p_lead_line_id NUMBER) IS
181: SELECT salesforce_id,
182: salesgroup_id,
183: credit_type_id,

Line 185: FROM as_sales_credits

181: SELECT salesforce_id,
182: salesgroup_id,
183: credit_type_id,
184: credit_percent
185: FROM as_sales_credits
186: WHERE lead_id = p_lead_id
187: AND lead_line_id = p_lead_line_id;
188:
189: CURSOR C_phone (p_party_id number) is