APPS.AS_RTTAP_OPPTY dependencies on AS_STATUSES_B

Line 274: as_statuses_b st

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 )
278: AND nvl(acc.OPEN_FLAG, 'N') <> 'Y';

Line 286: as_statuses_b st

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 )
290: AND acc.OPEN_FLAG IS NOT NULL;

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