DBA Data[Home] [Help]

APPS.CN_GET_COMM_PMT_PAID_GRP dependencies on JTF_RS_RESOURCE_EXTNS

Line 125: FROM jtf_rs_salesreps rs, jtf_rs_resource_extns rre,

121: IS
122: CURSOR get_org_and_srp_id(p_person_id jtf_rs_salesreps.person_id%TYPE)
123: IS
124: SELECT rs.org_id, rs.salesrep_id, hou.name operating_unit
125: FROM jtf_rs_salesreps rs, jtf_rs_resource_extns rre,
126: hr_operating_units hou
127: WHERE rre.source_id = p_person_id
128: AND rre.resource_id = rs.resource_id
129: AND rre.category = 'EMPLOYEE'