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 2638: FROM jtf_rs_party_contacts_vl

2634: l_party_site_id IN NUMBER,
2635: l_contact_id IN NUMBER)
2636: IS
2637: SELECT 'Y'
2638: FROM jtf_rs_party_contacts_vl
2639: WHERE party_id = l_party_id
2640: AND nvl (party_site_id,-99) = nvl (l_party_site_id,-99)
2641: AND contact_id = l_contact_id;
2642:

Line 2739: /* FROM jtf_rs_party_contacts_vl

2735: l_party_site_id IN NUMBER,
2736: l_contact_id IN NUMBER)
2737: IS
2738: SELECT 'Y'
2739: /* FROM jtf_rs_party_contacts_vl
2740: WHERE party_id = l_party_id
2741: AND nvl(party_site_id, 0) = nvl(l_party_site_id, 0)
2742: AND contact_id = l_contact_id; */
2743: -- changed the query the validate party contact id according to bug 2954064 as provided by the PRM team , sudarsana 2nd july 2004