DBA Data[Home] [Help]

APPS.CST_PACEAMCOST_GRP dependencies on CST_CAT_ELE_EXP_ASSOCS

Line 1084: -- | |--Get Cost Element from CST_CAT_ELE_EXP_ASSOCS table (not from API)

1080: -- | |--InsertUpdate_PAC_eamPerBal
1081: -- | END LOOP
1082: -- |-- For 'Description based' Direct Items open c_wedi cursor LOOP
1083: -- | |--Get_MaintCostCat (Get category, owning dept and operating dept)
1084: -- | |--Get Cost Element from CST_CAT_ELE_EXP_ASSOCS table (not from API)
1085: -- | |--InsertUpdate_PAC_eamPerBal
1086: -- | END LOOP
1087: -- |-- For PO and REQ open c_pda cursor LOOP
1088: -- | |--Get_MaintCostCat (Get category, owning dept and operating dept)

Line 1089: -- | |--Get Cost Element from cst_CAT_ELE_EXP_ASSOCS table (not from API)

1085: -- | |--InsertUpdate_PAC_eamPerBal
1086: -- | END LOOP
1087: -- |-- For PO and REQ open c_pda cursor LOOP
1088: -- | |--Get_MaintCostCat (Get category, owning dept and operating dept)
1089: -- | |--Get Cost Element from cst_CAT_ELE_EXP_ASSOCS table (not from API)
1090: -- | |--InsertUpdate_PAC_eamPerBal
1091: -- | END LOOP
1092: --
1093: --

Line 2264: from cst_cat_ele_exp_assocs cceea

2260:
2261: BEGIN
2262: select cceea.mnt_cost_element_id, cceea.mfg_cost_element_id
2263: into l_eam_cost_element, l_mfg_cost_element_id
2264: from cst_cat_ele_exp_assocs cceea
2265: where cceea.category_id = c_wrodi_rec.category_id
2266: and NVL(cceea.end_date, SYSDATE) + 1 > SYSDATE
2267: and cceea.start_date <= sysdate;
2268: exception

Line 2432: FROM cst_cat_ele_exp_assocs cceea

2428:
2429: BEGIN
2430: SELECT cceea.mnt_cost_element_id, cceea.mfg_cost_element_id
2431: INTO l_eam_cost_element, l_mfg_cost_element_id
2432: FROM cst_cat_ele_exp_assocs cceea
2433: WHERE cceea.category_id = c_wedi_rec.category_id
2434: AND NVL(cceea.end_date, SYSDATE) + 1 > SYSDATE
2435: and cceea.start_date <= sysdate;
2436: EXCEPTION

Line 2595: FROM cst_cat_ele_exp_assocs cceea

2591:
2592: BEGIN
2593: SELECT cceea.mnt_cost_element_id, cceea.mfg_cost_element_id
2594: INTO l_eam_cost_element, l_mfg_cost_element_id
2595: FROM cst_cat_ele_exp_assocs cceea
2596: WHERE cceea.category_id = c_pda_rec.category_id
2597: AND c_pda_rec.category_date >= cceea.start_date
2598: AND c_pda_rec.category_date < (nvl(cceea.end_date, sysdate) + 1);
2599: EXCEPTION