APPS.ASO_QUOTE_LINES_PVT dependencies on ASO_QUOTE_STATUSES_B

Line 2593: SELECT UPDATE_ALLOWED_FLAG, AUTO_VERSION_FLAG FROM ASO_QUOTE_STATUSES_B

2589: From ASO_QUOTE_HEADERS_ALL
2590: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
2591:
2592: CURSOR C_Qte_Status(c_qte_status_id NUMBER) IS
2593: SELECT UPDATE_ALLOWED_FLAG, AUTO_VERSION_FLAG FROM ASO_QUOTE_STATUSES_B
2594: WHERE quote_status_id = c_qte_status_id;
2595:
2596: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
2597: SELECT max(quote_version)

Line 4675: SELECT UPDATE_ALLOWED_FLAG, AUTO_VERSION_FLAG FROM ASO_QUOTE_STATUSES_B

4671: WHERE head.QUOTE_HEADER_ID = line.QUOTE_HEADER_ID
4672: AND line.QUOTE_LINE_ID = c_QUOTE_LINE_ID;
4673:
4674: CURSOR C_Qte_Status(c_qte_status_id NUMBER) IS
4675: SELECT UPDATE_ALLOWED_FLAG, AUTO_VERSION_FLAG FROM ASO_QUOTE_STATUSES_B
4676: WHERE quote_status_id = c_qte_status_id;
4677:
4678: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
4679: SELECT max(quote_version)

Line 9224: SELECT UPDATE_ALLOWED_FLAG, AUTO_VERSION_FLAG FROM ASO_QUOTE_STATUSES_B

9220: Where head.QUOTE_HEADER_ID = line.QUOTE_HEADER_ID
9221: And line.QUOTE_LINE_ID = c_QUOTE_LINE_ID;
9222:
9223: CURSOR C_Qte_Status(c_qte_status_id NUMBER) IS
9224: SELECT UPDATE_ALLOWED_FLAG, AUTO_VERSION_FLAG FROM ASO_QUOTE_STATUSES_B
9225: WHERE quote_status_id = c_qte_status_id;
9226:
9227: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
9228: SELECT max(quote_version)