DBA Data[Home] [Help]

APPS.OKC_OPPORTUNITY_PVT dependencies on JTF_RS_SALESREPS

Line 154: from jtf_rs_salesreps

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
157: where dnz_chr_id = p_contract_id
158: and jtot_object1_code = p_object_code);

Line 164: from jtf_rs_salesreps

160: /* cursor c4 is
161: select sales_group_id
162: from as_fc_salesforce_v
163: where salesforce_id = (select resource_id
164: from jtf_rs_salesreps
165: where salesrep_id = g_sales_rep); */
166: --
167: cursor c5(p_rule_information_category IN
168: okc_rules_b.rule_information_category%TYPE) is