APPS.ASO_QUOTE_STATUS_PKG dependencies on ASO_QUOTE_STATUSES_VL

Line 644: CURSOR C2 IS SELECT QUOTE_STATUS_ID FROM ASO_QUOTE_STATUSES_VL

640: row_id varchar2(64);
641: lx_quote_id number;
642: l_quote_status_id number;
643: CURSOR C IS SELECT ASO_QUOTE_STATUSES_B_S.nextval FROM dual;
644: CURSOR C2 IS SELECT QUOTE_STATUS_ID FROM ASO_QUOTE_STATUSES_VL
645: WHERE STATUS_CODE= X_STATUS_CODE;
646:
647: begin
648: -- get the user id

Line 832: FROM ASO_QUOTE_STATUSES_VL

828:
829: L_QUOTE_STATUS_ID NUMBER(22);
830:
831: CURSOR c2 is select QUOTE_STATUS_ID
832: FROM ASO_QUOTE_STATUSES_VL
833: WHERE STATUS_CODE = X_STATUS_CODE ;
834:
835: BEGIN
836: