APPS.XNP_WEB_UTILS dependencies on XNP_SV_SOA_VL

Line 116: select count(*) into l_total_portings from xnp_sv_soa_vl

112: l_inprogress_portings NUMBER;
113: l_xdp_workitems NUMBER;
114: l_inquery_portings NUMBER;
115: BEGIN
116: select count(*) into l_total_portings from xnp_sv_soa_vl
117: where status_phase IN ('ACTIVE', 'OLD');
118:
119: select count(*) into l_inprogress_portings from xnp_sv_soa_vl
120: where status_phase IN ('ORDER');

Line 119: select count(*) into l_inprogress_portings from xnp_sv_soa_vl

115: BEGIN
116: select count(*) into l_total_portings from xnp_sv_soa_vl
117: where status_phase IN ('ACTIVE', 'OLD');
118:
119: select count(*) into l_inprogress_portings from xnp_sv_soa_vl
120: where status_phase IN ('ORDER');
121:
122: select count(*) into l_inquery_portings from xnp_sv_soa_vl
123: where status_phase IN ('INQUIRY');

Line 122: select count(*) into l_inquery_portings from xnp_sv_soa_vl

118:
119: select count(*) into l_inprogress_portings from xnp_sv_soa_vl
120: where status_phase IN ('ORDER');
121:
122: select count(*) into l_inquery_portings from xnp_sv_soa_vl
123: where status_phase IN ('INQUIRY');
124:
125: select count(*) into l_xdp_workitems from XDP_FULFILL_WORKLIST ;
126: