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

Line 2594: from hz_dnb_request_log log, hz_organization_profiles org

2590: /* Bug 3301467 : Comment the cursor code
2591:
2592: CURSOR c IS
2593: select 'N'
2594: from hz_dnb_request_log log, hz_organization_profiles org
2595: where log.party_id= p_party_id
2596: and org.party_id=log.party_id
2597: and org.actual_content_source='DNB'
2598: and org.effective_end_date is NULL

Line 2603: from hz_dnb_request_log log, hz_organization_profiles org

2599: and trunc(org.last_update_date) > trunc(log.last_update_date)
2600: and rownum =1
2601: UNION
2602: select 'Y'
2603: from hz_dnb_request_log log, hz_organization_profiles org
2604: where log.party_id= p_party_id
2605: and org.party_id=log.party_id
2606: and org.actual_content_source='DNB'
2607: and org.effective_end_date is NULL

Line 2630: select 'Y' into l_exist from hz_organization_profiles org

2626: -- Bug 3301467 : Add below statement to check if the last purchased package for
2627: -- a party is through online mode or batch mode.
2628: -- If it is online mode, return 'Y' else 'N'
2629: Begin
2630: select 'Y' into l_exist from hz_organization_profiles org
2631: where org.party_id = p_party_id
2632: and org.actual_content_source='DNB'
2633: and org.effective_end_date is NULL
2634: and trunc(org.last_update_date) =