APPS.BOM_CSTRSCCR_XMLP_PKG dependencies on CST_SC_LOW_LEVEL_CODES

Line 28: CST_SC_LOW_LEVEL_CODES CSLLC

24: SELECT
25: DISTINCT
26: CSLLC.ORGANIZATION_ID
27: FROM
28: CST_SC_LOW_LEVEL_CODES CSLLC
29: WHERE CSLLC.ROLLUP_ID = P_ROLLUP_ID
30: AND not exists (
31: SELECT
32: 'x'

Line 41: CST_SC_LOW_LEVEL_CODES CSLLC

37: SELECT
38: DISTINCT
39: CSLLC.ORGANIZATION_ID
40: FROM
41: CST_SC_LOW_LEVEL_CODES CSLLC
42: WHERE CSLLC.ROLLUP_ID = P_ROLLUP_ID
43: AND not exists (
44: SELECT
45: 'Alternate designator exists'

Line 823: CST_SC_LOW_LEVEL_CODES CSLLC,

819: SELECT
820: count(SOB.CURRENCY_CODE)
821: INTO P_NUM_CURRENCIES
822: FROM
823: CST_SC_LOW_LEVEL_CODES CSLLC,
824: HR_ORGANIZATION_INFORMATION HOI,
825: GL_LEDGERS SOB
826: WHERE CSLLC.ROLLUP_ID = P_ROLLUP_ID
827: AND HOI.ORGANIZATION_ID = CSLLC.ORGANIZATION_ID

Line 976: CST_SC_LOW_LEVEL_CODES

972: SELECT
973: DISTINCT
974: ORGANIZATION_ID
975: FROM
976: CST_SC_LOW_LEVEL_CODES
977: WHERE ROLLUP_ID = P_ROLLUP_ID;
978: BEGIN
979: FOR organizations IN NO_DEF_OVHD_ORGS LOOP
980: SELECT