APPS.OKS_AUTO_REMINDER dependencies on JTF_RS_RESOURCE_EXTNS

Line 1686: FROM jtf_rs_resource_extns rsc,

1682: p_user_id NUMBER
1683: )
1684: IS
1685: SELECT rsc.resource_id resource_id
1686: FROM jtf_rs_resource_extns rsc,
1687: fnd_user u
1688: WHERE u.user_id = rsc.user_id
1689: AND u.user_id = p_user_id;
1690:

Line 2233: FROM jtf_rs_resource_extns

2229: l_duration_rec l_duration_csr%ROWTYPE;
2230:
2231: CURSOR l_user_email_csr (p_user_id NUMBER) IS
2232: SELECT source_email
2233: FROM jtf_rs_resource_extns
2234: WHERE user_id = p_user_id;
2235:
2236: l_api_name CONSTANT VARCHAR2 (30) := 'validate_autoreminder_k';
2237: l_item_key wf_items.item_key%TYPE := '';