APPS.PQP_HRTCA_INTEGRATION dependencies on PAY_US_CITY_NAMES

Line 2410: FROM pay_us_city_names

2406:
2407: CURSOR csr_get_us_city_names
2408: (c_leg_code IN Varchar2) IS
2409: SELECT NULL
2410: FROM pay_us_city_names
2411: WHERE (c_leg_code = 'CA'AND
2412: state_code = 70)
2413: OR
2414: (c_leg_code ='US' AND

Line 2418: -- Check if any rows exist in the pay_us_city_names

2414: (c_leg_code ='US' AND
2415: state_code < 52);
2416: l_exists Varchar2(1);
2417: BEGIN
2418: -- Check if any rows exist in the pay_us_city_names
2419: OPEN csr_get_us_city_names(p_leg_code);
2420: FETCH csr_get_us_city_names INTO l_exists;
2421: IF csr_get_us_city_names%FOUND THEN
2422: RETURN 'Y';