APPS.AS_RTTAP_OPPTY dependencies on AS_LEADS_ALL

Line 76: FROM AS_LEADS_ALL LDS

72: SYSDATE,
73: 0,
74: 0,
75: 'OPPORTUNITY'
76: FROM AS_LEADS_ALL LDS
77: WHERE lead_id = G_LEAD_ID
78: AND NOT EXISTS
79: ( SELECT 'X'
80: FROM AS_CHANGED_ACCOUNTS_ALL ACC

Line 273: from as_leads_all ld,

269: SET object_version_number = nvl(object_version_number,0) + 1, acc.OPEN_FLAG = 'Y'
270: WHERE acc.LEAD_ID = p_lead_id
271: AND EXISTS
272: (select 1
273: from as_leads_all ld,
274: as_statuses_b st
275: where st.opp_open_status_flag = 'Y'
276: and st.status_code = ld.status
277: and ld.lead_id = p_lead_id )

Line 285: from as_leads_all ld,

281: SET object_version_number = nvl(object_version_number,0) + 1, acc.OPEN_FLAG = 'N'
282: WHERE acc.LEAD_ID = p_lead_id
283: AND NOT EXISTS
284: (select 1
285: from as_leads_all ld,
286: as_statuses_b st
287: where st.opp_open_status_flag = 'Y'
288: and st.status_code = ld.status
289: and ld.lead_id = p_lead_id )

Line 738: FROM AS_LEADS_ALL LDS, AS_STATUSES_B ST

734: 'Y',
735: 'N',
736: NVL(ST.opp_open_status_flag,'N'),
737: p_WinningTerrMember_tbl.org_id(l_index)
738: FROM AS_LEADS_ALL LDS, AS_STATUSES_B ST
739: WHERE LDS.status = ST.status_code
740: AND LDS.lead_id = G_LEAD_ID
741: AND NOT EXISTS
742: ( SELECT NULL FROM AS_ACCESSES_ALL ACC

Line 890: UPDATE AS_LEADS_ALL sl

886: IF is_owner_set%NOTFOUND THEN
887: OPEN oppty_owner_rt;
888: FETCH oppty_owner_rt INTO v_acc_id;
889: IF oppty_owner_rt%NOTFOUND THEN
890: UPDATE AS_LEADS_ALL sl
891: SET SL.object_version_number = nvl(sl.object_version_number,0) + 1,
892: SL.last_update_date = SYSDATE,
893: SL.last_updated_by = FND_GLOBAL.USER_ID,
894: SL.last_update_login = FND_GLOBAL.USER_ID,

Line 915: UPDATE AS_LEADS_ALL sl

911: AAA.last_updated_by = FND_GLOBAL.USER_ID,
912: AAA.last_update_login = FND_GLOBAL.USER_ID
913: WHERE access_id = v_acc_id
914: RETURNING salesforce_id,sales_group_id INTO v_srep_id,v_grp_id;
915: UPDATE AS_LEADS_ALL sl
916: SET SL.object_version_number = nvl(sl.object_version_number,0) + 1,
917: SL.last_update_date = SYSDATE,
918: SL.last_updated_by = FND_GLOBAL.USER_ID,
919: SL.last_update_login = FND_GLOBAL.USER_ID,