123: l_exists := 'N';
124: END IF;
125: CLOSE csr_in_area;
126: IF l_exists = 'N' THEN
127: hr_utility.trace('Trigger not in any area, execute code');
128: l_execute := TRUE;
129: ELSE
130: --
131: -- Otherwise do not execute the trigger code by default
143: l_exists := 'N';
144: END IF;
145: CLOSE csr_leg_enb;
146: IF l_exists = 'Y' THEN
147: hr_utility.trace('Trigger enabled by legislation, execute code');
148: l_execute := TRUE;
149: END IF;
150: END IF;
151: --
161: l_exists := 'N';
162: END IF;
163: CLOSE csr_bus_enb;
164: IF l_exists = 'Y' THEN
165: hr_utility.trace('Trigger enabled by business group, execute code');
166: l_execute := TRUE;
167: END IF;
168: END IF;
169: --
179: l_exists := 'N';
180: END IF;
181: CLOSE csr_pay_enb;
182: IF l_exists = 'Y' THEN
183: hr_utility.trace('Trigger enabled by payroll, execute code');
184: l_execute := TRUE;
185: END IF;
186: END IF;
187: --