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_TAX_BALS_ADJ_API dependencies on PAY_US_COUNTY_SCHOOL_DSTS

Line 374: FROM pay_us_county_school_dsts pcsd

370: ;
371:
372: CURSOR csr_get_school_jd_level IS
373: SELECT 'Y'
374: FROM pay_us_county_school_dsts pcsd
375: WHERE pcsd.state_code = substr(g_sch_dist_jur,1,2)
376: AND pcsd.school_dst_code = substr(g_sch_dist_jur,4,5)
377: ;
378:

Line 2801: FROM pay_us_county_school_dsts psd

2797:
2798: CURSOR csr_sd_cnt_present (cp_school_jur_code IN VARCHAR2)
2799: IS
2800: SELECT 'Y'
2801: FROM pay_us_county_school_dsts psd
2802: WHERE psd.state_code = substr (cp_school_jur_code,1,2)
2803: AND psd.school_dst_code = substr (cp_school_jur_code,4,5)
2804: AND ROWNUM = 1;
2805: