APPS.DPP_APPROVAL_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 28: FROM jtf_rs_resource_extns jre

24: l_return_status BOOLEAN := FALSE;
25:
26: CURSOR csr_resource (p_resource_id IN NUMBER) IS
27: SELECT jre.resource_id
28: FROM jtf_rs_resource_extns jre
29: WHERE jre.resource_id = p_resource_id;
30:
31: BEGIN
32: OPEN csr_resource(p_resource_id);

Line 1627: , jtf_rs_resource_extns jre

1623: AND oaa.approval_access_flag = 'Y'
1624: UNION
1625: SELECT jre.user_name
1626: FROM dpp_approval_access oaa
1627: , jtf_rs_resource_extns jre
1628: WHERE oaa.object_type = p_object_type
1629: AND oaa.object_id = p_object_id
1630: AND oaa.approver_type = 'PERSON'
1631: AND oaa.approver_id = jre.source_id