APPS.PAY_GET_TAX_EXISTS_PKG dependencies on FND_SESSIONS

Line 1097: fnd_sessions SES

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

Line 1123: fnd_sessions SES

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

Line 1184: fnd_sessions SES

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

Line 1601: fnd_sessions SES

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

Line 1783: fnd_sessions SES

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

Line 1858: fnd_sessions SES

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

Line 1945: fnd_sessions ses

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