APPS.PAY_GET_TAX_EXISTS_PKG dependencies on PAY_US_STATE_TAX_INFO_F

Line 801: FROM pay_us_state_tax_info_f

797: BEGIN
798: /*{*/
799: SELECT DISTINCT sit_exists
800: INTO l_sit_rs_exists
801: FROM pay_us_state_tax_info_f
802: WHERE state_code = SUBSTR(p_juri_code, 1, 2)
803: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
804: effective_start_date AND effective_end_date;
805:

Line 910: FROM pay_us_state_tax_info_f

906: BEGIN
907: /*{*/
908: SELECT DISTINCT sit_exists
909: INTO l_sit_wk_exists
910: FROM pay_us_state_tax_info_f
911: WHERE state_code = SUBSTR(p_juri_code, 1, 2)
912: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
913: effective_start_date AND effective_end_date;
914:

Line 1024: FROM pay_us_state_tax_info_f

1020: BEGIN
1021: /*{*/
1022: SELECT STA_INFORMATION16
1023: INTO l_misc1_state_tax
1024: FROM pay_us_state_tax_info_f
1025: WHERE state_code = SUBSTR(p_juri_code, 1, 2)
1026: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
1027: effective_start_date AND effective_end_date;
1028:

Line 1099: FROM pay_us_state_tax_info_f STATETAX,

1095: NULL, 'N',
1096: 0, 'N',
1097: 'Y')
1098: INTO l_sdi_ee_exists
1099: FROM pay_us_state_tax_info_f STATETAX,
1100: fnd_sessions SES
1101: WHERE STATETAX.state_code = SUBSTR(p_juri_code, 1, 2)
1102: AND SES.session_id = USERENV('SESSIONID')
1103: AND SES.effective_date BETWEEN

Line 1125: FROM pay_us_state_tax_info_f STATETAX,

1121: NULL, 'N',
1122: 0, 'N',
1123: 'Y')
1124: INTO l_sdi_ee_exists
1125: FROM pay_us_state_tax_info_f STATETAX,
1126: fnd_sessions SES
1127: WHERE STATETAX.state_code = SUBSTR(p_juri_code, 1, 2)
1128: AND SES.session_id = USERENV('SESSIONID')
1129: AND SES.effective_date BETWEEN

Line 1186: FROM pay_us_state_tax_info_f STATETAX,

1182: ELSE /* assignment_tax_exists */
1183: /*{*/
1184: SELECT DECODE(STATETAX.sdi_er_wage_limit, NULL, 'N', 0, 'N', 'Y')
1185: INTO l_sdi_er_exists
1186: FROM pay_us_state_tax_info_f STATETAX,
1187: fnd_sessions SES
1188: WHERE STATETAX.state_code = SUBSTR(p_juri_code, 1, 2)
1189: AND SES.session_id = USERENV('SESSIONID')
1190: AND SES.effective_date BETWEEN

Line 1207: FROM pay_us_state_tax_info_f

1203: BEGIN
1204: /*{*/
1205: SELECT DISTINCT nvl(sta_information17,'N')
1206: INTO l_eic_rs_exists
1207: FROM pay_us_state_tax_info_f
1208: WHERE state_code = SUBSTR(p_juri_code, 1, 2)
1209: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
1210: effective_start_date AND effective_end_date;
1211:

Line 1234: FROM pay_us_state_tax_info_f

1230: BEGIN
1231: /*{*/
1232: SELECT DISTINCT nvl(sta_information17,'N')
1233: INTO l_eic_wk_exists
1234: FROM pay_us_state_tax_info_f
1235: WHERE state_code = SUBSTR(p_juri_code, 1, 2)
1236: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
1237: effective_start_date AND effective_end_date;
1238:

Line 2188: FROM pay_us_state_tax_info_f

2184: AND hoi.org_information1 = p_juri_code;
2185:
2186: CURSOR sit_exists IS
2187: SELECT DISTINCT sit_exists
2188: FROM pay_us_state_tax_info_f
2189: WHERE state_code = SUBSTR(p_juri_code, 1, 2)
2190: AND TO_DATE(l_date_earned, 'DD-MM-YYYY') BETWEEN
2191: effective_start_date AND effective_end_date;
2192: