APPS.CSTPPLLC dependencies on CST_PAC_LOW_LEVEL_CODES

Line 484: cst_pac_low_level_codes (

480:
481: IF (SQL%ROWCOUNT > 0) THEN
482: l_update_flag := TRUE;
483: INSERT INTO
484: cst_pac_low_level_codes (
485: pac_period_id,
486: cost_group_id,
487: inventory_item_id,
488: low_level_code,

Line 536: cst_pac_low_level_codes cpllc

532: considered as leaf nodes even if they might appear with LLC of 1000
533: ------------------------------------------------------------------------*/
534:
535: DELETE FROM
536: cst_pac_low_level_codes cpllc
537: WHERE low_level_code = 1000
538: AND cost_group_id = i_cost_group_id
539: AND pac_period_id = i_pac_period_id
540: AND NOT EXISTS (

Line 550: cst_pac_low_level_codes

546:
547: EXCEPTION
548: WHEN LOOP_WARNING THEN
549: DELETE FROM
550: cst_pac_low_level_codes
551: WHERE cost_group_id = i_cost_group_id
552: AND pac_period_id = i_pac_period_id;
553: DELETE FROM
554: cst_pac_explosion_temp

Line 569: cst_pac_low_level_codes

565: || 'transactions within this period. Recalculating the '
566: || 'low level codes to verify...';
567: WHEN LOOP_ERROR THEN
568: DELETE FROM
569: cst_pac_low_level_codes
570: WHERE cost_group_id = i_cost_group_id
571: AND pac_period_id = i_pac_period_id;
572:
573: o_err_num := -999;