DBA Data[Home] [Help]

APPS.PA_BILLING_PUB dependencies on PA_COST_BASE_EXP_TYPES

Line 369: from pa_cost_base_exp_types cb

365: OR X_system_linkage IS NULL)
366: AND rdl.request_id = X_request_id
367: AND (EXISTS
368: (select '1'
369: from pa_cost_base_exp_types cb
370: where cb.expenditure_type = ei.expenditure_type
371: and cb.cost_base = X_cost_base
372: and cb.cost_plus_structure = X_CP_structure
373: and cb.cost_base_type = X_CB_type)

Line 436: from pa_cost_base_exp_types cb

432: AND ei.adjusted_expenditure_item_id = ei2.expenditure_item_id (+)
433: AND ei2.expenditure_item_id = rdl2.expenditure_item_id (+)
434: AND (EXISTS
435: (select '1'
436: from pa_cost_base_exp_types cb
437: where cb.expenditure_type = ei.expenditure_type
438: and cb.cost_base = X_cost_base
439: and cb.cost_plus_structure = X_CP_structure
440: and cb.cost_base_type = X_CB_type)

Line 478: from pa_cost_base_exp_types cb

474: AND (ei.system_linkage_function = X_system_linkage
475: OR X_system_linkage IS NULL)
476: AND (EXISTS
477: (select '1'
478: from pa_cost_base_exp_types cb
479: where cb.expenditure_type = ei.expenditure_type
480: and cb.cost_base = X_cost_base
481: and cb.cost_plus_structure = X_CP_structure
482: and cb.cost_base_type = X_CB_type)