APPS.OKL_LLA_UTIL_PVT dependencies on OKL_TXL_ITM_INSTS_V

Line 1029: FROM OKL_TXL_ITM_INSTS_V A

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

Line 1145: FROM OKL_TXL_ITM_INSTS_V A

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