DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_RETURN_WF dependencies on OKL_PRTFL_CNTRCTS_B

Line 2089: FROM OKL_PRTFL_CNTRCTS_B PFC

2085:
2086: CURSOR okl_pfc_csr(c_id NUMBER)
2087: IS
2088: SELECT count(1)
2089: FROM OKL_PRTFL_CNTRCTS_B PFC
2090: WHERE PFC.KHR_ID = c_id;
2091:
2092: l_id NUMBER;
2093: l_count NUMBER;

Line 2157: FROM OKL_PRTFL_CNTRCTS_B PFC,

2153: FND.MEANING STRATEGY,
2154: PFCL.BUDGET_AMOUNT BUDGET,
2155: PFCL.DATE_STRATEGY_EXECUTION_DUE EXECUTION_DATE,
2156: PFC.LAST_UPDATED_BY LAST_UPDATED_BY
2157: FROM OKL_PRTFL_CNTRCTS_B PFC,
2158: OKL_PRTFL_LINES_V PFCL,
2159: OKC_K_HEADERS_V AD,
2160: FND_LOOKUPS FND,
2161: JTF_RS_TEAMS_VL T

Line 2289: OKL_PRTFL_CNTRCTS_B PFC

2285: CURSOR okl_pfc_csr(c_id NUMBER)
2286: IS
2287: SELECT PFCL.ID ID
2288: FROM OKL_PRTFL_LINES_B PFCL,
2289: OKL_PRTFL_CNTRCTS_B PFC
2290: WHERE PFC.KHR_ID = c_id
2291: AND PFC.ID = PFCL.PFC_ID;
2292:
2293: l_pfc_rec okl_pfc_csr%rowtype;

Line 2393: FROM OKL_PRTFL_CNTRCTS_B PFC,

2389: FND.MEANING STRATEGY,
2390: PFCL.BUDGET_AMOUNT BUDGET,
2391: PFCL.DATE_STRATEGY_EXECUTION_DUE EXECUTION_DATE,
2392: PFC.LAST_UPDATED_BY LAST_UPDATED_BY
2393: FROM OKL_PRTFL_CNTRCTS_B PFC,
2394: OKL_PRTFL_LINES_V PFCL,
2395: OKC_K_HEADERS_V AD,
2396: FND_LOOKUPS FND
2397: WHERE PFC.KHR_ID = c_id