DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_QUOTE_STATUSES_B

Line 58: FROM ASO_QUOTE_STATUSES_B

54: CURSOR C_Qte_Status_Id (
55: c_status_code VARCHAR2
56: ) IS
57: SELECT quote_status_id
58: FROM ASO_QUOTE_STATUSES_B
59: WHERE status_code = c_status_code;
60:
61: CURSOR C_Qte_Number_exists (
62: X_qte_number NUMBER

Line 80: FROM ASO_QUOTE_STATUSES_B

76: CURSOR C_Check_Qte_Status (
77: qte_status_id NUMBER
78: ) IS
79: SELECT 'X'
80: FROM ASO_QUOTE_STATUSES_B
81: WHERE quote_status_id = qte_status_id
82: AND status_code NOT IN ('ORDER SUBMITTED'
83: , 'APPROVAL PENDING'
84: , 'FINANCING PENDING'