DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on HZ_PARTY_SITES

Line 2457: FROM HZ_Party_Sites HPS

2453:
2454: BEGIN
2455: SELECT party_site_id
2456: INTO l_party_site_id
2457: FROM HZ_Party_Sites HPS
2458: WHERE HPS.Party_ID = p_invoice_rec.party_id
2459: AND HPS.Identifying_Address_Flag = 'Y'
2460: AND NVL(HPS.Start_Date_Active, AP_IMPORT_INVOICES_PKG.g_inv_sysdate)
2461: <= AP_IMPORT_INVOICES_PKG.g_inv_sysdate

Line 2504: FROM hz_party_sites hps

2500: BEGIN
2501: --validate party site id
2502: SELECT party_site_id
2503: INTO l_party_site_id
2504: FROM hz_party_sites hps
2505: WHERE party_site_id = p_invoice_rec.party_site_id
2506: AND party_id = p_invoice_rec.party_id
2507: AND status = 'A'
2508: AND NVL(HPS.Start_Date_Active, AP_IMPORT_INVOICES_PKG.g_inv_sysdate)