DBA Data[Home] [Help]

APPS.CN_PAY_APPROVAL_FLOW_PVT dependencies on JTF_RS_GROUP_USAGES

Line 67: jtf_rs_group_usages u1, jtf_rs_rep_managers m1,

63: CURSOR c_mgr_csr(c_org_id NUMBER) IS
64: SELECT DISTINCT m1.parent_resource_id mgr_resource_id,
65: re1.source_email mgr_email,re1.user_id mgr_user_id
66: FROM cn_period_statuses pr,
67: jtf_rs_group_usages u1, jtf_rs_rep_managers m1,
68: jtf_rs_resource_extns re1
69: WHERE pr.period_id = p_period_id
70: AND pr.org_id = c_org_id
71: AND u1.usage = 'COMP_PAYMENT'