47:
48:
49: CURSOR c_person IS
50: select source_id
51: from jtf_rs_resource_extns
52: where resource_id = p_resource_id;
53:
54: CURSOR c_del_new_nodes is
55: select lookup_code, meaning from fnd_lookup_values
418: and resource_type = 'RS_RESOURCE';
419:
420: CURSOR c_person IS
421: select source_id
422: from jtf_rs_resource_extns
423: where resource_id = p_resource_id;
424:
425: l_person_id number;
426:
736: and resource_type = 'RS_RESOURCE';
737:
738: CURSOR c_person IS
739: select source_id
740: from jtf_rs_resource_extns
741: where resource_id = p_resource_id;
742:
743: CURSOR c_strategy_level IS
744: SELECT PREFERENCE_VALUE
1086: and resource_type = 'RS_RESOURCE';
1087:
1088: CURSOR c_person IS
1089: select source_id
1090: from jtf_rs_resource_extns
1091: where resource_id = p_resource_id;
1092:
1093: CURSOR c_strategy_level IS
1094: SELECT PREFERENCE_VALUE