APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on HZ_PARTIES

Line 1681: FROM hz_parties hz_p,

1677: l_bank_name VARCHAR2(360);
1678: -- get bank info. cursor
1679: CURSOR c_bank IS
1680: SELECT hz_p.party_name, hz_org.bank_or_branch_number, hz_org.home_country
1681: FROM hz_parties hz_p,
1682: hz_organization_profiles hz_org
1683: WHERE hz_p.party_id = hz_org.party_id
1684: AND SYSDATE between TRUNC(hz_org.effective_start_date)
1685: and NVL(TRUNC(hz_org.effective_end_date), SYSDATE+1)