[Home] [Help]
546: END get_resource_rank;
547:
548: -- This function returns the group resource_type_code for the given resoure list
549: -- In case of 'None' Group Resource type, the table pa_resource_lists_all_bg
550: -- will not join to the pa_resource_types table
551:
552: FUNCTION get_group_resource_type_code
553: (x_resource_list_id IN NUMBER)
554: RETURN VARCHAR2
564: rt.resource_type_code
565: INTO
566: x_group_resource_type_code
567: FROM
568: pa_resource_types rt,
569: pa_resource_lists_all_bg rl
570: WHERE
571: rl.resource_list_id = x_resource_list_id
572: and nvl(rl.migration_code,'-99') <> 'N'
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
811: AND rl.resource_list_id = NVL(x_res_list_id,rl.resource_list_id)
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
864: and nvl(rl.migration_code,'-99') <> 'N'