DBA Data[Home] [Help]

APPS.PA_BURDEN_COSTING dependencies on PA_COST_BASE_EXP_TYPES

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

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

Line 3341: PA_COST_BASE_EXP_TYPES CBET,

3337: set (COST_PLUS_STRUCTURE ,COST_BASE) =
3338: (select /*+ ORDERED */ distinct
3339: cbcc.cost_plus_structure, cbcc.cost_base
3340: from
3341: PA_COST_BASE_EXP_TYPES CBET,
3342: PA_COMPILED_MULTIPLIERS CM,
3343: PA_COST_BASE_COST_CODES CBCC
3344: WHERE cbet.expenditure_type = ei.ei_expenditure_type
3345: AND cbet.cost_base_type = 'INDIRECT COST'