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.PAY_US_CITY_PKG dependencies on PER_ADDRESSES

Line 853: -- To check a given city exists in the per_addresses table

849: ------------------------------------------------------------------------------
850: -- Name
851: -- chk_city_in_addr
852: -- Purpose
853: -- To check a given city exists in the per_addresses table
854: -- It would not allow the city to be deleted if it is referenced in
855: -- the per_addresses table. Validation check to prevent deletion
856: -- if city is referenced.
857: -- Notes

Line 855: -- the per_addresses table. Validation check to prevent deletion

851: -- chk_city_in_addr
852: -- Purpose
853: -- To check a given city exists in the per_addresses table
854: -- It would not allow the city to be deleted if it is referenced in
855: -- the per_addresses table. Validation check to prevent deletion
856: -- if city is referenced.
857: -- Notes
858: -- This only confirms the existence of a city in the per_addresses
859: -- table if and only if the city within an state and county

Line 858: -- This only confirms the existence of a city in the per_addresses

854: -- It would not allow the city to be deleted if it is referenced in
855: -- the per_addresses table. Validation check to prevent deletion
856: -- if city is referenced.
857: -- Notes
858: -- This only confirms the existence of a city in the per_addresses
859: -- table if and only if the city within an state and county
860: -- matches to that of the per_addresses table.
861: ------------------------------------------------------------------------------
862: PROCEDURE chk_city_in_addr(p_state_abbrev VARCHAR2,

Line 860: -- matches to that of the per_addresses table.

856: -- if city is referenced.
857: -- Notes
858: -- This only confirms the existence of a city in the per_addresses
859: -- table if and only if the city within an state and county
860: -- matches to that of the per_addresses table.
861: ------------------------------------------------------------------------------
862: PROCEDURE chk_city_in_addr(p_state_abbrev VARCHAR2,
863: p_county_name VARCHAR2,
864: p_city_name VARCHAR2) IS

Line 873: FROM per_addresses

869: CURSOR C1 is SELECT 'x'
870: FROM dual
871: where exists(
872: SELECT region_1,town_or_city
873: FROM per_addresses
874: WHERE region_1 = l_prov_abbrev
875: AND town_or_city = p_city_name
876: AND ROWNUM < 2);
877:

Line 883: -- Note that in per_addresses table town_or_city, region 2 and region 1

879: CURSOR C2 is SELECT 'x'
880: FROM dual
881: where exists(
882: SELECT region_1,region_2,town_or_city
883: -- Note that in per_addresses table town_or_city, region 2 and region 1
884: -- are refered to as
885: -- city name, state abbreviation and county name respectively.
886: FROM per_addresses
887: WHERE region_2 = p_state_abbrev

Line 886: FROM per_addresses

882: SELECT region_1,region_2,town_or_city
883: -- Note that in per_addresses table town_or_city, region 2 and region 1
884: -- are refered to as
885: -- city name, state abbreviation and county name respectively.
886: FROM per_addresses
887: WHERE region_2 = p_state_abbrev
888: AND region_1 = p_county_name
889: AND town_or_city = p_city_name
890: AND ROWNUM < 2);