DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_QUOTE_STATUSES_B

Line 52: FROM ASO_QUOTE_STATUSES_B

48: CURSOR C_Qte_Status_Id (
49: c_status_code VARCHAR2
50: ) IS
51: SELECT quote_status_id
52: FROM ASO_QUOTE_STATUSES_B
53: WHERE status_code = c_status_code;
54:
55: CURSOR C_Qte_Number_exists (
56: X_qte_number NUMBER

Line 74: FROM ASO_QUOTE_STATUSES_B

70: CURSOR C_Check_Qte_Status (
71: qte_status_id NUMBER
72: ) IS
73: SELECT 'X'
74: FROM ASO_QUOTE_STATUSES_B
75: WHERE quote_status_id = qte_status_id
76: AND status_code NOT IN ('ORDER SUBMITTED'
77: , 'APPROVAL PENDING'
78: , 'FINANCING PENDING'