APPS.OZF_SD_BATCH_PVT dependencies on PO_VENDOR_CONTACTS

Line 15: -- - Change to use PO_VENDOR_CONTACTS instead of AP_SUPPLIER_CONTACTS

11: -- 16-FEB-2008 JMAHENDR - Modified GET_BATCH_CURRENCY_AMOUNT to use
12: -- OZF_OFFERS.TRANSACTION_CURRENCY_CODE
13: -- - Insert of claim_amount_currency_code in CREATE_BATCH_LINES
14: -- 22-FEB-2008 JMAHENDR - Change filter condition on batch line create to pick accruals that are !=0
15: -- - Change to use PO_VENDOR_CONTACTS instead of AP_SUPPLIER_CONTACTS
16: -- - Use of tradeprofile (TP) thresholds only if TP currency is set
17: -- 25-SEP-2008 - ANNSRINI - removed product check in create_batch_lines and getting org_id from request lines instead of funds_utilised table
18: -- 26-SEP-2008 - ANNSRINI - Modified p_start_date and p_end_date to varchar instead of DATE in create_batch_main
19: -- added l_start_date and l_end_date in create_batch_main and passing these in call to create_batch_sub

Line 1462: FROM PO_VENDOR_CONTACTS cont

1458: decode(cont.last_name,null,null,'','',cont.last_name || ', ') || nvl(cont.middle_name, '')|| ' '|| cont.first_name fullname,
1459: cont.email_address,
1460: decode(cont.phone ,NULL, NULL, cont.area_code || '-' || cont.phone) phone,
1461: decode(cont.fax,NULL, NULL, cont.fax_area_code || '-' || cont.fax) fax
1462: FROM PO_VENDOR_CONTACTS cont
1463: WHERE cont.vendor_site_id = c_supplier_site_id
1464: AND NVL(inactive_date, sysdate+1) > sysdate;
1465:
1466: -- added for ER 13245462