APPS.JTF_ASSIGN_PUB dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 2147: FROM jtf_rs_resource_extns_vl

2143:
2144: CURSOR cur_ib_resources IS
2145: SELECT resource_id,
2146: 'RS_'||category category
2147: FROM jtf_rs_resource_extns_vl
2148: WHERE source_id = l_cs_contacts_rsc_id
2149: AND category = l_cs_contacts_rsc_cat;
2150:
2151: l_cur_ib_resources cur_ib_resources%ROWTYPE;

Line 2170: FROM jtf_rs_resource_extns_vl

2166:
2167: CURSOR cur_ib_supp_resources IS
2168: SELECT resource_id,
2169: 'RS_'||category category
2170: FROM jtf_rs_resource_extns_vl
2171: WHERE source_id = l_cs_contacts_rsc_id
2172: AND category = 'SUPPLIER_CONTACT';
2173:
2174:

Line 2721: FROM jtf_rs_resource_extns_vl

2717:
2718: CURSOR cur_ib_resources IS
2719: SELECT resource_id,
2720: 'RS_'||category category
2721: FROM jtf_rs_resource_extns_vl
2722: WHERE source_id = l_cs_contacts_rsc_id AND
2723: category = l_cs_contacts_rsc_cat;
2724: l_cur_ib_resources cur_ib_resources%ROWTYPE;
2725:

Line 2736: FROM jtf_rs_resource_extns_vl

2732:
2733:
2734: CURSOR cur_support_site_id (p_rsc_id NUMBER, p_rsc_type VARCHAR2) IS
2735: SELECT support_site_id
2736: FROM jtf_rs_resource_extns_vl
2737: WHERE resource_id = p_rsc_id AND
2738: category = p_rsc_type;
2739:
2740:

Line 3761: FROM jtf_rs_resource_extns_vl

3757:
3758:
3759: CURSOR cur_support_site_id (p_rsc_id NUMBER, p_rsc_type VARCHAR2) IS
3760: SELECT support_site_id
3761: FROM jtf_rs_resource_extns_vl
3762: WHERE resource_id = p_rsc_id AND
3763: category = p_rsc_type;
3764:
3765:

Line 5182: FROM jtf_rs_resource_extns_vl

5178:
5179:
5180: CURSOR cur_res_location(p_rid NUMBER, p_rtype VARCHAR2) IS
5181: SELECT DECODE(source_postal_code, NULL, '00000', source_postal_code)
5182: FROM jtf_rs_resource_extns_vl
5183: WHERE resource_id = p_rid AND
5184: 'RS_'||category = p_rtype;
5185:
5186:

Line 5200: FROM jtf_rs_resource_extns_vl

5196:
5197:
5198: CURSOR cur_support_site_id (p_rsc_id NUMBER, p_rsc_type VARCHAR2) IS
5199: SELECT support_site_id
5200: FROM jtf_rs_resource_extns_vl
5201: WHERE resource_id = p_rsc_id AND
5202: category = p_rsc_type;
5203:
5204:

Line 9598: FROM jtf_rs_resource_extns_vl

9594:
9595:
9596: CURSOR cur_support_site_id (p_rsc_id NUMBER, p_rsc_type VARCHAR2) IS
9597: SELECT support_site_id
9598: FROM jtf_rs_resource_extns_vl
9599: WHERE resource_id = p_rsc_id AND
9600: category = p_rsc_type;
9601:
9602:

Line 10732: FROM jtf_rs_resource_extns_vl

10728:
10729:
10730: CURSOR cur_res_location(p_rid NUMBER, p_rtype VARCHAR2) IS
10731: SELECT DECODE(source_postal_code, NULL, '00000', source_postal_code)
10732: FROM jtf_rs_resource_extns_vl
10733: WHERE resource_id = p_rid AND
10734: 'RS_'||category = p_rtype;
10735:
10736: