APPS.AST_ASN_INTEROP dependencies on AS_SALES_CREDITS

Line 24: FROM as_sales_credits

20: ) IS
21:
22: CURSOR CUR_SALESCREDIT IS
23: SELECT salesforce_id,salesgroup_id,lead_line_id,person_id,credit_percent
24: FROM as_sales_credits
25: WHERE lead_id = p_lead_id;
26:
27: l_prev_lead_line_id NUMBER;
28: l_salesforce_id NUMBER;

Line 59: UPDATE AS_SALES_CREDITS

55: IF l_debug THEN
56: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
57: 'Sales Force Id: ' || l_salesforce_id || ' Sales Group Id :' || l_sales_group_id ||' Person id :'||l_person_id );
58: END IF;
59: UPDATE AS_SALES_CREDITS
60: SET SALESFORCE_ID = l_salesforce_id,
61: SALESGROUP_ID = l_sales_group_id,
62: PERSON_ID = l_person_id,
63: LAST_UPDATE_DATE = SYSDATE

Line 77: from as_sales_credits

73: and team_leader_flag = 'N'
74: and exists
75: (
76: select 'x'
77: from as_sales_credits
78: where lead_id=acc.lead_id
79: and salesforce_id=acc.salesforce_id
80: and salesgroup_id =acc.sales_group_id
81: );