DBA Data[Home] [Help]

APPS.CSTPALBR dependencies on CST_ACCT_LIB_PACKAGES

Line 278: FROM cst_acct_lib_packages calp2

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:

Line 294: cst_acct_lib_packages calp,

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

Line 312: cst_acct_lib_packages calp,

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