APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on HZ_ORGANIZATION_PROFILES

Line 1682: hz_organization_profiles hz_org

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)
1686: AND hz_p.party_id = p_ext_bank_acct_rec.bank_id;