APPS.HZ_GNR_PKG dependencies on HZ_GEO_NAME_REFERENCE_LOG

Line 511: FROM hz_geo_name_reference_log gnr

507: ))
508: )
509: AND NOT EXISTS (
510: SELECT '1'
511: FROM hz_geo_name_reference_log gnr
512: WHERE gnr.location_table_name = p_table_name
513: AND gnr.usage_code = DECODE(p_usage_code,'ALL',gnr.usage_code,p_usage_code)
514: AND loc.location_id = gnr.location_id
515: )

Line 561: FROM hz_geo_name_reference_log gnr

557: ))
558: )
559: AND EXISTS (
560: SELECT '1'
561: FROM hz_geo_name_reference_log gnr
562: WHERE gnr.location_table_name = p_table_name
563: AND gnr.usage_code = DECODE(p_usage_code,'ALL',gnr.usage_code,p_usage_code)
564: AND gnr.map_status = 'E'
565: AND loc.location_id = gnr.location_id

Line 670: FROM hz_geo_name_reference_log gnr

666: ))
667: )
668: AND NOT EXISTS (
669: SELECT '1'
670: FROM hz_geo_name_reference_log gnr
671: WHERE gnr.location_table_name = p_table_name
672: AND gnr.usage_code = DECODE(p_usage_code,'ALL',gnr.usage_code,p_usage_code)
673: AND loc.location_id = gnr.location_id
674: )

Line 737: FROM hz_geo_name_reference_log gnr

733: ))
734: )
735: AND EXISTS (
736: SELECT '1'
737: FROM hz_geo_name_reference_log gnr
738: WHERE gnr.location_table_name = p_table_name
739: AND gnr.usage_code = DECODE(p_usage_code,'ALL',gnr.usage_code,p_usage_code)
740: AND gnr.map_status = 'E'
741: AND loc.location_id = gnr.location_id

Line 1756: delete from hz_geo_name_reference_log

1752: delete from hz_geo_name_references
1753: where location_table_name = p_locTbl
1754: and location_id = p_locId;
1755:
1756: delete from hz_geo_name_reference_log
1757: where location_table_name = p_locTbl
1758: and location_id = p_locId;
1759: EXCEPTION WHEN OTHERS THEN
1760: x_status := FND_API.G_RET_STS_ERROR;