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 2610: from hz_dnb_request_log log, hz_organization_profiles org

2606: /* Bug 3301467 : Comment the cursor code
2607:
2608: CURSOR c IS
2609: select 'N'
2610: from hz_dnb_request_log log, hz_organization_profiles org
2611: where log.party_id= p_party_id
2612: and org.party_id=log.party_id
2613: and org.actual_content_source='DNB'
2614: and org.effective_end_date is NULL

Line 2619: from hz_dnb_request_log log, hz_organization_profiles org

2615: and trunc(org.last_update_date) > trunc(log.last_update_date)
2616: and rownum =1
2617: UNION
2618: select 'Y'
2619: from hz_dnb_request_log log, hz_organization_profiles org
2620: where log.party_id= p_party_id
2621: and org.party_id=log.party_id
2622: and org.actual_content_source='DNB'
2623: and org.effective_end_date is NULL

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

2642: -- Bug 3301467 : Add below statement to check if the last purchased package for
2643: -- a party is through online mode or batch mode.
2644: -- If it is online mode, return 'Y' else 'N'
2645: Begin
2646: select 'Y' into l_exist from hz_organization_profiles org
2647: where org.party_id = p_party_id
2648: and org.actual_content_source='DNB'
2649: and org.effective_end_date is NULL
2650: and trunc(org.last_update_date) =