DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_RETURN_WF dependencies on OKL_PRTFL_CNTRCTS_B

Line 2032: FROM OKL_PRTFL_CNTRCTS_B PFC

2028:
2029: CURSOR okl_pfc_csr(c_id NUMBER)
2030: IS
2031: SELECT count(1)
2032: FROM OKL_PRTFL_CNTRCTS_B PFC
2033: WHERE PFC.KHR_ID = c_id;
2034:
2035: l_id NUMBER;
2036: l_count NUMBER;

Line 2100: FROM OKL_PRTFL_CNTRCTS_B PFC,

2096: FND.MEANING STRATEGY,
2097: PFCL.BUDGET_AMOUNT BUDGET,
2098: PFCL.DATE_STRATEGY_EXECUTION_DUE EXECUTION_DATE,
2099: PFC.LAST_UPDATED_BY LAST_UPDATED_BY
2100: FROM OKL_PRTFL_CNTRCTS_B PFC,
2101: OKL_PRTFL_LINES_V PFCL,
2102: OKC_K_HEADERS_V AD,
2103: FND_LOOKUPS FND,
2104: JTF_RS_TEAMS_VL T

Line 2232: OKL_PRTFL_CNTRCTS_B PFC

2228: CURSOR okl_pfc_csr(c_id NUMBER)
2229: IS
2230: SELECT PFCL.ID ID
2231: FROM OKL_PRTFL_LINES_B PFCL,
2232: OKL_PRTFL_CNTRCTS_B PFC
2233: WHERE PFC.KHR_ID = c_id
2234: AND PFC.ID = PFCL.PFC_ID;
2235:
2236: l_pfc_rec okl_pfc_csr%rowtype;

Line 2336: FROM OKL_PRTFL_CNTRCTS_B PFC,

2332: FND.MEANING STRATEGY,
2333: PFCL.BUDGET_AMOUNT BUDGET,
2334: PFCL.DATE_STRATEGY_EXECUTION_DUE EXECUTION_DATE,
2335: PFC.LAST_UPDATED_BY LAST_UPDATED_BY
2336: FROM OKL_PRTFL_CNTRCTS_B PFC,
2337: OKL_PRTFL_LINES_V PFCL,
2338: OKC_K_HEADERS_V AD,
2339: FND_LOOKUPS FND
2340: WHERE PFC.KHR_ID = c_id