[Home] [Help]
738: -- This procedure will return the resource and its attributes for the
739: -- given project_id. It will return the group level resource for
740: -- the resources for which no child resource exists and for the
741: -- group if child exists then it will return only the childs
742: -- please note that outer join is done for pa_resources to pa_resource_txn_attributes
743: -- because some of the resource may not have attributes
744:
745: -- x_resource_list_id IN OUT resource_list_id_tabtype,
746: -- x_resource_list_assignment_id IN OUT resource_list_asgn_id_tabtype,
802: FROM
803: pa_resource_lists_all_bg rl,
804: pa_resource_list_members rlm,
805: pa_resource_txn_attributes rta,
806: pa_resources r,
807: pa_resource_types rt,
808: pa_resource_list_assignments rla
809: WHERE
810: rlm.resource_list_id = rl.resource_list_id
855: pa_resource_list_members rlmc,
856: pa_resource_list_members rlmp,
857: pa_resource_txn_attributes rtac,
858: pa_resource_txn_attributes rtap,
859: pa_resources rc,
860: pa_resource_types rtc,
861: pa_resource_list_assignments rla
862: WHERE
863: rlmc.resource_list_id = rl.resource_list_id