APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on HZ_PARTIES

Line 1800: FROM hz_parties hz_p,

1796: l_bank_name VARCHAR2(360);
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)