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.GHR_US_NFC_EXTRACTS dependencies on GHR_DUTY_STATIONS_F

Line 398: FROM ghr_duty_stations_f dut

394: ,cp_state VARCHAR2
395: )
396: IS
397: SELECT SUBSTR(duty_station_code,1,2) state_code
398: FROM ghr_duty_stations_f dut
399: WHERE duty_station_code LIKE '%0000000' AND
400: (
401: (substr(duty_station_code,1,1)
402: IN ('1','2','3','4','5','6','7','8','9','0')

Line 418: FROM ghr_duty_stations_f dut

414: ,cp_effective_date DATE
415: ,cp_county_name VARCHAR2)
416: IS
417: SELECT SUBSTR(duty_station_code,7,3) county_code
418: FROM ghr_duty_stations_f dut
419: WHERE duty_station_code like cp_state_code || '0000%'
420: AND substr(duty_station_code,7,3) <> '000'
421: AND cp_effective_date BETWEEN
422: effective_Start_date and effective_end_Date

Line 432: FROM ghr_duty_stations_f dut

428: ,cp_city_name VARCHAR2)
429: IS
430:
431: SELECT dut.duty_station_code county_code
432: FROM ghr_duty_stations_f dut
433: WHERE
434: dut.duty_station_code IN (
435: SELECT SUBSTR(dut1.duty_station_code,0,2)||'0000'||SUBSTR(dut1.duty_station_code,7,3)
436: FROM ghr_duty_stations_f dut1,ghr_duty_stations_f dut2

Line 436: FROM ghr_duty_stations_f dut1,ghr_duty_stations_f dut2

432: FROM ghr_duty_stations_f dut
433: WHERE
434: dut.duty_station_code IN (
435: SELECT SUBSTR(dut1.duty_station_code,0,2)||'0000'||SUBSTR(dut1.duty_station_code,7,3)
436: FROM ghr_duty_stations_f dut1,ghr_duty_stations_f dut2
437: WHERE dut1.name= UPPER(cp_city_name) AND dut2.duty_station_code =cp_state_code||'0000000'
438: AND SUBSTR(dut1.duty_station_code,0,2) = SUBSTR(dut2.duty_station_code,0,2)
439: AND substr(dut2.duty_station_code,3,7) = '0000000'
440: AND cp_effective_date BETWEEN dut1.effective_start_date

Line 456: FROM ghr_duty_stations_f dut

452: ,cp_city_name VARCHAR2
453: )
454: IS
455: SELECT substr(duty_station_code,3,4) city_code
456: FROM ghr_duty_stations_f dut
457: WHERE duty_station_code LIKE
458: cp_state_code || '%' || cp_county_code
459: AND substr(duty_station_code,3,4) <> '0000'
460: and trunc(cp_effective_date)

Line 630: FROM ghr_duty_stations_f dut

626: ,cp_state VARCHAR2
627: )
628: IS
629: SELECT SUBSTR(duty_station_code,1,2) state_code
630: FROM ghr_duty_stations_f dut
631: WHERE duty_station_code LIKE '%0000000' AND
632: (
633: (substr(duty_station_code,1,1)
634: IN ('1','2','3','4','5','6','7','8','9','0')

Line 650: FROM ghr_duty_stations_f dut

646: ,cp_effective_date DATE
647: ,cp_county_name VARCHAR2)
648: IS
649: SELECT SUBSTR(duty_station_code,7,3) county_code
650: FROM ghr_duty_stations_f dut
651: WHERE duty_station_code like cp_state_code || '0000%'
652: AND substr(duty_station_code,7,3) <> '000'
653: AND cp_effective_date BETWEEN
654: effective_Start_date and effective_end_Date

Line 663: FROM ghr_duty_stations_f dut

659: ,cp_city_name VARCHAR2)
660: IS
661:
662: SELECT dut.duty_station_code county_code
663: FROM ghr_duty_stations_f dut
664: WHERE
665: dut.duty_station_code IN (
666: SELECT SUBSTR(dut1.duty_station_code,0,2)||'0000'||SUBSTR(dut1.duty_station_code,7,3)
667: FROM ghr_duty_stations_f dut1,ghr_duty_stations_f dut2

Line 667: FROM ghr_duty_stations_f dut1,ghr_duty_stations_f dut2

663: FROM ghr_duty_stations_f dut
664: WHERE
665: dut.duty_station_code IN (
666: SELECT SUBSTR(dut1.duty_station_code,0,2)||'0000'||SUBSTR(dut1.duty_station_code,7,3)
667: FROM ghr_duty_stations_f dut1,ghr_duty_stations_f dut2
668: WHERE dut1.name= UPPER(cp_city_name) AND dut2.duty_station_code =cp_state_code||'0000000'
669: AND SUBSTR(dut1.duty_station_code,0,2) = SUBSTR(dut2.duty_station_code,0,2)
670: AND substr(dut2.duty_station_code,3,7) = '0000000'
671: AND cp_effective_date BETWEEN dut1.effective_start_date

Line 687: FROM ghr_duty_stations_f dut

683: ,cp_city_name VARCHAR2
684: )
685: IS
686: SELECT substr(duty_station_code,3,4) city_code
687: FROM ghr_duty_stations_f dut
688: WHERE duty_station_code LIKE
689: cp_state_code || '%' || cp_county_code
690: AND substr(duty_station_code,3,4) <> '0000'
691: and trunc(cp_effective_date)

Line 869: FROM ghr_duty_stations_f dut

865: ,cp_state VARCHAR2
866: )
867: IS
868: SELECT SUBSTR(duty_station_code,1,2) state_code
869: FROM ghr_duty_stations_f dut
870: WHERE duty_station_code LIKE '%0000000' AND
871: (
872: (substr(duty_station_code,1,1)
873: IN ('1','2','3','4','5','6','7','8','9','0')

Line 889: FROM ghr_duty_stations_f dut

885: ,cp_effective_date DATE
886: ,cp_county_name VARCHAR2)
887: IS
888: SELECT SUBSTR(duty_station_code,7,3) county_code
889: FROM ghr_duty_stations_f dut
890: WHERE duty_station_code like cp_state_code || '0000%'
891: AND substr(duty_station_code,7,3) <> '000'
892: AND cp_effective_date BETWEEN
893: effective_Start_date and effective_end_Date

Line 903: FROM ghr_duty_stations_f dut

899: ,cp_city_name VARCHAR2)
900: IS
901:
902: SELECT dut.duty_station_code county_code
903: FROM ghr_duty_stations_f dut
904: WHERE
905: dut.duty_station_code IN (
906: SELECT SUBSTR(dut1.duty_station_code,0,2)||'0000'||SUBSTR(dut1.duty_station_code,7,3)
907: FROM ghr_duty_stations_f dut1,ghr_duty_stations_f dut2

Line 907: FROM ghr_duty_stations_f dut1,ghr_duty_stations_f dut2

903: FROM ghr_duty_stations_f dut
904: WHERE
905: dut.duty_station_code IN (
906: SELECT SUBSTR(dut1.duty_station_code,0,2)||'0000'||SUBSTR(dut1.duty_station_code,7,3)
907: FROM ghr_duty_stations_f dut1,ghr_duty_stations_f dut2
908: WHERE dut1.name= UPPER(cp_city_name) AND dut2.duty_station_code =cp_state_code||'0000000'
909: AND SUBSTR(dut1.duty_station_code,0,2) = SUBSTR(dut2.duty_station_code,0,2)
910: AND substr(dut2.duty_station_code,3,7) = '0000000'
911: AND cp_effective_date BETWEEN dut1.effective_start_date

Line 927: FROM ghr_duty_stations_f dut

923: ,cp_city_name VARCHAR2
924: )
925: IS
926: SELECT substr(duty_station_code,3,4) city_code
927: FROM ghr_duty_stations_f dut
928: WHERE duty_station_code LIKE
929: cp_state_code || '%' || cp_county_code
930: AND substr(duty_station_code,3,4) <> '0000'
931: and trunc(cp_effective_date)

Line 1092: FROM ghr_duty_stations_f dut

1088: ,cp_date DATE
1089: )
1090: IS
1091: SELECT dut.name
1092: FROM ghr_duty_stations_f dut
1093: WHERE substr(duty_station_code,3,4) = cp_city_code
1094: AND substr(duty_station_code,0,2)= cp_state_code
1095: AND cp_date BETWEEN effective_Start_date
1096: AND effective_end_Date;

Line 1106: FROM ghr_duty_stations_f dut

1102: SELECT pus.state_abbrev name
1103: FROM pay_us_states pus
1104: WHERE UPPER(pus.state_name)=
1105: (SELECT dut.name
1106: FROM ghr_duty_stations_f dut
1107: WHERE duty_station_code like '%0000000' AND
1108: (
1109: (SUBSTR(duty_station_code,1,1) in ('1','2','3','4','5','6','7','8','9','0')
1110: AND SUBSTR (duty_station_code,2,1) in ('1','2','3','4','5','6','7','8','9','0'))