APPS.CSF_GANTT_DATA_PKG dependencies on CSF_DC_RESOURCES_V

Line 429: FROM csf_dc_resources_v

425:
426: Cursor c_terr
427: IS
428: SELECT territory_id
429: FROM csf_dc_resources_v
430: WHERE resource_id = p_resource_id
431: AND resource_type = p_resource_type;
432:
433: l_task_rec c_task%ROWTYPE;

Line 1568: FROM csf_dc_resources_v

1564:
1565: Cursor c_terr
1566: IS
1567: SELECT territory_id
1568: FROM csf_dc_resources_v
1569: WHERE resource_id = p_resource_id
1570: AND resource_type = p_resource_type;
1571:
1572: l_task_rec c_task%ROWTYPE;

Line 2497: FROM csf_dc_resources_v

2493:
2494: Cursor c_terr
2495: IS
2496: SELECT territory_id
2497: FROM csf_dc_resources_v
2498: WHERE resource_id = p_resource_id
2499: AND resource_type = p_resource_type;
2500:
2501:

Line 3224: FROM csf_dc_resources_v

3220:
3221: Cursor c_terr
3222: IS
3223: SELECT territory_id
3224: FROM csf_dc_resources_v
3225: WHERE resource_id = p_resource_id
3226: AND resource_type = p_resource_type;
3227:
3228:

Line 4188: FROM csf_dc_resources_v

4184:
4185: Cursor c_terr
4186: IS
4187: SELECT territory_id
4188: FROM csf_dc_resources_v
4189: WHERE resource_id = p_resource_id
4190: AND resource_type = p_resource_type;
4191:
4192:

Line 5096: FROM CSF_DC_RESOURCES_V TR,

5092: ||'-'
5093: ||TR.RESOURCE_TYPE RES_KEY,
5094: TERR.NAME,
5095: JRS.PHONE
5096: FROM CSF_DC_RESOURCES_V TR,
5097: JTF_TERR_ALL TERR,
5098: JTF_RS_RESOURCES_VL JRS
5099: WHERE TERR.TERR_ID = TR.TERRITORY_ID
5100: AND JRS.RESOURCE_ID = TR.RESOURCE_ID

Line 5124: FROM CSF_DC_RESOURCES_V RES,

5120: CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RES.RESOURCE_TYPE) RESOURCE_TYPE_NAME,
5121: RES.RESOURCE_ID || '-' || RES.RESOURCE_TYPE RES_KEY,
5122: TERR.NAME,
5123: JRS.PHONE
5124: FROM CSF_DC_RESOURCES_V RES,
5125: JTF_RS_ROLE_RELATIONS RR,
5126: JTF_RS_ROLES_B RL ,
5127: FND_LOOKUPS LKP,
5128: JTF_TERR_ALL TERR,