DBA Data[Home] [Help]

APPS.PV_OPPORTUNITY_VHUK dependencies on AS_STATUSES_VL

Line 1780: from as_statuses_vl a,

1776: cursor lc_get_meaning(pc_status_code VARCHAR2 ,pc_lead_id NUMBER) IS
1777: select decode(a.status_code, t.status, a.meaning, a.status_code),
1778: decode(a.status_code, pc_status_code, a.meaning, a.status_code),
1779: a.status_code, a.win_loss_indicator
1780: from as_statuses_vl a,
1781: (select status from as_leads_all
1782: where lead_id = pc_lead_id) t
1783: where a.enabled_flag = 'Y'
1784: and a.opp_flag = 'Y'