933: BEGIN
934: SELECT RLM.RESOURCE_LIST_MEMBER_ID INTO
935: l_resource_list_member_id
936: FROM
937: PA_RESOURCE_LIST_MEMBERS RLM, PA_RESOURCES R, PA_RESOURCE_TXN_ATTRIBUTES RT
938: WHERE
939: RLM.RESOURCE_LIST_ID = l_fcst_res_list AND
940: RLM.RESOURCE_ID = R.RESOURCE_ID AND
941: RT.RESOURCE_ID = R.RESOURCE_ID AND