APPS.AS_OPP_COPY_PVT dependencies on AS_ACCESSES_ALL

Line 95: -- all records from AS_ACCESSES_ALL for that lead_id but if the flag

91: FROM AS_LEADS_ALL
92: WHERE lead_id = c_lead_id;
93:
94: -- If create sales team for sales credit flag is set to 'N', return
95: -- all records from AS_ACCESSES_ALL for that lead_id but if the flag
96: -- is set to 'Y', return the records from AS_ACCESSES_ALL that also
97: -- exist in AS_SALES_CREDITS
98: -- Note that the result set is ordered by owner_flag because according
99: -- to the logic, the owner should be updated before any other sales

Line 96: -- is set to 'Y', return the records from AS_ACCESSES_ALL that also

92: WHERE lead_id = c_lead_id;
93:
94: -- If create sales team for sales credit flag is set to 'N', return
95: -- all records from AS_ACCESSES_ALL for that lead_id but if the flag
96: -- is set to 'Y', return the records from AS_ACCESSES_ALL that also
97: -- exist in AS_SALES_CREDITS
98: -- Note that the result set is ordered by owner_flag because according
99: -- to the logic, the owner should be updated before any other sales
100: -- team member is inserted as otherwise, the insert might fail if the

Line 105: FROM AS_ACCESSES_ALL A

101: -- record being inserted has same unique keys as the owner created by
102: -- the header
103: CURSOR c_salesteam(c_lead_id NUMBER, c_cre_st_for_sc_flag VARCHAR2) IS
104: SELECT *
105: FROM AS_ACCESSES_ALL A
106: WHERE lead_id = c_lead_id
107: AND salesforce_id in -- This condition was added for bug 5361442
108: (SELECT s.salesforce_id
109: FROM as_accesses_all s,

Line 109: FROM as_accesses_all s,

105: FROM AS_ACCESSES_ALL A
106: WHERE lead_id = c_lead_id
107: AND salesforce_id in -- This condition was added for bug 5361442
108: (SELECT s.salesforce_id
109: FROM as_accesses_all s,
110: jtf_rs_resource_extns j
111: WHERE s.salesforce_id = j.resource_id
112: AND (j.end_date_active IS NULL
113: OR j.end_date_active > sysdate))

Line 124: FROM AS_ACCESSES_ALL

120: ORDER BY nvl(owner_flag, 'N') desc;
121:
122: CURSOR c_owner_in_salesTeam(c_lead_id NUMBER,c_salesforce_id NUMBER,c_sales_group_id NUMBER) IS
123: SELECT access_id,last_update_date
124: FROM AS_ACCESSES_ALL
125: WHERE lead_id = c_lead_id
126: AND salesforce_id = c_salesforce_id
127: AND nvl(sales_group_id, -99) = nvl(c_sales_group_id, -99)
128: AND nvl(owner_flag,'N')='Y';

Line 133: FROM AS_ACCESSES_ALL

129:
130: -- Added for ASNB
131: CURSOR c_log_user_in_salesTeam(c_lead_id NUMBER,c_salesforce_id NUMBER,c_sales_group_id NUMBER) IS
132: SELECT access_id,last_update_date
133: FROM AS_ACCESSES_ALL
134: WHERE lead_id = c_lead_id
135: AND salesforce_id = c_salesforce_id
136: AND nvl(sales_group_id, -99) = nvl(c_sales_group_id, -99);
137: