APPS.OKS_AUTO_REMINDER dependencies on JTF_RS_RESOURCE_EXTNS

Line 1609: FROM jtf_rs_resource_extns rsc,

1605: p_user_id NUMBER
1606: )
1607: IS
1608: SELECT rsc.resource_id resource_id
1609: FROM jtf_rs_resource_extns rsc,
1610: fnd_user u
1611: WHERE u.user_id = rsc.user_id
1612: AND u.user_id = p_user_id;
1613:

Line 2156: FROM jtf_rs_resource_extns

2152: l_duration_rec l_duration_csr%ROWTYPE;
2153:
2154: CURSOR l_user_email_csr (p_user_id NUMBER) IS
2155: SELECT source_email
2156: FROM jtf_rs_resource_extns
2157: WHERE user_id = p_user_id;
2158:
2159: l_api_name CONSTANT VARCHAR2 (30) := 'validate_autoreminder_k';
2160: l_item_key wf_items.item_key%TYPE := '';