APPS.CSTPPINV dependencies on CST_PAC_LOW_LEVEL_CODES

Line 3339: FROM cst_pac_low_level_codes cpllc

3335: AND ccga0.cost_group_id = i_cost_group_id))
3336: ))
3337: AND NOT EXISTS (
3338: SELECT 'X'
3339: FROM cst_pac_low_level_codes cpllc
3340: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
3341: AND cpllc.pac_period_id = i_pac_period_id
3342: AND cpllc.cost_group_id = i_cost_group_id)
3343: ORDER BY inventory_item_id;

Line 3697: FROM cst_pac_low_level_codes cpllc

3693: AND c2.organization_id = mmt.transfer_organization_id
3694: AND c1.cost_group_id = c2.cost_group_id))
3695: AND NOT EXISTS (
3696: SELECT 'X'
3697: FROM cst_pac_low_level_codes cpllc
3698: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
3699: AND cpllc.pac_period_id = i_pac_period_id
3700: AND cpllc.cost_group_id = i_cost_group_id)
3701: union all

Line 3732: FROM cst_pac_low_level_codes cpllc

3728: OR (transaction_action_id in (1,27)
3729: AND transaction_source_type_id NOT IN (1,3,6,13)) )
3730: AND NOT EXISTS (
3731: SELECT 'X'
3732: FROM cst_pac_low_level_codes cpllc
3733: WHERE cpllc.inventory_item_id = mmt.inventory_item_id
3734: AND cpllc.pac_period_id = i_pac_period_id
3735: AND cpllc.cost_group_id = i_cost_group_id)
3736: ORDER BY 4; /* order by inventory item id */