1080:
1081: CURSOR sales_transation_csr(p_line_id IN NUMBER) IS
1082: SELECT 1 FROM DUAL WHERE EXISTS
1083: ( SELECT 1
1084: FROM ozf_sales_transactions_all trx
1085: WHERE trx.line_id = p_line_id
1086: AND source_code = 'OM');
1087:
1088: CURSOR c_adjustment_exists (p_list_header_id IN NUMBER, p_order_line_id IN NUMBER) IS
4117: SELECT 1
4118: FROM dual
4119: WHERE EXISTS
4120: (SELECT 1
4121: FROM ozf_sales_transactions_all trx
4122: WHERE trx.line_id = p_line_id
4123: AND source_code = 'OM');
4124:
4125: CURSOR party_id_csr(p_cust_account_id IN NUMBER) IS