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 4097: from cst_cat_ele_exp_assocs cceea

4093:
4094: BEGIN
4095: select cceea.mnt_cost_element_id,cceea.mfg_cost_element_id
4096: into l_eam_cost_element,l_mfg_cost_element_id
4097: from cst_cat_ele_exp_assocs cceea
4098: where cceea.category_id = c_wrodi_rec.category_id
4099: and NVL(cceea.end_date, SYSDATE) + 1 > SYSDATE
4100: and cceea.start_date <= sysdate;
4101: exception

Line 4371: from cst_cat_ele_exp_assocs cceea

4367:
4368: BEGIN
4369: select cceea.mnt_cost_element_id,cceea.mfg_cost_element_id
4370: into l_eam_cost_element,l_mfg_cost_element_id
4371: from cst_cat_ele_exp_assocs cceea
4372: where cceea.category_id = c_wedi_rec.category_id
4373: and NVL(cceea.end_date, SYSDATE) + 1 > SYSDATE
4374: and cceea.start_date <= sysdate;
4375: exception

Line 4676: from cst_cat_ele_exp_assocs cceea

4672: l_stmt_num := 190;
4673: begin
4674: select cceea.mnt_cost_element_id, cceea.mfg_cost_element_id
4675: into l_eam_cost_element, l_mfg_cost_element_id
4676: from cst_cat_ele_exp_assocs cceea
4677: where cceea.category_id = c_pda_rec.category_id
4678: and l_approved_date >= cceea.start_date
4679: and l_approved_date < (nvl(cceea.end_date, sysdate) + 1);
4680: exception

Line 8749: from cst_cat_ele_exp_assocs cceea

8745: if p_mnt_or_mfg = 1 then
8746: begin
8747: select cceea.mnt_cost_element_id
8748: into l_cost_element_id
8749: from cst_cat_ele_exp_assocs cceea
8750: where cceea.category_id = l_category_id
8751: and l_approved_date >= cceea.start_date
8752: and l_approved_date < (nvl(cceea.end_date,sysdate) + 1);
8753: exception

Line 8761: from cst_cat_ele_exp_assocs cceea

8757: else
8758: begin
8759: select cceea.mfg_cost_element_id
8760: into l_cost_element_id
8761: from cst_cat_ele_exp_assocs cceea
8762: where cceea.category_id = l_category_id
8763: and l_approved_date >= cceea.start_date
8764: and l_approved_date < (nvl(cceea.end_date, sysdate) + 1);
8765: exception

Line 8971: from cst_cat_ele_exp_assocs cceea,

8967: if (l_category_id <> -1 and l_approved_date is not null) then
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)