[Home] [Help]
17:
18: select a.resource_list_member_id
19: into p_resource_list_member_id
20: from pa_resource_list_members a,
21: pa_resources b,
22: pa_resource_types c
23: where c.resource_type_code = 'UNCLASSIFIED'
24: and b.resource_type_id = c.resource_type_id
25: and a.resource_id = b.resource_id
56:
57: Select prlm.resource_list_member_id
58: into p_parent_rlmi
59: from pa_resource_list_members prlm,
60: pa_resources pr
61: where pr.resource_type_id = p_group_resource_type_id
62: and pr.name = p_name
63: and prlm.resource_id = pr.resource_id
64: and prlm.resource_list_id = p_resource_list_id
175: /* -------------------------------- Bug reference : 3631208 -------------------+
176: -- Cursor modified as above
177: select distinct a.resource_type_code resource_type_code
178: from pa_resource_types a,
179: pa_resources b,
180: pa_resource_list_members c
181: where c.resource_list_id = x_resource_list_id
182: and b.resource_id = c.resource_id
183: and a.resource_type_id = b.resource_type_id
198: a.resource_type_code,
199: b.resource_type_id,
200: c.parent_member_id
201: from pa_resource_types a,
202: pa_resources b,
203: pa_resource_list_members c
204: where c.resource_list_id = x_resource_list_id
205: and b.resource_id = c.resource_id
206: and a.resource_type_id = b.resource_type_id
215: a.resource_type_code,
216: b.resource_type_id,
217: c.parent_member_id
218: from pa_resource_types a,
219: pa_resources b,
220: pa_resource_list_members c
221: where c.resource_list_id = x_resource_list_id
222: and b.resource_id = c.resource_id
223: and a.resource_type_id = b.resource_type_id
1191: /* ------------------------------------------------ Bug reference : 3631208 -----------+
1192: -- Cursor modified as above ..
1193: select distinct a.resource_type_code resource_type_code
1194: from pa_resource_types a,
1195: pa_resources b,
1196: pa_resource_list_members c
1197: where c.resource_list_id = x_resource_list_id
1198: and b.resource_id = c.resource_id
1199: and a.resource_type_id = b.resource_type_id
1214: a.resource_type_code,
1215: b.resource_type_id,
1216: c.parent_member_id
1217: from pa_resource_types a,
1218: pa_resources b,
1219: pa_resource_list_members c
1220: where c.resource_list_id = x_resource_list_id
1221: and b.resource_id = c.resource_id
1222: and a.resource_type_id = b.resource_type_id
1231: a.resource_type_code,
1232: b.resource_type_id,
1233: c.parent_member_id
1234: from pa_resource_types a,
1235: pa_resources b,
1236: pa_resource_list_members c
1237: where c.resource_list_id = x_resource_list_id
1238: and b.resource_id = c.resource_id
1239: and a.resource_type_id = b.resource_type_id
1390:
1391: select substrb(papf.full_name,1,100)
1392: into l_person_name
1393: from per_all_people_f papf,
1394: pa_resources pr,
1395: pa_resource_types prt
1396: where papf.person_id = x_person_id
1397: and papf.full_name = pr.name
1398: and prt.resource_type_id = pr.resource_type_id
2554: -- This procedure will return the resource and its attributes for the
2555: -- given project_id. It will return the group level resource for
2556: -- the resources for which no child resource exists and for the
2557: -- group if child exists then it will return only the childs
2558: -- please note that outer join is done for pa_resources to pa_resource_txn_attributes
2559: -- because some of the resource may not have attributes
2560:
2561: PROCEDURE get_mappable_resources
2562: ( x_project_id IN NUMBER,
2612: FROM
2613: pa_resource_lists rl,
2614: pa_resource_list_members rlm,
2615: pa_resource_txn_attributes rta,
2616: pa_resources r,
2617: pa_resource_types rt,
2618: pa_resource_list_assignments rla
2619: WHERE
2620: rlm.resource_list_id = rl.resource_list_id
2665: pa_resource_list_members rlmc,
2666: pa_resource_list_members rlmp,
2667: pa_resource_txn_attributes rtac,
2668: pa_resource_txn_attributes rtap,
2669: pa_resources rc,
2670: pa_resource_types rtc,
2671: pa_resource_list_assignments rla
2672: WHERE
2673: rlmc.resource_list_id = rl.resource_list_id