APPS.ZPB_DC_OBJECTS_PVT dependencies on ZPB_AC_PARAM_VALUES

Line 750: SELECT value FROM ZPB_AC_PARAM_VALUES

746: FROM zpb_task_parameters
747: WHERE task_id = p_task_id;
748:
749: CURSOR l_ac_param_val_cursor IS
750: SELECT value FROM ZPB_AC_PARAM_VALUES
751: WHERE ANALYSIS_CYCLE_ID = p_ac_id
752: AND PARAM_ID = l_currency_param_id;
753:
754: CURSOR c_bus_area IS

Line 826: SELECT count(*) into l_have_entered_currency FROM ZPB_AC_PARAM_VALUES

822:
823: if l_ac_param_val_cursor %FOUND then
824: l_currency_flag := 'Y';
825:
826: SELECT count(*) into l_have_entered_currency FROM ZPB_AC_PARAM_VALUES
827: WHERE ANALYSIS_CYCLE_ID = p_ac_id
828: AND PARAM_ID = l_entered AND value = 'Y';
829:
830: if l_have_entered_currency > 0 then