APPS.AR_GTA_ARTRX_PROC dependencies on OE_PRICE_ADJUSTMENTS

Line 2171: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;

2167: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2168: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2169: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2170: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2171: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2172: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2173: l_discount_flag ar_gta_trx_lines_all.discount_flag%TYPE;
2174: l_tax_amount ar_gta_trx_lines_all.tax_amount%TYPE;
2175: l_discount_amount_func_curr ar_gta_trx_lines_all.discount_amount%TYPE; --Yao add for bug#9132371

Line 2206: FROM oe_price_adjustments opa

2202: --Yao Zhang Add for bug#8605196 to support discount line
2203: --c_discount_lines used to query discount lines for ar transaction line.
2204: CURSOR c_discount_lines(l_line_id IN NUMBER) IS
2205: SELECT opa.price_adjustment_id
2206: FROM oe_price_adjustments opa
2207: WHERE opa.line_id = l_line_id
2208: AND opa.list_line_type_code = 'DIS';
2209:
2210: BEGIN

Line 3024: FROM oe_price_adjustments opa

3020: l_price_adjustment_id <> 0) THEN
3021: BEGIN
3022: SELECT opa.list_line_type_code
3023: INTO l_adjustment_type
3024: FROM oe_price_adjustments opa
3025: WHERE opa.price_adjustment_id = l_price_adjustment_id;
3026: EXCEPTION
3027: WHEN no_data_found THEN
3028: CLOSE c_ra_lines;