APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on CST_PAC_LOW_LEVEL_CODES

Line 1236: FROM cst_pac_low_level_codes cpllc

1232: AND mpacd.cost_group_id = p_cost_group_id
1233: AND mpacd.pac_period_id = p_pac_period_id
1234: AND mpacd.inventory_item_id = p_inventory_item_id
1235: AND NOT EXISTS (SELECT 1
1236: FROM cst_pac_low_level_codes cpllc
1237: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
1238: AND cpllc.pac_period_id = p_pac_period_id
1239: AND cpllc.cost_group_id = p_cost_group_id);
1240: ELSE

Line 1257: FROM cst_pac_low_level_codes cpllc

1253: AND mpacd.cost_group_id = p_cost_group_id
1254: AND mpacd.pac_period_id = p_pac_period_id
1255: AND mpacd.inventory_item_id = p_inventory_item_id
1256: AND EXISTS (SELECT 1
1257: FROM cst_pac_low_level_codes cpllc
1258: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
1259: AND cpllc.low_level_code = p_low_level_code
1260: AND cpllc.pac_period_id = p_pac_period_id
1261: AND cpllc.cost_group_id = p_cost_group_id);

Line 1372: FROM cst_pac_low_level_codes cpllc

1368: AND cppb.cost_element_id = cpicd.cost_element_id
1369: AND cppb.level_type = cpicd.level_type
1370: AND cppb.inventory_item_id = p_inventory_item_id)
1371: AND NOT EXISTS (SELECT 1
1372: FROM cst_pac_low_level_codes cpllc
1373: WHERE cpllc.pac_period_id = p_pac_period_id
1374: AND cpllc.cost_group_id = p_cost_group_id
1375: AND cpllc.inventory_item_id = p_inventory_item_id);
1376:

Line 1450: FROM cst_pac_low_level_codes cpllc

1446: AND cppb.cost_group_id = p_cost_group_id
1447: AND cppb.cost_layer_id = cpic.cost_layer_id
1448: AND cppb.inventory_item_id = p_inventory_item_id)
1449: AND NOT EXISTS (SELECT 1
1450: FROM cst_pac_low_level_codes cpllc
1451: WHERE cpllc.inventory_item_id = cpic.inventory_item_id
1452: AND cpllc.pac_period_id = p_pac_period_id
1453: AND cpllc.cost_group_id = p_cost_group_id)
1454: AND EXISTS

Line 1531: FROM cst_pac_low_level_codes cpllc

1527: AND cppb.cost_element_id = cpicd.cost_element_id
1528: AND cppb.level_type = cpicd.level_type
1529: AND cppb.inventory_item_id = p_inventory_item_id)
1530: AND EXISTS (SELECT 1
1531: FROM cst_pac_low_level_codes cpllc
1532: WHERE cpllc.low_level_code = p_low_level_code
1533: AND cpllc.pac_period_id = p_pac_period_id
1534: AND cpllc.cost_group_id = p_cost_group_id
1535: );

Line 1610: FROM cst_pac_low_level_codes cpllc

1606: AND cppb.cost_group_id = p_cost_group_id
1607: AND cppb.cost_layer_id = cpic.cost_layer_id
1608: AND cppb.inventory_item_id = p_inventory_item_id)
1609: AND EXISTS (SELECT 1
1610: FROM cst_pac_low_level_codes cpllc
1611: WHERE cpllc.low_level_code = p_low_level_code
1612: AND cpllc.inventory_item_id = cpic.inventory_item_id
1613: AND cpllc.pac_period_id = p_pac_period_id
1614: AND cpllc.cost_group_id = p_cost_group_id)

Line 1678: FROM cst_pac_low_level_codes

1674: )
1675: IS
1676: SELECT
1677: low_level_code
1678: FROM cst_pac_low_level_codes
1679: WHERE pac_period_id = c_pac_period_id
1680: AND cost_group_id = c_cost_group_id
1681: AND inventory_item_id = c_inventory_item_id;
1682:

Line 3322: cst_pac_low_level_codes cpllc

3318: AND mp.process_enabled_flag = 'N'
3319: AND NOT EXISTS (
3320: SELECT 'X'
3321: FROM
3322: cst_pac_low_level_codes cpllc
3323: WHERE cpllc.inventory_item_id = ccit.inventory_item_id
3324: AND cpllc.pac_period_id = p_period_id
3325: AND cpllc.cost_group_id = p_cost_group_id);
3326:

Line 3370: FROM cst_pac_low_level_codes cpllc

3366: AND cpiit.pac_period_id = p_period_id
3367: AND cpiit.inventory_item_id = ccit.inventory_item_id)
3368: AND NOT EXISTS (
3369: SELECT 'X'
3370: FROM cst_pac_low_level_codes cpllc
3371: WHERE cpllc.inventory_item_id = ccit.inventory_item_id
3372: AND cpllc.pac_period_id = p_period_id
3373: AND cpllc.cost_group_id = p_cost_group_id);
3374:

Line 3405: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp, cst_pac_low_level_codes cpllc

3401: , 0
3402: , 0
3403: , 'N'
3404: , 'Y'
3405: FROM CST_PAC_INTERORG_TXNS_TMP ccit, mtl_parameters mp, cst_pac_low_level_codes cpllc
3406: WHERE ccit.cost_group_id = p_cost_group_id
3407: AND ccit.pac_period_id = p_period_id
3408: AND ccit.txn_type = 1
3409: AND mp.organization_id = ccit.transfer_organization_id

Line 3444: FROM CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_low_level_codes cpllc

3440: , 'N'
3441: , 'N'
3442: , 'Y'
3443: , 1
3444: FROM CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_low_level_codes cpllc
3445: WHERE ccit.cost_group_id = p_cost_group_id
3446: AND ccit.pac_period_id = p_period_id
3447: AND ccit.txn_type = 2
3448: AND cpllc.inventory_item_id = ccit.inventory_item_id