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
438: and resource_type = 'RS_RESOURCE';
439:
440: CURSOR c_person IS
441: select source_id
442: from jtf_rs_resource_extns
443: where resource_id = p_resource_id;
444:
445: l_person_id number;
446:
801: and resource_type = 'RS_RESOURCE';
802:
803: CURSOR c_person IS
804: select source_id
805: from jtf_rs_resource_extns
806: where resource_id = p_resource_id;
807:
808: CURSOR c_strategy_level IS
809: SELECT PREFERENCE_VALUE
1196: and resource_type = 'RS_RESOURCE';
1197:
1198: CURSOR c_person IS
1199: select source_id
1200: from jtf_rs_resource_extns
1201: where resource_id = p_resource_id;
1202:
1203: CURSOR c_strategy_level IS
1204: SELECT PREFERENCE_VALUE