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 1024: 'AND EXISTS ( /+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) / '||

1020: 'paa.tax_unit_id, '||
1021: 'faic1.context , 6),0) > 0) '||
1022: ') '||
1023:
1024: 'AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */ '||
1025: 'select ''x'' '||
1026: 'from pay_us_state_tax_info_f pustif '||
1027: 'where substr(faic.context,1,2) = pustif.state_code '||
1028: 'and ppa.effective_date between pustif.effective_start_date '||

Line 1026: 'from pay_us_state_tax_info_f pustif '||

1022: ') '||
1023:
1024: 'AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */ '||
1025: 'select ''x'' '||
1026: 'from pay_us_state_tax_info_f pustif '||
1027: 'where substr(faic.context,1,2) = pustif.state_code '||
1028: 'and ppa.effective_date between pustif.effective_start_date '||
1029: 'and pustif.effective_end_date '||
1030: 'and pustif.sit_exists = ''Y'') '||

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

1088: 'paa.tax_unit_id, '||
1089: 'faic1.context , 8),0) > 0) '||
1090: ') '||
1091:
1092: 'AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */ '||
1093: 'select ''x'' '||
1094: 'from pay_us_state_tax_info_f pustif '||
1095: 'where substr(faic.context,1,2) = pustif.state_code '||
1096: 'and ppa.effective_date between pustif.effective_start_date '||

Line 1094: 'from pay_us_state_tax_info_f pustif '||

1090: ') '||
1091:
1092: 'AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */ '||
1093: 'select ''x'' '||
1094: 'from pay_us_state_tax_info_f pustif '||
1095: 'where substr(faic.context,1,2) = pustif.state_code '||
1096: 'and ppa.effective_date between pustif.effective_start_date '||
1097: 'and pustif.effective_end_date '||
1098: 'and pustif.sit_exists = ''Y'') '||

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

1139: paa.assignment_action_id,
1140: ''A_W2_STATE_WAGES'',
1141: paa.tax_unit_id,
1142: faic.context , 2),0) > 0
1143: AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1144: select ''x''
1145: from pay_us_state_tax_info_f pustif
1146: where substr(faic.context,1,2) = pustif.state_code
1147: and ppa.effective_date between pustif.effective_start_date

Line 1145: from pay_us_state_tax_info_f pustif

1141: paa.tax_unit_id,
1142: faic.context , 2),0) > 0
1143: AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1144: select ''x''
1145: from pay_us_state_tax_info_f pustif
1146: where substr(faic.context,1,2) = pustif.state_code
1147: and ppa.effective_date between pustif.effective_start_date
1148: and pustif.effective_end_date
1149: and pustif.sit_exists = ''Y'')

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

1235: 'A_SIT_WITHHELD_PER_JD_GRE_YTD', /* 6809739 */
1236: paa.tax_unit_id,
1237: faic.context , 2),0) > 0) )
1238:
1239: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1240: select 'x'
1241: from pay_us_state_tax_info_f pustif
1242: where substr(faic.context,1,2) = pustif.state_code
1243: and ppa.effective_date between pustif.effective_start_date

Line 1241: from pay_us_state_tax_info_f pustif

1237: faic.context , 2),0) > 0) )
1238:
1239: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1240: select 'x'
1241: from pay_us_state_tax_info_f pustif
1242: where substr(faic.context,1,2) = pustif.state_code
1243: and ppa.effective_date between pustif.effective_start_date
1244: and pustif.effective_end_date
1245: and pustif.sit_exists = 'Y'

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

1309: 'A_SIT_WITHHELD_PER_JD_GRE_YTD', /* 6809739 */
1310: paa.tax_unit_id,
1311: faic.context , 2),0) > 0) )
1312:
1313: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1314: select 'x'
1315: from pay_us_state_tax_info_f pustif
1316: where substr(faic.context,1,2) = pustif.state_code
1317: and ppa.effective_date between pustif.effective_start_date

Line 1315: from pay_us_state_tax_info_f pustif

1311: faic.context , 2),0) > 0) )
1312:
1313: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1314: select 'x'
1315: from pay_us_state_tax_info_f pustif
1316: where substr(faic.context,1,2) = pustif.state_code
1317: and ppa.effective_date between pustif.effective_start_date
1318: and pustif.effective_end_date
1319: and pustif.sit_exists = 'Y'

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

1380: 'A_SIT_WITHHELD_PER_JD_GRE_YTD',
1381: paa.tax_unit_id,
1382: faic.context , 2),0) > 0))
1383: /* Commenting it due to Performance Issue Bug# 5630156 */
1384: -- and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1385: /* select 'x'
1386: from pay_us_state_tax_info_f pustif
1387: where substr(faic.context,1,2) = pustif.state_code
1388: and ppa.effective_date between pustif.effective_start_date

Line 1386: from pay_us_state_tax_info_f pustif

1382: faic.context , 2),0) > 0))
1383: /* Commenting it due to Performance Issue Bug# 5630156 */
1384: -- and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1385: /* select 'x'
1386: from pay_us_state_tax_info_f pustif
1387: where substr(faic.context,1,2) = pustif.state_code
1388: and ppa.effective_date between pustif.effective_start_date
1389: and pustif.effective_end_date
1390: and pustif.sit_exists = 'Y'

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

1448: 'A_SIT_WITHHELD_PER_JD_GRE_YTD',
1449: paa.tax_unit_id,
1450: faic.context , 2),0) > 0))
1451: /* Commenting it due to Performance Issue Bug# 5630156 */
1452: -- and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1453: /* select 'x'
1454: from pay_us_state_tax_info_f pustif
1455: where substr(faic.context,1,2) = pustif.state_code
1456: and ppa.effective_date between pustif.effective_start_date

Line 1454: from pay_us_state_tax_info_f pustif

1450: faic.context , 2),0) > 0))
1451: /* Commenting it due to Performance Issue Bug# 5630156 */
1452: -- and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1453: /* select 'x'
1454: from pay_us_state_tax_info_f pustif
1455: where substr(faic.context,1,2) = pustif.state_code
1456: and ppa.effective_date between pustif.effective_start_date
1457: and pustif.effective_end_date
1458: and pustif.sit_exists = 'Y'