DBA Data[Home] [Help]

APPS.IBY_EXT_BANKACCT_PUB dependencies on HZ_ORGANIZATION_PROFILES

Line 1206: FROM hz_organization_profiles

1202:
1203: -- picks up branch number
1204: CURSOR c_branch (p_branch_id NUMBER) IS
1205: SELECT bank_or_branch_number
1206: FROM hz_organization_profiles
1207: WHERE SYSDATE between TRUNC(effective_start_date)
1208: and NVL(TRUNC(effective_end_date), SYSDATE+1)
1209: AND party_id = p_branch_id;
1210:

Line 3929: hz_organization_profiles hz_bankorg,

3925: hz_bank.country,
3926: hz_bank.party_name,
3927: hz_bankorg.bank_or_branch_number
3928: FROM hz_parties hz_bank,
3929: hz_organization_profiles hz_bankorg,
3930: hz_parties hz_branch,
3931: hz_relationships hz_rel,
3932: hz_code_assignments hz_bankCA,
3933: hz_code_assignments hz_branchCA