APPS.AST_UWQ_LEADS_ENUMS_PVT dependencies on AS_STATUSES_VL

Line 34: as_statuses_vl

30:
31: CURSOR c_lead_nodes IS
32: SELECT status_code, meaning
33: FROM
34: as_statuses_vl
35: WHERE
36: enabled_flag = 'Y' and LEAD_FLAG = 'Y' and OPP_OPEN_STATUS_FLAG = 'Y'
37: ORDER BY 1;
38:

Line 43: from as_statuses_vl

39: /* Removed the USAGE indicator check
40: changes made by vimpi on 19th october 20001
41: CURSOR c_lead_nodes IS
42: select status_code,meaning
43: from as_statuses_vl
44: where enabled_flag = 'Y'
45: and lead_flag = 'Y'
46: and opp_open_status_flag = 'Y'
47: and usage_indicator in ('ALL','OS','PRM')

Line 514: as_statuses_vl

510:
511: CURSOR c_lead_nodes IS
512: SELECT status_code, meaning
513: FROM
514: as_statuses_vl
515: WHERE
516: enabled_flag = 'Y' and LEAD_FLAG = 'Y' and OPP_OPEN_STATUS_FLAG = 'Y'
517: ORDER BY 1;
518: