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.JL_BR_AR_LOG_VALIDATION dependencies on HZ_ORGANIZATION_PROFILES

Line 89: hz_organization_profiles prof

85: -- CE uptake - Bug#2932986
86: SELECT occ.std_occurrence_code
87: INTO X_bank_occurrence_code_std
88: FROM jl_br_ar_bank_occurrences occ,
89: hz_organization_profiles prof
90: WHERE occ.bank_occurrence_code = X_bank_occurrence_code
91: AND prof.bank_or_branch_number = X_bank_number
92: AND occ.bank_party_id = prof.party_id
93: AND prof.home_country ='BR'

Line 132: hz_organization_profiles prof

128: occ.bank_party_id
129: INTO X_jlbr_bank_number,
130: p_bank_party_id
131: FROM jl_br_ar_bank_occurrences occ,
132: hz_organization_profiles prof
133: WHERE prof.bank_or_branch_number = X_bank_number
134: AND occ.bank_party_id = prof.party_id
135: AND prof.home_country ='BR'
136: AND rownum = 1;