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 3792: OE_SALES_CREDIT_TYPES B

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

Line 3801: OE_SALES_CREDIT_TYPES B

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