DBA Data[Home] [Help]

APPS.OKC_CHR_PVT dependencies on OKX_LIST_HEADERS_V

Line 1985: from okx_list_headers_v

1981:
1982: -- Bug 2661571 ricagraw
1983: /* Cursor l_price_list_id_csr Is
1984: select 'x'
1985: from okx_list_headers_v
1986: WHERE id1 = p_chrv_rec.price_list_id
1987: and status = 'A'
1988: and currency_code = p_chrv_rec.currency_code
1989: and sysdate between nvl(start_date_active,sysdate)

Line 1995: FROM okx_list_headers_v

1991: */
1992: -- Bug 2661571 ricagraw
1993: CURSOR l_price_list_id_csr IS
1994: SELECT 'x'
1995: FROM okx_list_headers_v
1996: WHERE id1 = p_chrv_rec.price_list_id
1997: AND ((status = 'A' AND p_chrv_rec.pricing_date IS NULL) OR
1998: (p_chrv_rec.pricing_date IS NOT NULL
1999: AND p_chrv_rec.pricing_date BETWEEN