86: INTO x_aux
87: FROM sys.dual
88: WHERE EXISTS (
89: SELECT null
90: FROM FND_LOOKUPS
91: WHERE lookup_type = 'JLBR_ARREARS_CODE'
92: AND lookup_code = e_arrears_code );
93: EXCEPTION
94: WHEN NO_DATA_FOUND THEN
136:
137: BEGIN
138: SELECT '1'
139: INTO x_register_type
140: FROM fnd_lookups
141: WHERE lookup_code = e_drawee_inscription_type
142: AND lookup_type = 'JLBR_INSCRIPTION_TYPE'
143: AND NVL(end_date_active,sysdate + 1) > sysdate;
144: EXCEPTION