DBA Data[Home] [Help]

APPS.CSTPALPC dependencies on CST_ACCT_LIB_PACKAGES

Line 484: cst_acct_lib_packages calp2

480: count(*)
481: INTO
482: l_event_pkg_exists
483: FROM
484: cst_acct_lib_packages calp2
485: WHERE
486: calp2.accounting_lib_id = i_acct_lib_id AND
487: calp2.event_type_id = l_event_type_id;
488:

Line 500: cst_acct_lib_packages calp,

496: INTO
497: l_accounting_package_id,
498: l_package_name
499: FROM
500: cst_acct_lib_packages calp,
501: cst_accounting_packages cap
502: WHERE
503: calp.accounting_lib_id = i_acct_lib_id AND
504: calp.event_type_id = l_event_type_id AND

Line 518: cst_acct_lib_packages calp,

514: INTO
515: l_accounting_package_id,
516: l_package_name
517: FROM
518: cst_acct_lib_packages calp,
519: cst_accounting_packages cap
520: WHERE
521: calp.accounting_lib_id = i_acct_lib_id AND
522: calp.event_type_id IS NULL AND

Line 694: cst_acct_lib_packages calp2

690: count(*)
691: INTO
692: l_event_pkg_exists
693: FROM
694: cst_acct_lib_packages calp2
695: WHERE
696: calp2.accounting_lib_id = i_acct_lib_id AND
697: calp2.event_type_id = l_event_type_id;
698:

Line 710: cst_acct_lib_packages calp,

706: INTO
707: l_accounting_package_id,
708: l_package_name
709: FROM
710: cst_acct_lib_packages calp,
711: cst_accounting_packages cap
712: WHERE
713: calp.accounting_lib_id = i_acct_lib_id AND
714: calp.event_type_id = l_event_type_id AND

Line 728: cst_acct_lib_packages calp,

724: INTO
725: l_accounting_package_id,
726: l_package_name
727: FROM
728: cst_acct_lib_packages calp,
729: cst_accounting_packages cap
730: WHERE
731: calp.accounting_lib_id = i_acct_lib_id AND
732: calp.event_type_id IS NULL AND