APPS.OKL_LLA_UTIL_PVT dependencies on OKL_TXL_ITM_INSTS_V

Line 1030: FROM OKL_TXL_ITM_INSTS_V A

1026: CURSOR l_get_nonbooked_Astloc_csr IS
1027: SELECT B.DESCRIPTION
1028: FROM OKX_PARTY_SITE_USES_V B
1029: WHERE B.ID1 = (SELECT A.OBJECT_ID1_NEW
1030: FROM OKL_TXL_ITM_INSTS_V A
1031: WHERE A.KLE_ID = (SELECT A.ID
1032: FROM OKC_K_LINES_V A,
1033: OKC_LINE_STYLES_B B
1034: WHERE CLE_ID = (SELECT A.ID

Line 1146: FROM OKL_TXL_ITM_INSTS_V A

1142: AND psu.site_use_type = 'INSTALL_AT';
1143:
1144: CURSOR l_get_nonbooked_Astloc_csr IS
1145: SELECT A.OBJECT_ID1_NEW
1146: FROM OKL_TXL_ITM_INSTS_V A
1147: WHERE A.KLE_ID IN (SELECT A.ID
1148: FROM OKC_K_LINES_V A,
1149: OKC_LINE_STYLES_B B
1150: WHERE CLE_ID IN (SELECT A.ID