APPS.PAY_US_MAGW2_REPORTING dependencies on PAY_US_STATE_TAX_INFO_F

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

859: paa.assignment_action_id,
860: ''A_W2_STATE_WAGES'',
861: paa.tax_unit_id,
862: faic.context , 2),0) > 0
863: AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
864: select ''x''
865: from pay_us_state_tax_info_f pustif
866: where substr(faic.context,1,2) = pustif.state_code
867: and ppa.effective_date between pustif.effective_start_date

Line 865: from pay_us_state_tax_info_f pustif

861: paa.tax_unit_id,
862: faic.context , 2),0) > 0
863: AND EXISTS ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
864: select ''x''
865: from pay_us_state_tax_info_f pustif
866: where substr(faic.context,1,2) = pustif.state_code
867: and ppa.effective_date between pustif.effective_start_date
868: and pustif.effective_end_date
869: and pustif.sit_exists = ''Y'')

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

946: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
947: 'A_W2_STATE_WAGES',
948: paa.tax_unit_id,
949: faic.context , 2),0) > 0
950: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
951: select 'x'
952: from pay_us_state_tax_info_f pustif
953: where substr(faic.context,1,2) = pustif.state_code
954: and ppa.effective_date between pustif.effective_start_date

Line 952: from pay_us_state_tax_info_f pustif

948: paa.tax_unit_id,
949: faic.context , 2),0) > 0
950: and exists ( /*+ INDEX(pustif PAY_US_STATE_TAX_INFO_F_N1) */
951: select 'x'
952: from pay_us_state_tax_info_f pustif
953: where substr(faic.context,1,2) = pustif.state_code
954: and ppa.effective_date between pustif.effective_start_date
955: and pustif.effective_end_date
956: and pustif.sit_exists = 'Y'