APPS.ASL_EXCEL_UTIL_PVT dependencies on AS_ACCESSES_ALL

Line 46: FROM AS_ACCESSES_ALL ACC1, AS_ACCESSES_ALL ACC2

42: p_last_sync_time IN DATE) IS
43:
44: CURSOR C_NEW_CUST_TEAM(p_salesforce_id NUMBER, p_last_sync_time DATE) IS
45: SELECT DISTINCT ACC1.customer_id
46: FROM AS_ACCESSES_ALL ACC1, AS_ACCESSES_ALL ACC2
47: WHERE ACC1.salesforce_id = p_salesforce_id
48: AND ACC1.creation_date > p_last_sync_time
49: AND ACC1.salesforce_id = ACC2.salesforce_id(+)
50: AND ACC1.customer_id = ACC2.customer_id (+)

Line 79: FROM AS_ACCESSES_ALL ACC1, AS_ACCESSES_ALL ACC2

75: p_last_sync_time IN DATE) IS
76:
77: CURSOR C_NEW_OPP_TEAM(p_salesforce_id NUMBER, p_last_sync_time DATE) IS
78: SELECT DISTINCT ACC1.customer_id, ACC1.lead_id
79: FROM AS_ACCESSES_ALL ACC1, AS_ACCESSES_ALL ACC2
80: WHERE ACC1.salesforce_id = p_salesforce_id
81: AND ACC1.creation_date > p_last_sync_time
82: AND ACC1.salesforce_id = ACC2.salesforce_id(+)
83: AND ACC1.customer_id = ACC2.customer_id (+)

Line 113: FROM AS_ACCESSES_ALL ACC1, AS_ACCESSES_ALL ACC2

109: p_last_sync_time IN DATE) IS
110:
111: CURSOR C_NEW_LEAD_TEAM(p_salesforce_id NUMBER, p_last_sync_time DATE) IS
112: SELECT DISTINCT ACC1.customer_id, ACC1.sales_lead_id
113: FROM AS_ACCESSES_ALL ACC1, AS_ACCESSES_ALL ACC2
114: WHERE ACC1.salesforce_id = p_salesforce_id
115: AND ACC1.creation_date > p_last_sync_time
116: AND ACC1.salesforce_id = ACC2.salesforce_id(+)
117: AND ACC1.customer_id = ACC2.customer_id (+)

Line 1228: SELECT 'X' FROM AS_ACCESSES_ALL

1224: FUNCTION CHECK_CUSTOMER_UPDATEBLE(p_customer_id IN NUMBER) RETURN VARCHAR2 IS
1225: v_dummy VARCHAR2(1);
1226: CURSOR C_CUSTOMER_UPDATEABLE (p_customer_id NUMBER,
1227: p_resource_id NUMBER) IS
1228: SELECT 'X' FROM AS_ACCESSES_ALL
1229: WHERE salesforce_id = p_resource_id
1230: AND customer_id = p_customer_id
1231: AND lead_id is NULL
1232: AND sales_lead_id is NULL;