47: CURSOR crc is
48: SELECT
49: CRC.RESOURCE_ID
50: FROM
51: CST_LISTS_TEMP CLT,
52: CST_RESOURCE_COSTS CRC
53: WHERE CRC.ORGANIZATION_ID = l_organization_id
54: AND CLT.LIST_ID = l_list_id
55: AND CLT.NUMBER_1 = CRC.RESOURCE_ID
59: CURSOR cdo is
60: SELECT
61: CDO.DEPARTMENT_ID
62: FROM
63: CST_LISTS_TEMP CLT,
64: CST_DEPARTMENT_OVERHEADS CDO
65: WHERE CDO.ORGANIZATION_ID = l_organization_id
66: AND CLT.LIST_ID = l_list_id
67: AND CLT.NUMBER_1 = CDO.OVERHEAD_ID
71: CURSOR cro is
72: SELECT
73: CRO.RESOURCE_ID
74: FROM
75: CST_LISTS_TEMP CLT1,
76: CST_LISTS_TEMP CLT2,
77: CST_RESOURCE_OVERHEADS CRO
78: WHERE CRO.ORGANIZATION_ID = l_organization_id
79: AND CLT1.LIST_ID = l_list_id
72: SELECT
73: CRO.RESOURCE_ID
74: FROM
75: CST_LISTS_TEMP CLT1,
76: CST_LISTS_TEMP CLT2,
77: CST_RESOURCE_OVERHEADS CRO
78: WHERE CRO.ORGANIZATION_ID = l_organization_id
79: AND CLT1.LIST_ID = l_list_id
80: AND CLT1.NUMBER_1 = CRO.RESOURCE_ID