APPS.JTF_ESCWFACTIVITY_PVT dependencies on JTF_RS_EMP_DTLS_VL

Line 234: CURSOR c_query_emp (b_resource_id JTF_RS_EMP_DTLS_VL.RESOURCE_ID%TYPE)

230: IS
231: -------------------------------------------------------------------------
232: -- Cursor for Resources query
233: -------------------------------------------------------------------------
234: CURSOR c_query_emp (b_resource_id JTF_RS_EMP_DTLS_VL.RESOURCE_ID%TYPE)
235: IS SELECT source_id
236: FROM JTF_RS_RESOURCE_EXTNS
237: WHERE resource_id = b_resource_id;
238:

Line 461: CURSOR c_query_resource(b_source_id JTF_RS_EMP_DTLS_VL.SOURCE_ID%TYPE)

457:
458: -------------------------------------------------------------------------
459: -- Cursor for Resources query
460: -------------------------------------------------------------------------
461: CURSOR c_query_resource(b_source_id JTF_RS_EMP_DTLS_VL.SOURCE_ID%TYPE)
462: IS SELECT resource_id
463: FROM JTF_RS_EMP_DTLS_VL
464: WHERE source_id = b_source_id;
465:

Line 463: FROM JTF_RS_EMP_DTLS_VL

459: -- Cursor for Resources query
460: -------------------------------------------------------------------------
461: CURSOR c_query_resource(b_source_id JTF_RS_EMP_DTLS_VL.SOURCE_ID%TYPE)
462: IS SELECT resource_id
463: FROM JTF_RS_EMP_DTLS_VL
464: WHERE source_id = b_source_id;
465:
466: -------------------------------------------------------------------------
467: -- Territory record and table definitions (returned from

Line 674: FROM JTF_RS_EMP_DTLS_VL

670: -- Cursor for HR Manager query
671: -------------------------------------------------------------------------
672: CURSOR c_query_hr_manager(b_owner_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
673: IS SELECT manager_person_id
674: FROM JTF_RS_EMP_DTLS_VL
675: WHERE resource_id = b_owner_id;
676:
677: -------------------------------------------------------------------------
678: -- Cursor for Resources query

Line 680: CURSOR c_query_resource(b_source_id JTF_RS_EMP_DTLS_VL.SOURCE_ID%TYPE)

676:
677: -------------------------------------------------------------------------
678: -- Cursor for Resources query
679: -------------------------------------------------------------------------
680: CURSOR c_query_resource(b_source_id JTF_RS_EMP_DTLS_VL.SOURCE_ID%TYPE)
681: IS SELECT resource_id
682: FROM JTF_RS_EMP_DTLS_VL
683: WHERE source_id = b_source_id;
684:

Line 682: FROM JTF_RS_EMP_DTLS_VL

678: -- Cursor for Resources query
679: -------------------------------------------------------------------------
680: CURSOR c_query_resource(b_source_id JTF_RS_EMP_DTLS_VL.SOURCE_ID%TYPE)
681: IS SELECT resource_id
682: FROM JTF_RS_EMP_DTLS_VL
683: WHERE source_id = b_source_id;
684:
685: -------------------------------------------------------------------------
686: -- Cursor for Resource Group query