291:
292:
293: /* Validation to check Pay_element_code is available */
294:
295: select count(1) into l_value_exists from pa_lookups
296: where lookup_type = 'PA_THIRD_PARTY_PAY_ELEMENTS'
297: and lookup_code = Details_rec.pay_element_type_code
298: and enabled_flag = 'Y'
299: and NVL(predefined_flag,'O') IN ('E','I','S','T','L','O') /* Bug 12998980 */