APPS.PAY_US_MMREF_REPORTING_MT dependencies on PAY_US_STATE_TAX_INFO_F

Line 880: AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */

876: paa.assignment_action_id,
877: ''A_W2_STATE_WAGES'',
878: paa.tax_unit_id,
879: faic.context , 2),0) > 0
880: AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
881: select ''x''
882: from pay_us_state_tax_info_f pustif
883: where substr(faic.context,1,2) = pustif.state_code
884: and ppa.effective_date between pustif.effective_start_date

Line 882: from pay_us_state_tax_info_f pustif

878: paa.tax_unit_id,
879: faic.context , 2),0) > 0
880: AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
881: select ''x''
882: from pay_us_state_tax_info_f pustif
883: where substr(faic.context,1,2) = pustif.state_code
884: and ppa.effective_date between pustif.effective_start_date
885: and pustif.effective_end_date
886: and pustif.sit_exists = ''Y'')

Line 968: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */

964: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
965: 'A_W2_STATE_WAGES',
966: paa.tax_unit_id,
967: faic.context , 2),0) > 0
968: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
969: select 'x'
970: from pay_us_state_tax_info_f pustif
971: where substr(faic.context,1,2) = pustif.state_code
972: and ppa.effective_date between pustif.effective_start_date

Line 970: from pay_us_state_tax_info_f pustif

966: paa.tax_unit_id,
967: faic.context , 2),0) > 0
968: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
969: select 'x'
970: from pay_us_state_tax_info_f pustif
971: where substr(faic.context,1,2) = pustif.state_code
972: and ppa.effective_date between pustif.effective_start_date
973: and pustif.effective_end_date
974: and pustif.sit_exists = 'Y'

Line 1032: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */

1028: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1029: 'A_W2_STATE_WAGES',
1030: paa.tax_unit_id,
1031: faic.context , 2),0) > 0
1032: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1033: select 'x'
1034: from pay_us_state_tax_info_f pustif
1035: where substr(faic.context,1,2) = pustif.state_code
1036: and ppa.effective_date between pustif.effective_start_date

Line 1034: from pay_us_state_tax_info_f pustif

1030: paa.tax_unit_id,
1031: faic.context , 2),0) > 0
1032: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
1033: select 'x'
1034: from pay_us_state_tax_info_f pustif
1035: where substr(faic.context,1,2) = pustif.state_code
1036: and ppa.effective_date between pustif.effective_start_date
1037: and pustif.effective_end_date
1038: and pustif.sit_exists = 'Y'