APPS.OKL_LLA_UTIL_PVT dependencies on CSI_ITEM_INSTANCES

Line 976: CSI_ITEM_INSTANCES CSI,

972: SELECT SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,HL.ADDRESS1,HL.ADDRESS2,HL.ADDRESS3,
973: HL.ADDRESS4,HL.CITY,HL.COUNTY,HL.STATE,HL.PROVINCE,HL.POSTAL_CODE,NULL,HL.COUNTRY,
974: NULL, NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),1,80) DESCRIPTION
975: FROM HZ_LOCATIONS HL,
976: CSI_ITEM_INSTANCES CSI,
977: OKC_K_ITEMS CIM
978: WHERE CIM.CLE_ID = (SELECT A.ID
979: FROM OKC_K_LINES_V A,
980: OKC_LINE_STYLES_B B

Line 1003: CSI_ITEM_INSTANCES CSI,

999: HL.ADDRESS4,HL.CITY,HL.COUNTY,HL.STATE,HL.PROVINCE,HL.POSTAL_CODE,NULL,HL.COUNTRY,
1000: NULL, NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),1,80) DESCRIPTION
1001: FROM HZ_LOCATIONS HL,
1002: HZ_PARTY_SITES HPS,
1003: CSI_ITEM_INSTANCES CSI,
1004: OKC_K_ITEMS CIM
1005: WHERE CIM.CLE_ID = (SELECT A.ID
1006: FROM OKC_K_LINES_V A,
1007: OKC_LINE_STYLES_B B

Line 1088: CSI_ITEM_INSTANCES CSI,

1084:
1085: CURSOR l_get_booked_Astloc_csr IS
1086: SELECT psu.party_site_use_id
1087: FROM HZ_LOCATIONS HL,
1088: CSI_ITEM_INSTANCES CSI,
1089: OKC_K_ITEMS CIM,
1090: hz_party_site_uses psu,
1091: hz_party_sites hps
1092: WHERE CIM.CLE_ID in (SELECT A.ID

Line 1119: CSI_ITEM_INSTANCES CSI,

1115: SELECT psu.party_site_use_id
1116: FROM HZ_LOCATIONS HL,
1117: HZ_PARTY_SITES HPS,
1118: HZ_PARTY_SITE_USES PSU,
1119: CSI_ITEM_INSTANCES CSI,
1120: OKC_K_ITEMS CIM
1121: WHERE CIM.CLE_ID in (SELECT A.ID
1122: FROM OKC_K_LINES_V A,
1123: OKC_LINE_STYLES_B B