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.

[Home] [Help]

APPS.HZ_GNR_PKG dependencies on HZ_GEOGRAPHY_IDENTIFIERS

Line 93: FROM hz_geography_identifiers hgo

89: l_country_code VARCHAR2(10);
90:
91: CURSOR c_country_code (l_country VARCHAR2)IS
92: SELECT hgo.identifier_value
93: FROM hz_geography_identifiers hgo
94: WHERE hgo.identifier_subtype = 'ISO_COUNTRY_CODE'
95: AND hgo.identifier_type = 'CODE'
96: AND hgo.geography_use = 'MASTER_REF'
97: AND hgo.geography_type = 'COUNTRY'

Line 100: FROM hz_geography_identifiers hgi

96: AND hgo.geography_use = 'MASTER_REF'
97: AND hgo.geography_type = 'COUNTRY'
98: AND hgo.primary_flag = 'Y' -- fix for bug 5400607 (Nishant 20-Jul-2006)
99: AND EXISTS ( SELECT '1'
100: FROM hz_geography_identifiers hgi
101: WHERE hgi.geography_use = 'MASTER_REF'
102: AND hgi.geography_type = 'COUNTRY'
103: AND hgi.geography_id = hgo.geography_id
104: AND UPPER(hgi.identifier_value) = l_country

Line 496: FROM hz_geography_identifiers hgo

492: ((p_country_code IS NOT NULL) AND
493: (loc.country = UPPER(p_country_code))) OR
494: ((p_country_code IS NOT NULL) AND
495: (loc.country IN (SELECT hgo.identifier_value
496: FROM hz_geography_identifiers hgo
497: WHERE EXISTS ( SELECT '1'
498: FROM hz_geography_identifiers hgi
499: WHERE hgi.identifier_subtype = 'ISO_COUNTRY_CODE'
500: AND hgi.identifier_type = 'CODE'

Line 498: FROM hz_geography_identifiers hgi

494: ((p_country_code IS NOT NULL) AND
495: (loc.country IN (SELECT hgo.identifier_value
496: FROM hz_geography_identifiers hgo
497: WHERE EXISTS ( SELECT '1'
498: FROM hz_geography_identifiers hgi
499: WHERE hgi.identifier_subtype = 'ISO_COUNTRY_CODE'
500: AND hgi.identifier_type = 'CODE'
501: AND hgi.geography_use = 'MASTER_REF'
502: AND hgi.geography_type = 'COUNTRY'

Line 546: FROM hz_geography_identifiers hgo

542: ((p_country_code IS NOT NULL) AND
543: (loc.country = UPPER(p_country_code))) OR
544: ((p_country_code IS NOT NULL) AND
545: (loc.country IN (SELECT hgo.identifier_value
546: FROM hz_geography_identifiers hgo
547: WHERE EXISTS ( SELECT '1'
548: FROM hz_geography_identifiers hgi
549: WHERE hgi.identifier_subtype = 'ISO_COUNTRY_CODE'
550: AND hgi.identifier_type = 'CODE'

Line 548: FROM hz_geography_identifiers hgi

544: ((p_country_code IS NOT NULL) AND
545: (loc.country IN (SELECT hgo.identifier_value
546: FROM hz_geography_identifiers hgo
547: WHERE EXISTS ( SELECT '1'
548: FROM hz_geography_identifiers hgi
549: WHERE hgi.identifier_subtype = 'ISO_COUNTRY_CODE'
550: AND hgi.identifier_type = 'CODE'
551: AND hgi.geography_use = 'MASTER_REF'
552: AND hgi.geography_type = 'COUNTRY'

Line 595: FROM hz_geography_identifiers hgo

591: ((p_country_code IS NOT NULL) AND
592: (loc.country = UPPER(p_country_code))) OR
593: ((p_country_code IS NOT NULL) AND
594: (loc.country IN (SELECT hgo.identifier_value
595: FROM hz_geography_identifiers hgo
596: WHERE EXISTS ( SELECT '1'
597: FROM hz_geography_identifiers hgi
598: WHERE hgi.identifier_subtype = 'ISO_COUNTRY_CODE'
599: AND hgi.identifier_type = 'CODE'

Line 597: FROM hz_geography_identifiers hgi

593: ((p_country_code IS NOT NULL) AND
594: (loc.country IN (SELECT hgo.identifier_value
595: FROM hz_geography_identifiers hgo
596: WHERE EXISTS ( SELECT '1'
597: FROM hz_geography_identifiers hgi
598: WHERE hgi.identifier_subtype = 'ISO_COUNTRY_CODE'
599: AND hgi.identifier_type = 'CODE'
600: AND hgi.geography_use = 'MASTER_REF'
601: AND hgi.geography_type = 'COUNTRY'

Line 655: FROM hz_geography_identifiers hgo

651: ((p_country_code IS NOT NULL) AND
652: (country = p_country_code)) OR
653: ((p_country_code IS NOT NULL) AND
654: (country IN (SELECT hgo.identifier_value
655: FROM hz_geography_identifiers hgo
656: WHERE EXISTS ( SELECT '1'
657: FROM hz_geography_identifiers hgi
658: WHERE hgi.identifier_subtype = 'ISO_COUNTRY_CODE'
659: AND hgi.identifier_type = 'CODE'

Line 657: FROM hz_geography_identifiers hgi

653: ((p_country_code IS NOT NULL) AND
654: (country IN (SELECT hgo.identifier_value
655: FROM hz_geography_identifiers hgo
656: WHERE EXISTS ( SELECT '1'
657: FROM hz_geography_identifiers hgi
658: WHERE hgi.identifier_subtype = 'ISO_COUNTRY_CODE'
659: AND hgi.identifier_type = 'CODE'
660: AND hgi.geography_use = 'MASTER_REF'
661: AND hgi.geography_type = 'COUNTRY'

Line 722: FROM hz_geography_identifiers hgo

718: ((p_country_code IS NOT NULL) AND
719: (country = p_country_code)) OR
720: ((p_country_code IS NOT NULL) AND
721: (country IN (SELECT hgo.identifier_value
722: FROM hz_geography_identifiers hgo
723: WHERE EXISTS ( SELECT '1'
724: FROM hz_geography_identifiers hgi
725: WHERE hgi.identifier_subtype = 'ISO_COUNTRY_CODE'
726: AND hgi.identifier_type = 'CODE'

Line 724: FROM hz_geography_identifiers hgi

720: ((p_country_code IS NOT NULL) AND
721: (country IN (SELECT hgo.identifier_value
722: FROM hz_geography_identifiers hgo
723: WHERE EXISTS ( SELECT '1'
724: FROM hz_geography_identifiers hgi
725: WHERE hgi.identifier_subtype = 'ISO_COUNTRY_CODE'
726: AND hgi.identifier_type = 'CODE'
727: AND hgi.geography_use = 'MASTER_REF'
728: AND hgi.geography_type = 'COUNTRY'

Line 789: FROM hz_geography_identifiers hgo

785: ((p_country_code IS NOT NULL) AND
786: (country = p_country_code)) OR
787: ((p_country_code IS NOT NULL) AND
788: (country IN (SELECT hgo.identifier_value
789: FROM hz_geography_identifiers hgo
790: WHERE EXISTS ( SELECT '1'
791: FROM hz_geography_identifiers hgi
792: WHERE hgi.identifier_subtype = 'ISO_COUNTRY_CODE'
793: AND hgi.identifier_type = 'CODE'

Line 791: FROM hz_geography_identifiers hgi

787: ((p_country_code IS NOT NULL) AND
788: (country IN (SELECT hgo.identifier_value
789: FROM hz_geography_identifiers hgo
790: WHERE EXISTS ( SELECT '1'
791: FROM hz_geography_identifiers hgi
792: WHERE hgi.identifier_subtype = 'ISO_COUNTRY_CODE'
793: AND hgi.identifier_type = 'CODE'
794: AND hgi.geography_use = 'MASTER_REF'
795: AND hgi.geography_type = 'COUNTRY'