APPS.CSTPPINV dependencies on CST_PAC_LOW_LEVEL_CODES

Line 3287: FROM cst_pac_low_level_codes cpllc

3283: AND ccga0.cost_group_id = i_cost_group_id))
3284: ))
3285: AND NOT EXISTS (
3286: SELECT 'X'
3287: FROM cst_pac_low_level_codes cpllc
3288: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
3289: AND cpllc.pac_period_id = i_pac_period_id
3290: AND cpllc.cost_group_id = i_cost_group_id)
3291: ORDER BY inventory_item_id;

Line 3645: FROM cst_pac_low_level_codes cpllc

3641: AND c2.organization_id = mmt.transfer_organization_id
3642: AND c1.cost_group_id = c2.cost_group_id))
3643: AND NOT EXISTS (
3644: SELECT 'X'
3645: FROM cst_pac_low_level_codes cpllc
3646: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
3647: AND cpllc.pac_period_id = i_pac_period_id
3648: AND cpllc.cost_group_id = i_cost_group_id)
3649: union all

Line 3684: FROM cst_pac_low_level_codes cpllc

3680: OR (transaction_action_id in (1,27)
3681: AND transaction_source_type_id NOT IN (1,3,6,13)) )
3682: AND NOT EXISTS (
3683: SELECT 'X'
3684: FROM cst_pac_low_level_codes cpllc
3685: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
3686: AND cpllc.pac_period_id = i_pac_period_id
3687: AND cpllc.cost_group_id = i_cost_group_id)
3688: ORDER BY 4; /* order by inventory item id */