DBA Data[Home] [Help]

APPS.CN_PSUM_PVT dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 384: FROM JTF_RS_RESOURCE_EXTNS_VL RE, JTF_RS_SALESREPS S

380: END IF;
381:
382: IF p_is_multiorg = 'Y' THEN
383: SELECT RE.RESOURCE_NAME INTO l_mgr_name
384: FROM JTF_RS_RESOURCE_EXTNS_VL RE, JTF_RS_SALESREPS S
385: WHERE RE.RESOURCE_ID = S.RESOURCE_ID AND TO_NUMBER(S.SALESREP_ID) > 0 AND
386: S.SALESREP_ID = p_mgr_id;
387: ELSE
388: SELECT name INTO l_mgr_name

Line 484: FROM JTF_RS_RESOURCE_EXTNS_VL RE, JTF_RS_SALESREPS S

480:
481:
482: IF p_is_multiorg = 'Y' THEN
483: SELECT RE.RESOURCE_NAME INTO l_mgr_name
484: FROM JTF_RS_RESOURCE_EXTNS_VL RE, JTF_RS_SALESREPS S
485: WHERE RE.RESOURCE_ID = S.RESOURCE_ID AND TO_NUMBER(S.SALESREP_ID) > 0 AND
486: S.SALESREP_ID = l_srp_group_rec.salesrep_id;
487: ELSE
488: SELECT name INTO l_mgr_name