APPS.ASO_VALIDATE_PVT dependencies on OE_SALES_CREDIT_TYPES

Line 1260: * 2633507 - hyang: use oe_sales_credit_types instead of

1256: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1257: IS
1258:
1259: /*
1260: * 2633507 - hyang: use oe_sales_credit_types instead of
1261: * aso_i_sales_credit_types_v
1262: */
1263:
1264: CURSOR C_salescredit_type IS

Line 1265: select name from oe_sales_credit_types

1261: * aso_i_sales_credit_types_v
1262: */
1263:
1264: CURSOR C_salescredit_type IS
1265: select name from oe_sales_credit_types
1266: where sales_credit_type_id = p_salescredit_type_id;
1267:
1268: l_sc_type VARCHAR2(240);
1269: BEGIN

Line 3795: OE_SALES_CREDIT_TYPES B

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
3799: AND B.quota_flag = 'Y';

Line 3804: OE_SALES_CREDIT_TYPES B

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
3808: AND B.quota_flag = 'Y';