APPS.AST_ASN_INTEROP dependencies on AS_ACCESSES_ALL

Line 43: FROM AS_ACCESSES_ALL

39:
40: BEGIN
41: SELECT PERSON_ID,SALESFORCE_ID,SALES_GROUP_ID
42: INTO l_person_id,l_salesforce_id,l_sales_group_id
43: FROM AS_ACCESSES_ALL
44: WHERE LEAD_ID = p_lead_id
45: AND OWNER_FLAG = 'Y';
46: EXCEPTION
47: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN

Line 69: UPDATE AS_ACCESSES_ALL acc

65: AND (SALESFORCE_ID <> l_salesforce_id
66: or nvl(SALESGROUP_ID,0) <> nvl(l_sales_group_id,0))
67: AND NVL(DEFAULTED_FROM_OWNER_FLAG,'N') = 'Y';
68:
69: UPDATE AS_ACCESSES_ALL acc
70: SET object_version_number = nvl(object_version_number,0) + 1,
71: acc.team_leader_flag = 'Y'
72: WHERE acc.LEAD_ID = p_lead_id
73: and team_leader_flag = 'N'