APPS.PAY_GET_TAX_EXISTS_PKG dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 44: FROM pay_us_emp_state_tax_rules_f pest

40: l_change_date varchar2(20);
41:
42: CURSOR sdi_exempt IS
43: SELECT DECODE(pest.sdi_exempt, NULL, 'N', pest.sdi_exempt)
44: FROM pay_us_emp_state_tax_rules_f pest
45: WHERE pest.assignment_id = p_assign_id
46: AND TO_DATE(l_change_date, 'DD-MM-YYYY') BETWEEN
47: pest.effective_start_date AND pest.effective_end_date
48: AND pest.state_code = SUBSTR(p_jurisdiction_code, 1, 2);

Line 52: FROM pay_us_emp_state_tax_rules_f pest

48: AND pest.state_code = SUBSTR(p_jurisdiction_code, 1, 2);
49:
50: CURSOR sui_exempt IS
51: SELECT DECODE(pest.sui_exempt, NULL, 'N', pest.sui_exempt)
52: FROM pay_us_emp_state_tax_rules_f pest
53: WHERE pest.assignment_id = p_assign_id
54: AND TO_DATE(l_change_date, 'DD-MM-YYYY') BETWEEN
55: pest.effective_start_date AND pest.effective_end_date
56: AND pest.state_code = SUBSTR(p_jurisdiction_code, 1, 2);

Line 991: FROM pay_us_emp_state_tax_rules_f str

987: SELECT DISTINCT decode( nvl(str.wc_exempt,'N'),
988: 'Y','N', -- if wc exemptthe don't take WC
989: 'Y')
990: INTO l_wc_exists
991: FROM pay_us_emp_state_tax_rules_f str
992: WHERE str.state_code = SUBSTR(p_juri_code, 1, 2)
993: AND str.assignment_id = p_assign_id /* 5772548 */
994: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
995: str.effective_start_date AND str.effective_end_date;

Line 1947: FROM pay_us_emp_state_tax_rules_f puesrf,

1943: BEGIN
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')