APPS.FV_CCR_UTIL_PVT dependencies on DUAL

Line 24: FROM dual;

20: SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
21: NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10)
22: )
23: INTO l_ret_value
24: FROM dual;
25:
26: return l_ret_value;
27: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'END');
28: EXCEPTION

Line 158: SELECT hzp.party_name, NVL(pav.num_1099, pav.individual_1099),

154:
155: --SELECT vendor_name,num_1099 INTO x_vendor_name,x_num_1099
156: --FROM po_vendors WHERE vendor_id = p_vendor_id;
157:
158: SELECT hzp.party_name, NVL(pav.num_1099, pav.individual_1099),
159: pav.organization_type_lookup_code
160: INTO x_vendor_name,x_num_1099, x_org_type_lkup
161: FROM hz_parties hzp, ap_suppliers pav
162: WHERE hzp.party_id = pav.party_id

Line 286: pav.individual_1099 = p_taxpayer)

282: --po_vendors WHERE num_1099 = p_taxpayer;
283: SELECT pav.vendor_id, hzp.party_name
284: FROM hz_parties hzp, ap_suppliers pav
285: WHERE (pav.num_1099 = p_taxpayer OR
286: pav.individual_1099 = p_taxpayer)
287: AND hzp.party_id = pav.party_id;
288:
289: CURSOR vendor_lbn_csr(p_legal_bus varchar2) IS
290: --SELECT vendor_id,vendor_name FROM