APPS.PAY_GET_TAX_EXISTS_PKG dependencies on FND_SESSIONS

Line 1100: fnd_sessions SES

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
1104: STATETAX.effective_start_date AND STATETAX.effective_end_date;

Line 1126: fnd_sessions SES

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
1130: STATETAX.effective_start_date AND STATETAX.effective_end_date;

Line 1187: fnd_sessions SES

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
1191: STATETAX.effective_start_date AND STATETAX.effective_end_date;

Line 1604: fnd_sessions SES

1600: --
1601: SELECT CITYTAX.city_tax
1602: INTO l_city_rs_exists
1603: FROM pay_us_city_tax_info_f CITYTAX,
1604: fnd_sessions SES
1605: WHERE CITYTAX.JURISDICTION_CODE = p_juri_code
1606: AND SES.session_id = USERENV('SESSIONID')
1607: AND SES.effective_date BETWEEN
1608: CITYTAX.effective_start_date AND CITYTAX.effective_end_date;

Line 1786: fnd_sessions SES

1782: /*{*/
1783: SELECT CITYTAX.head_tax
1784: INTO l_ht_wk_exists
1785: FROM pay_us_city_tax_info_f CITYTAX,
1786: fnd_sessions SES
1787: WHERE CITYTAX.JURISDICTION_CODE = p_juri_code
1788: AND SES.session_id = USERENV('SESSIONID')
1789: AND SES.effective_date BETWEEN
1790: CITYTAX.effective_start_date AND CITYTAX.effective_end_date;

Line 1861: fnd_sessions SES

1857: /*{*/
1858: SELECT CITYTAX.city_tax
1859: INTO l_city_wk_exists
1860: FROM pay_us_city_tax_info_f CITYTAX,
1861: fnd_sessions SES
1862: WHERE CITYTAX.JURISDICTION_CODE = p_juri_code
1863: AND SES.session_id = USERENV('SESSIONID')
1864: AND SES.effective_date BETWEEN
1865: CITYTAX.effective_start_date AND CITYTAX.effective_end_date;

Line 1948: fnd_sessions ses

1944: /*{*/
1945: SELECT puesrf.STATE_NON_RESIDENT_CERT
1946: INTO l_nr_exists
1947: FROM pay_us_emp_state_tax_rules_f puesrf,
1948: fnd_sessions ses
1949: WHERE puesrf.assignment_id = p_assign_id
1950: AND SUBSTR(puesrf.jurisdiction_code,1,2) = SUBSTR(p_juri_code,1,2)
1951: AND ses.session_id = USERENV('SESSIONID')
1952: AND ses.effective_date BETWEEN