455: count(*)
456: INTO
457: l_event_pkg_exists
458: FROM
459: cst_acct_lib_packages calp2
460: WHERE
461: calp2.accounting_lib_id = i_acct_lib_id AND
462: calp2.event_type_id = l_event_type_id;
463:
471: INTO
472: l_accounting_package_id,
473: l_package_name
474: FROM
475: cst_acct_lib_packages calp,
476: cst_accounting_packages cap
477: WHERE
478: calp.accounting_lib_id = i_acct_lib_id AND
479: calp.event_type_id = l_event_type_id AND
489: INTO
490: l_accounting_package_id,
491: l_package_name
492: FROM
493: cst_acct_lib_packages calp,
494: cst_accounting_packages cap
495: WHERE
496: calp.accounting_lib_id = i_acct_lib_id AND
497: calp.event_type_id IS NULL AND
665: count(*)
666: INTO
667: l_event_pkg_exists
668: FROM
669: cst_acct_lib_packages calp2
670: WHERE
671: calp2.accounting_lib_id = i_acct_lib_id AND
672: calp2.event_type_id = l_event_type_id;
673:
681: INTO
682: l_accounting_package_id,
683: l_package_name
684: FROM
685: cst_acct_lib_packages calp,
686: cst_accounting_packages cap
687: WHERE
688: calp.accounting_lib_id = i_acct_lib_id AND
689: calp.event_type_id = l_event_type_id AND
699: INTO
700: l_accounting_package_id,
701: l_package_name
702: FROM
703: cst_acct_lib_packages calp,
704: cst_accounting_packages cap
705: WHERE
706: calp.accounting_lib_id = i_acct_lib_id AND
707: calp.event_type_id IS NULL AND