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_MMREF_REPORTING dependencies on PAY_US_STATE_TAX_INFO_F

Line 31: REM INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1)

27: REM djoshi 17-jan-2002 115.7 2190825 Changed the code for bug
28: REM djoshi 21-jan-2002 115.8 Added checkfile:
29: REM fusman 02-jul-2002 115.6 2296797 Added legislation Code
30: REM asasthan 11-NOV-2002 115.12 2586041 Added Index hint
31: REM INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1)
32: REM djoshi 13-nov-2002 115.13 Changed the local variable to be char
33: REM to overcome convertion problems in
34: REM 9i database.
35: REM ppanda 02-DEC-2002 115.14 Nocopy hint added to OUT and IN OUT parameters

Line 87: REM in pay_us_state_tax_info_f within

83: REM so that EE is eligible to be included
84: REM in Tape when County Withheld is non-zero
85: REM even when State Wage is zero.
86: REM 5630156 Removed the check of State Code
87: REM in pay_us_state_tax_info_f within
88: REM cursor c_state of create_assignment_act
89: REM due to Performance Issue.
90: REM sudedas 13-NOV-2006 115.33 5648738 range_cursor and create_assignment_act
91: REM has been changed for State of Ohio

Line 999: 'AND EXISTS ( /+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) / '||

995: 'paa.tax_unit_id, '||
996: 'faic1.context , 6),0) > 0) '||
997: ') '||
998:
999: 'AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */ '||
1000: 'select ''x'' '||
1001: 'from pay_us_state_tax_info_f pustif '||
1002: 'where substr(faic.context,1,2) = pustif.state_code '||
1003: 'and ppa.effective_date between pustif.effective_start_date '||

Line 1001: 'from pay_us_state_tax_info_f pustif '||

997: ') '||
998:
999: 'AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */ '||
1000: 'select ''x'' '||
1001: 'from pay_us_state_tax_info_f pustif '||
1002: 'where substr(faic.context,1,2) = pustif.state_code '||
1003: 'and ppa.effective_date between pustif.effective_start_date '||
1004: 'and pustif.effective_end_date '||
1005: 'and pustif.sit_exists = ''Y'') '||

Line 1067: 'AND EXISTS ( /+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) / '||

1063: 'paa.tax_unit_id, '||
1064: 'faic1.context , 8),0) > 0) '||
1065: ') '||
1066:
1067: 'AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */ '||
1068: 'select ''x'' '||
1069: 'from pay_us_state_tax_info_f pustif '||
1070: 'where substr(faic.context,1,2) = pustif.state_code '||
1071: 'and ppa.effective_date between pustif.effective_start_date '||

Line 1069: 'from pay_us_state_tax_info_f pustif '||

1065: ') '||
1066:
1067: 'AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */ '||
1068: 'select ''x'' '||
1069: 'from pay_us_state_tax_info_f pustif '||
1070: 'where substr(faic.context,1,2) = pustif.state_code '||
1071: 'and ppa.effective_date between pustif.effective_start_date '||
1072: 'and pustif.effective_end_date '||
1073: 'and pustif.sit_exists = ''Y'') '||

Line 1118: AND EXISTS ( /+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) /

1114: paa.assignment_action_id,
1115: ''A_W2_STATE_WAGES'',
1116: paa.tax_unit_id,
1117: faic.context , 2),0) > 0
1118: AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1119: select ''x''
1120: from pay_us_state_tax_info_f pustif
1121: where substr(faic.context,1,2) = pustif.state_code
1122: and ppa.effective_date between pustif.effective_start_date

Line 1120: from pay_us_state_tax_info_f pustif

1116: paa.tax_unit_id,
1117: faic.context , 2),0) > 0
1118: AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1119: select ''x''
1120: from pay_us_state_tax_info_f pustif
1121: where substr(faic.context,1,2) = pustif.state_code
1122: and ppa.effective_date between pustif.effective_start_date
1123: and pustif.effective_end_date
1124: and pustif.sit_exists = ''Y'')

Line 1214: and exists ( /+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) /

1210: 'A_SIT_WITHHELD_PER_JD_GRE_YTD', /* 6809739 */
1211: paa.tax_unit_id,
1212: faic.context , 2),0) > 0) )
1213:
1214: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1215: select 'x'
1216: from pay_us_state_tax_info_f pustif
1217: where substr(faic.context,1,2) = pustif.state_code
1218: and ppa.effective_date between pustif.effective_start_date

Line 1216: from pay_us_state_tax_info_f pustif

1212: faic.context , 2),0) > 0) )
1213:
1214: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1215: select 'x'
1216: from pay_us_state_tax_info_f pustif
1217: where substr(faic.context,1,2) = pustif.state_code
1218: and ppa.effective_date between pustif.effective_start_date
1219: and pustif.effective_end_date
1220: and pustif.sit_exists = 'Y'

Line 1284: -- and exists ( /+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) /

1280: 'A_SIT_WITHHELD_PER_JD_GRE_YTD',
1281: paa.tax_unit_id,
1282: faic.context , 2),0) > 0))
1283: /* Commenting it due to Performance Issue Bug# 5630156 */
1284: -- and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1285: /* select 'x'
1286: from pay_us_state_tax_info_f pustif
1287: where substr(faic.context,1,2) = pustif.state_code
1288: and ppa.effective_date between pustif.effective_start_date

Line 1286: from pay_us_state_tax_info_f pustif

1282: faic.context , 2),0) > 0))
1283: /* Commenting it due to Performance Issue Bug# 5630156 */
1284: -- and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1285: /* select 'x'
1286: from pay_us_state_tax_info_f pustif
1287: where substr(faic.context,1,2) = pustif.state_code
1288: and ppa.effective_date between pustif.effective_start_date
1289: and pustif.effective_end_date
1290: and pustif.sit_exists = 'Y'