APPS.FV_CCR_UTIL_PVT dependencies on DUAL

Line 21: FROM dual;

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

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

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

Line 283: pav.individual_1099 = p_taxpayer)

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