DBA Data[Home] [Help]

APPS.CSTPALPC dependencies on CST_ACCT_LIB_PACKAGES

Line 459: cst_acct_lib_packages calp2

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:

Line 475: cst_acct_lib_packages calp,

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

Line 493: cst_acct_lib_packages calp,

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

Line 669: cst_acct_lib_packages calp2

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:

Line 685: cst_acct_lib_packages calp,

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

Line 703: cst_acct_lib_packages calp,

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