APPS.OKS_MASSCHANGE_PVT dependencies on OKC_GOVERNANCES_V

Line 575: l_where||'AND EXISTS (SELECT ''x'' from okc_governances_v ogv

571:
572: l_old_value := p_ctr_rec.old_value;
573: l_stmt := l_select||' , :l_old_value old_value'||
574: l_from||
575: l_where||'AND EXISTS (SELECT ''x'' from okc_governances_v ogv
576: WHERE ogv.dnz_chr_id = okh.id
577: AND ogv.isa_agreement_id = :p_ctr_rec_old_value)
578: AND okh.id = to_number(:update_level_value)';
579: ------------------------------------------------------------------------------

Line 1724: l_where||'AND EXISTS (SELECT ''x'' from okc_governances_v ogv

1720:
1721: l_old_value := p_ctr_rec.old_value;
1722: l_stmt := l_select||' , :l_old_value old_value'||
1723: l_from||
1724: l_where||'AND EXISTS (SELECT ''x'' from okc_governances_v ogv
1725: WHERE ogv.dnz_chr_id = okh.id
1726: AND ogv.isa_agreement_id = :p_ctr_rec_old_value)
1727: AND okh.org_id = to_number(:update_level_value)';
1728:

Line 2881: l_where||'AND EXISTS (SELECT ''x'' from okc_governances_v ogv

2877:
2878: l_old_value := p_ctr_rec.old_value;
2879: l_stmt := l_select||' , :l_old_value old_value'||
2880: l_from||',okc_k_party_roles_v okp1'||
2881: l_where||'AND EXISTS (SELECT ''x'' from okc_governances_v ogv
2882: WHERE ogv.dnz_chr_id = okh.id
2883: AND ogv.isa_agreement_id = :p_ctr_rec_old_value)
2884: AND okh.id = okp1.chr_id
2885: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 4156: l_where||'AND EXISTS (SELECT ''x'' from okc_governances_v ogv

4152:
4153: l_old_value := p_ctr_rec.old_value;
4154: l_stmt := l_select||' , :l_old_value old_value'||
4155: l_from||
4156: l_where||'AND EXISTS (SELECT ''x'' from okc_governances_v ogv
4157: WHERE ogv.dnz_chr_id = okh.id
4158: AND ogv.isa_agreement_id = :p_ctr_rec_old_value)
4159: AND okh.scs_code=:update_level_value';
4160:

Line 5362: l_where||'AND EXISTS (SELECT ''x'' from okc_governances_v ogv

5358:
5359: l_old_value := p_ctr_rec.old_value;
5360: l_stmt := l_select||' , :l_old_value old_value'||
5361: l_from||
5362: l_where||'AND EXISTS (SELECT ''x'' from okc_governances_v ogv
5363: WHERE ogv.dnz_chr_id = okh.id
5364: AND ogv.isa_agreement_id = :p_ctr_rec_old_value)
5365: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1
5366: WHERE okg1.included_chr_id is not null

Line 6989: FROM okc_governances_v ogv

6985: AND nvl(oksh.renewal_po_required,'N') = p_old_value ;
6986:
6987: CURSOR Get_agreement_name(p_chr_id IN Number, p_old_value IN Varchar2) IS
6988: SELECT ogv.id, ogv.object_version_number
6989: FROM okc_governances_v ogv
6990: WHERE ogv.dnz_chr_id = p_chr_id
6991: AND ogv.isa_agreement_id = p_old_value ;
6992:
6993: CURSOR Get_contact(p_chr_id IN Number,p_cro_code IN Varchar2,