DBA Data[Home] [Help]

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 86: from jtf_rs_resource_extns

82:
83:
84: CURSOR csr_person_user (p_source_id IN NUMBER )IS
85: select user_id
86: from jtf_rs_resource_extns
87: where source_id = p_source_id
88: and sysdate >= start_date_active
89: and sysdate <= nvl(end_date_active, sysdate)
90: and rownum < 2;

Line 1463: , jtf_rs_resource_extns jre

1459: AND oaa.approval_access_flag = 'Y'
1460: UNION
1461: SELECT jre.user_name
1462: FROM dpp_approval_access oaa
1463: , jtf_rs_resource_extns jre
1464: WHERE oaa.object_type = p_object_type
1465: AND oaa.object_id = p_object_id
1466: AND oaa.approver_type = 'PERSON'
1467: AND oaa.approver_id = jre.source_id