45: l_state_exist VARCHAR2(10);
46: --
47: begin
48: --
49: hr_utility.trace('p_state_abbrev ->'||p_state_abbrev);
50: --
51: begin
52: --
53: SELECT
64: AND p_date between effective_start_date
65: and effective_end_date;
66: --
67: RETURN TRUE;
68: hr_utility.trace('l_state_exist ->'||l_state_exist);
69: --
70: exception when NO_DATA_FOUND then
71: RETURN FALSE;
72: --
86: l_lit_exist VARCHAR2(10);
87: --
88: begin
89: --
90: hr_utility.trace('p_tax_type ->'||p_tax_type);
91: hr_utility.trace('p_jurisdiction_code->'||p_jurisdiction_code);
92: hr_utility.trace('p_date ->'||to_char(p_date));
93: --
94: begin
87: --
88: begin
89: --
90: hr_utility.trace('p_tax_type ->'||p_tax_type);
91: hr_utility.trace('p_jurisdiction_code->'||p_jurisdiction_code);
92: hr_utility.trace('p_date ->'||to_char(p_date));
93: --
94: begin
95: --
88: begin
89: --
90: hr_utility.trace('p_tax_type ->'||p_tax_type);
91: hr_utility.trace('p_jurisdiction_code->'||p_jurisdiction_code);
92: hr_utility.trace('p_date ->'||to_char(p_date));
93: --
94: begin
95: --
96: if p_tax_type like 'COUNTY' then
123: --
124: end if;
125: --
126: RETURN TRUE;
127: hr_utility.trace('l_lit_exist ->'||l_lit_exist);
128: --
129: exception when NO_DATA_FOUND then
130: RETURN FALSE;
131: --