DBA Data[Home] [Help]

APPS.CSTPUPDT dependencies on CST_LISTS_TEMP

Line 51: CST_LISTS_TEMP CLT,

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

Line 63: CST_LISTS_TEMP CLT,

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

Line 75: CST_LISTS_TEMP CLT1,

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

Line 76: CST_LISTS_TEMP CLT2,

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