274: /* change for bug No. 4586534 to remove COUNT(*) to COUNT(1) by adding rownum check
275: as it is used for existence check only */
276: SELECT COUNT(1)
277: INTO l_event_pkg_exists
278: FROM cst_acct_lib_packages calp2
279: WHERE calp2.accounting_lib_id = i_acct_lib_id
280: AND calp2.event_type_id = event_type_tab(i)
281: AND ROWNUM < 2;
282:
290: INTO
291: l_accounting_package_id,
292: l_package_name
293: FROM
294: cst_acct_lib_packages calp,
295: cst_accounting_packages cap
296: WHERE
297: calp.accounting_lib_id = i_acct_lib_id AND
298: calp.event_type_id = l_event_type_id AND
308: INTO
309: l_accounting_package_id,
310: l_package_name
311: FROM
312: cst_acct_lib_packages calp,
313: cst_accounting_packages cap
314: WHERE
315: calp.accounting_lib_id = i_acct_lib_id AND
316: calp.event_type_id IS NULL AND