690:
691: CURSOR manager_cur
692: IS
693: SELECT b.user_id, b.user_name
694: FROM JTF_RS_RESOURCE_EXTNS a ,
695: JTF_RS_RESOURCE_EXTNS b
696: WHERE b.source_id = a.source_mgr_id
697: AND a.user_id = p_user_id ;
698:
691: CURSOR manager_cur
692: IS
693: SELECT b.user_id, b.user_name
694: FROM JTF_RS_RESOURCE_EXTNS a ,
695: JTF_RS_RESOURCE_EXTNS b
696: WHERE b.source_id = a.source_mgr_id
697: AND a.user_id = p_user_id ;
698:
699: CURSOR owner_cur
698:
699: CURSOR owner_cur
700: IS
701: SELECT user_name
702: FROM JTF_RS_RESOURCE_EXTNS
703: WHERE user_id = p_user_id ;
704:
705: BEGIN
706: -- IF PG_DEBUG < 10 THEN