DBA Data[Home] [Help]

APPS.PA_BURDEN_COSTING dependencies on PA_COST_BASE_EXP_TYPES

Line 350: tables (mainly:PA_COST_BASE_EXP_TYPES) are accessed in the order

346: * Inclued attribute2 - attibute10 and attribute_category in select clause of the bcc_cur
347: */
348:
349: /*Bug# 2368916: Added the hint ordered in the cursor below to ensure that the
350: tables (mainly:PA_COST_BASE_EXP_TYPES) are accessed in the order
351: in which it appears in the base view -pa_cdl_burden_detail_v*/
352:
353: /*========================================================================================+
354: | 03-Feb-2004 - M - The grouping used for budgetory control projects and non-budgetory |

Line 3499: PA_COST_BASE_EXP_TYPES CBET,

3495: set (COST_PLUS_STRUCTURE ,COST_BASE) =
3496: (select /*+ ORDERED */ distinct
3497: cbcc.cost_plus_structure, cbcc.cost_base
3498: from
3499: PA_COST_BASE_EXP_TYPES CBET,
3500: PA_COMPILED_MULTIPLIERS CM,
3501: PA_COST_BASE_COST_CODES CBCC
3502: WHERE cbet.expenditure_type = ei.ei_expenditure_type
3503: AND cbet.cost_base_type = 'INDIRECT COST'