DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on ASO_SALES_CREDITS

Line 3791: FROM ASO_SALES_CREDITS A,

3787: IS
3788:
3789: CURSOR C_Quota_Header(l_quote_header_id NUMBER) IS
3790: SELECT SUM(A.percent) total
3791: FROM ASO_SALES_CREDITS A,
3792: OE_SALES_CREDIT_TYPES B
3793: WHERE A.quote_header_id = l_quote_header_id
3794: AND A.quote_line_id IS NULL
3795: AND A.sales_credit_type_id = B.sales_credit_type_id

Line 3800: FROM ASO_SALES_CREDITS A,

3796: AND B.quota_flag = 'Y';
3797:
3798: CURSOR C_Quota_Line(l_quote_header_id NUMBER, l_quote_line_id NUMBER) IS
3799: SELECT SUM(A.percent) total
3800: FROM ASO_SALES_CREDITS A,
3801: OE_SALES_CREDIT_TYPES B
3802: WHERE A.quote_header_id = l_quote_header_id
3803: AND A.quote_line_id = l_quote_line_id
3804: AND A.sales_credit_type_id = B.sales_credit_type_id