DBA Data[Home] [Help]

APPS.PAY_US_GEOCODE_ENGINE_PKG dependencies on DUAL

Line 51: Request will be skipped for that year and individual procedures

47: are not considering while checking for the Geocode Changes to be processed.
48: This will save unnecessary execution of complete Geocode procedures in
49: presence of only City Name and County Name changes. If only City Name
50: and County Name changes are present, then the "Geocode Upgrade Concurrent Program"
51: Request will be skipped for that year and individual procedures
52: pay_us_geo_upd_pkg.update_county_name and pay_us_geo_upd_pkg.update_city_name
53: will take care of the County Name and City Name updates */
54:
55: cursor c_geo_check_us_assignments (p_patch_name in varchar)

Line 405: from dual;

401: ELSE
402: hr_utility.trace(' in ELSE');
403:
404: select PAY_PATCH_STATUS_S.nextval into l_id
405: from dual;
406:
407: insert into pay_patch_status
408: (ID,
409: PATCH_NUMBER,