DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on ASO_SALES_CREDITS

Line 3794: FROM ASO_SALES_CREDITS A,

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

Line 3803: FROM ASO_SALES_CREDITS A,

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