APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on HZ_ORGANIZATION_PROFILES

Line 1801: hz_organization_profiles hz_org

1797: -- get bank info. cursor
1798: CURSOR c_bank IS
1799: SELECT hz_p.party_name, hz_org.bank_or_branch_number, hz_org.home_country
1800: FROM hz_parties hz_p,
1801: hz_organization_profiles hz_org
1802: WHERE hz_p.party_id = hz_org.party_id
1803: AND SYSDATE between TRUNC(hz_org.effective_start_date)
1804: and NVL(TRUNC(hz_org.effective_end_date), SYSDATE+1)
1805: AND hz_p.party_id = p_ext_bank_acct_rec.bank_id;