APPS.JTF_ASSIGN_PUB dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 2184: FROM jtf_rs_resource_extns_vl

2180:
2181: CURSOR cur_ib_resources IS
2182: SELECT resource_id,
2183: 'RS_'||category category
2184: FROM jtf_rs_resource_extns_vl
2185: WHERE source_id = l_cs_contacts_rsc_id
2186: AND category = l_cs_contacts_rsc_cat;
2187:
2188: l_cur_ib_resources cur_ib_resources%ROWTYPE;

Line 2207: FROM jtf_rs_resource_extns_vl

2203:
2204: CURSOR cur_ib_supp_resources IS
2205: SELECT resource_id,
2206: 'RS_'||category category
2207: FROM jtf_rs_resource_extns_vl
2208: WHERE source_id = l_cs_contacts_rsc_id
2209: AND category = 'SUPPLIER_CONTACT';
2210:
2211:

Line 2758: FROM jtf_rs_resource_extns_vl

2754:
2755: CURSOR cur_ib_resources IS
2756: SELECT resource_id,
2757: 'RS_'||category category
2758: FROM jtf_rs_resource_extns_vl
2759: WHERE source_id = l_cs_contacts_rsc_id AND
2760: category = l_cs_contacts_rsc_cat;
2761: l_cur_ib_resources cur_ib_resources%ROWTYPE;
2762:

Line 2773: FROM jtf_rs_resource_extns_vl

2769:
2770:
2771: CURSOR cur_support_site_id (p_rsc_id NUMBER, p_rsc_type VARCHAR2) IS
2772: SELECT support_site_id
2773: FROM jtf_rs_resource_extns_vl
2774: WHERE resource_id = p_rsc_id AND
2775: category = p_rsc_type;
2776:
2777:

Line 3798: FROM jtf_rs_resource_extns_vl

3794:
3795:
3796: CURSOR cur_support_site_id (p_rsc_id NUMBER, p_rsc_type VARCHAR2) IS
3797: SELECT support_site_id
3798: FROM jtf_rs_resource_extns_vl
3799: WHERE resource_id = p_rsc_id AND
3800: category = p_rsc_type;
3801:
3802:

Line 5246: FROM jtf_rs_resource_extns_vl

5242:
5243:
5244: CURSOR cur_res_location(p_rid NUMBER, p_rtype VARCHAR2) IS
5245: SELECT DECODE(source_postal_code, NULL, '00000', source_postal_code)
5246: FROM jtf_rs_resource_extns_vl
5247: WHERE resource_id = p_rid AND
5248: 'RS_'||category = p_rtype;
5249:
5250:

Line 5264: FROM jtf_rs_resource_extns_vl

5260:
5261:
5262: CURSOR cur_support_site_id (p_rsc_id NUMBER, p_rsc_type VARCHAR2) IS
5263: SELECT support_site_id
5264: FROM jtf_rs_resource_extns_vl
5265: WHERE resource_id = p_rsc_id AND
5266: category = p_rsc_type;
5267:
5268:

Line 9662: FROM jtf_rs_resource_extns_vl

9658:
9659:
9660: CURSOR cur_support_site_id (p_rsc_id NUMBER, p_rsc_type VARCHAR2) IS
9661: SELECT support_site_id
9662: FROM jtf_rs_resource_extns_vl
9663: WHERE resource_id = p_rsc_id AND
9664: category = p_rsc_type;
9665:
9666:

Line 10796: FROM jtf_rs_resource_extns_vl

10792:
10793:
10794: CURSOR cur_res_location(p_rid NUMBER, p_rtype VARCHAR2) IS
10795: SELECT DECODE(source_postal_code, NULL, '00000', source_postal_code)
10796: FROM jtf_rs_resource_extns_vl
10797: WHERE resource_id = p_rid AND
10798: 'RS_'||category = p_rtype;
10799:
10800: