APPS.OKC_PRICE_PVT dependencies on OKC_PRICE_ADJ_ASSOCS_V

Line 5298: select id from okc_price_adj_assocs_v

5294:
5295: declare
5296:
5297: cursor c1(p_pat_id_from number ,p_pat_id number ,p_cle_id number) is
5298: select id from okc_price_adj_assocs_v
5299: where pat_id_from = p_pat_id_from
5300: and pat_id =p_pat_id
5301: and cle_id = p_cle_id;
5302:

Line 6152: from okc_price_adj_assocs_v

6148: cle_id = p_id and chr_id=pchr_id
6149: and applied_flag='Y'
6150: --do not process child detail lines -- tope pbh changes
6151: and id not in (Select pat_id
6152: from okc_price_adj_assocs_v
6153: where cle_id =p_id
6154: and pat_id_from is not null
6155: and pat_id = a.id);
6156: --tope pbh changes

Line 6170: from okc_price_adj_assocs_v a, okc_price_adjustments b

6166:
6167:
6168: cursor l_related_lines(p_pat_id number,p_cle_id number) is
6169: select b.*
6170: from okc_price_adj_assocs_v a, okc_price_adjustments b
6171: where a.pat_id_from =p_pat_id
6172: and a.pat_id = b.id
6173: and a.cle_id =p_cle_id
6174: and a.cle_id = b.cle_id;