eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_OPPORTUNITY_PVT dependencies on OKC_CONTACTS

Line 152: cursor c3 (p_object_code in okc_contacts.jtot_object1_code%TYPE) is

148: where dnz_chr_id = p_contract_id
149: and cle_id is null
150: and rle_code = p_rle_code;
151: --
152: cursor c3 (p_object_code in okc_contacts.jtot_object1_code%TYPE) is
153: select resource_id
154: from jtf_rs_salesreps
155: where salesrep_id in (select object1_id1
156: from okc_contacts

Line 156: from okc_contacts

152: cursor c3 (p_object_code in okc_contacts.jtot_object1_code%TYPE) is
153: select resource_id
154: from jtf_rs_salesreps
155: where salesrep_id in (select object1_id1
156: from okc_contacts
157: where dnz_chr_id = p_contract_id
158: and jtot_object1_code = p_object_code);
159: --
160: /* cursor c4 is

Line 1148: cursor ctc_csr (p_object_code in okc_contacts.jtot_object1_code%TYPE) is

1144: where dnz_chr_id = p_contract_id
1145: and cle_id is null
1146: and rle_code = p_rle_code;
1147: --
1148: cursor ctc_csr (p_object_code in okc_contacts.jtot_object1_code%TYPE) is
1149: select 'x'
1150: from okc_contacts
1151: where dnz_chr_id = p_contract_id
1152: and jtot_object1_code = p_object_code

Line 1150: from okc_contacts

1146: and rle_code = p_rle_code;
1147: --
1148: cursor ctc_csr (p_object_code in okc_contacts.jtot_object1_code%TYPE) is
1149: select 'x'
1150: from okc_contacts
1151: where dnz_chr_id = p_contract_id
1152: and jtot_object1_code = p_object_code
1153:
1154: and object1_id1 is not null; --bug 2071104