eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_EXT_BANKACCT_PUB dependencies on HZ_ORGANIZATION_PROFILES

Line 1340: FROM hz_organization_profiles

1336: l_org_name hr_operating_units.name%TYPE;
1337: -- picks up branch number
1338: CURSOR c_branch (p_branch_id NUMBER) IS
1339: SELECT bank_or_branch_number
1340: FROM hz_organization_profiles
1341: WHERE SYSDATE between TRUNC(effective_start_date)
1342: and NVL(TRUNC(effective_end_date), SYSDATE+1)
1343: AND party_id = p_branch_id;
1344:

Line 1951: FROM hz_organization_profiles

1947:
1948: -- picks up branch number
1949: CURSOR c_branch (p_branch_id NUMBER) IS
1950: SELECT bank_or_branch_number
1951: FROM hz_organization_profiles
1952: WHERE SYSDATE between TRUNC(effective_start_date)
1953: and NVL(TRUNC(effective_end_date), SYSDATE+1)
1954: AND party_id = p_branch_id;
1955:

Line 4751: hz_organization_profiles hz_bankorg,

4747: hz_bank.country,
4748: hz_bank.party_name,
4749: hz_bankorg.bank_or_branch_number
4750: FROM hz_parties hz_bank,
4751: hz_organization_profiles hz_bankorg,
4752: hz_parties hz_branch,
4753: hz_relationships hz_rel,
4754: hz_code_assignments hz_bankCA,
4755: hz_code_assignments hz_branchCA