eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_EAMCOST_PUB dependencies on CST_CAT_ELE_EXP_ASSOCS

Line 4319: from cst_cat_ele_exp_assocs cceea

4315:
4316: BEGIN
4317: select cceea.mnt_cost_element_id,cceea.mfg_cost_element_id
4318: into l_eam_cost_element,l_mfg_cost_element_id
4319: from cst_cat_ele_exp_assocs cceea
4320: where cceea.category_id = c_wrodi_rec.category_id
4321: and NVL(cceea.end_date, SYSDATE) + 1 > SYSDATE
4322: and cceea.start_date <= sysdate;
4323: exception

Line 4593: from cst_cat_ele_exp_assocs cceea

4589:
4590: BEGIN
4591: select cceea.mnt_cost_element_id,cceea.mfg_cost_element_id
4592: into l_eam_cost_element,l_mfg_cost_element_id
4593: from cst_cat_ele_exp_assocs cceea
4594: where cceea.category_id = c_wedi_rec.category_id
4595: and NVL(cceea.end_date, SYSDATE) + 1 > SYSDATE
4596: and cceea.start_date <= sysdate;
4597: exception

Line 4898: from cst_cat_ele_exp_assocs cceea

4894: l_stmt_num := 190;
4895: begin
4896: select cceea.mnt_cost_element_id, cceea.mfg_cost_element_id
4897: into l_eam_cost_element, l_mfg_cost_element_id
4898: from cst_cat_ele_exp_assocs cceea
4899: where cceea.category_id = c_pda_rec.category_id
4900: and l_approved_date >= cceea.start_date
4901: and l_approved_date < (nvl(cceea.end_date, sysdate) + 1);
4902: exception

Line 9354: from cst_cat_ele_exp_assocs cceea

9350: if p_mnt_or_mfg = 1 then
9351: begin
9352: select cceea.mnt_cost_element_id
9353: into l_cost_element_id
9354: from cst_cat_ele_exp_assocs cceea
9355: where cceea.category_id = l_category_id
9356: and l_approved_date >= cceea.start_date
9357: and l_approved_date < (nvl(cceea.end_date,sysdate) + 1);
9358: exception

Line 9366: from cst_cat_ele_exp_assocs cceea

9362: else
9363: begin
9364: select cceea.mfg_cost_element_id
9365: into l_cost_element_id
9366: from cst_cat_ele_exp_assocs cceea
9367: where cceea.category_id = l_category_id
9368: and l_approved_date >= cceea.start_date
9369: and l_approved_date < (nvl(cceea.end_date, sysdate) + 1);
9370: exception

Line 9630: from cst_cat_ele_exp_assocs cceea,

9626: if (l_category_id <> -1 and l_approved_date is not null) then
9627: begin
9628: select pet.expenditure_type
9629: into l_expenditure_type
9630: from cst_cat_ele_exp_assocs cceea,
9631: pa_expenditure_types pet
9632: where cceea.category_id = l_category_id
9633: and l_approved_date >= cceea.start_date
9634: and l_approved_date < (nvl(cceea.end_date, sysdate) + 1)