DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on HZ_PARTY_SITES

Line 2587: FROM HZ_Party_Sites HPS

2583:
2584: BEGIN
2585: SELECT party_site_id
2586: INTO l_party_site_id
2587: FROM HZ_Party_Sites HPS
2588: WHERE HPS.Party_ID = p_invoice_rec.party_id
2589: AND HPS.Identifying_Address_Flag = 'Y'
2590: AND NVL(HPS.Start_Date_Active, AP_IMPORT_INVOICES_PKG.g_inv_sysdate)
2591: <= AP_IMPORT_INVOICES_PKG.g_inv_sysdate

Line 2634: FROM hz_party_sites hps

2630: BEGIN
2631: --validate party site id
2632: SELECT party_site_id
2633: INTO l_party_site_id
2634: FROM hz_party_sites hps
2635: WHERE party_site_id = p_invoice_rec.party_site_id
2636: AND party_id = p_invoice_rec.party_id
2637: AND status = 'A'
2638: AND NVL(HPS.Start_Date_Active, AP_IMPORT_INVOICES_PKG.g_inv_sysdate)