DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on PA_EXPENDITURE_TYPES

Line 8972: pa_expenditure_types pet

8968: begin
8969: select pet.expenditure_type
8970: into l_expenditure_type
8971: from cst_cat_ele_exp_assocs cceea,
8972: pa_expenditure_types pet
8973: where cceea.category_id = l_category_id
8974: and l_approved_date >= cceea.start_date
8975: and l_approved_date < (nvl(cceea.end_date, sysdate) + 1)
8976: and cceea.expenditure_type_id = pet.expenditure_type_id;