APPS.JTF_RS_RESOURCE_PUB dependencies on JTF_RS_PARTY_CONTACTS_VL

Line 271: FROM jtf_rs_party_contacts_vl

267: l_party_site_id IN NUMBER,
268: l_contact_id IN NUMBER)
269: IS
270: SELECT 'Y'
271: FROM jtf_rs_party_contacts_vl
272: WHERE party_id = l_party_id
273: AND nvl (party_site_id,-99) = nvl (l_party_site_id,-99)
274: AND contact_id = l_contact_id;
275:

Line 375: /* FROM jtf_rs_party_contacts_vl

371: l_party_site_id IN NUMBER,
372: l_contact_id IN NUMBER)
373: IS
374: SELECT 'Y'
375: /* FROM jtf_rs_party_contacts_vl
376: WHERE party_id = l_party_id
377: AND nvl(party_site_id, 0) = nvl(l_party_site_id, 0)
378: AND contact_id = l_contact_id; */
379: -- changed the query the validate party contact id according to bug 2954064 as provided by the PRM team , sudarsana 2nd july 2004

Line 2419: FROM jtf_rs_party_contacts_vl

2415: l_party_site_id IN NUMBER,
2416: l_contact_id IN NUMBER)
2417: IS
2418: SELECT 'Y'
2419: FROM jtf_rs_party_contacts_vl
2420: WHERE party_id = l_party_id
2421: AND nvl (party_site_id,-99) = nvl (l_party_site_id,-99)
2422: AND contact_id = l_contact_id;
2423:

Line 2520: /* FROM jtf_rs_party_contacts_vl

2516: l_party_site_id IN NUMBER,
2517: l_contact_id IN NUMBER)
2518: IS
2519: SELECT 'Y'
2520: /* FROM jtf_rs_party_contacts_vl
2521: WHERE party_id = l_party_id
2522: AND nvl(party_site_id, 0) = nvl(l_party_site_id, 0)
2523: AND contact_id = l_contact_id; */
2524: -- changed the query the validate party contact id according to bug 2954064 as provided by the PRM team , sudarsana 2nd july 2004