DBA Data[Home] [Help]

APPS.CSTPALBR dependencies on CST_ACCT_LIB_PACKAGES

Line 296: FROM cst_acct_lib_packages calp2

292: /* change for bug No. 4586534 to remove COUNT(*) to COUNT(1) by adding rownum check
293: as it is used for existence check only */
294: SELECT COUNT(1)
295: INTO l_event_pkg_exists
296: FROM cst_acct_lib_packages calp2
297: WHERE calp2.accounting_lib_id = i_acct_lib_id
298: AND calp2.event_type_id = event_type_tab(i)
299: AND ROWNUM < 2;
300:

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 = l_event_type_id AND

Line 330: cst_acct_lib_packages calp,

326: INTO
327: l_accounting_package_id,
328: l_package_name
329: FROM
330: cst_acct_lib_packages calp,
331: cst_accounting_packages cap
332: WHERE
333: calp.accounting_lib_id = i_acct_lib_id AND
334: calp.event_type_id IS NULL AND