APPS.ASO_SALES_CREDIT_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 51: FROM ASO_QUOTE_LINES_ALL

47: AND Status_Code = 'ORDER SUBMITTED';
48:
49: CURSOR C_Check_Qte_Line (l_qte_hdr NUMBER) IS
50: SELECT 'Y'
51: FROM ASO_QUOTE_LINES_ALL
52: WHERE Quote_Header_Id = l_qte_hdr;
53:
54: CURSOR C_Get_Sreps_Count (l_qte_num NUMBER) IS
55: SELECT Count (Resource_Id)

Line 521: FROM ASO_QUOTE_LINES_ALL

517: AND Quote_Line_Id = l_qte_line;
518:
519: CURSOR C_Get_Line (l_qte_hdr NUMBER) IS
520: SELECT Quote_Line_Id
521: FROM ASO_QUOTE_LINES_ALL
522: WHERE Quote_Header_Id = l_qte_hdr;
523:
524: CURSOR C_Hd_Inter IS
525: SELECT Credit_Rule_Id, Process_Status

Line 705: FROM ASO_QUOTE_LINES_ALL A

701: C_Party_Site_Rec.County,
702: C_Party_Site_Rec.Postal_Code,
703: p_qte_header_rec.Marketing_Source_Code_Id,
704: p_qte_header_rec.Sales_Channel_Code
705: FROM ASO_QUOTE_LINES_ALL A
706: WHERE Quote_Header_Id = p_qte_header_rec.Quote_Header_Id;
707:
708: END IF;
709: