DBA Data[Home] [Help]

APPS.OKL_CFL_PVT dependencies on OKL_CASH_FLOWS_V

Line 475: FROM Okl_Cash_Flows_V

471: l_dummy_var VARCHAR2(1) := '?' ;
472:
473: CURSOR okl_cflv_cafv_fk_csr (p_id IN NUMBER) IS
474: SELECT 'x'
475: FROM Okl_Cash_Flows_V
476: WHERE okl_cash_flows_v.id = p_id;
477: BEGIN
478:
479: IF (p_cflv_rec.caf_id = OKL_API.G_MISS_NUM OR p_cflv_rec.caf_id IS NULL)

Line 476: WHERE okl_cash_flows_v.id = p_id;

472:
473: CURSOR okl_cflv_cafv_fk_csr (p_id IN NUMBER) IS
474: SELECT 'x'
475: FROM Okl_Cash_Flows_V
476: WHERE okl_cash_flows_v.id = p_id;
477: BEGIN
478:
479: IF (p_cflv_rec.caf_id = OKL_API.G_MISS_NUM OR p_cflv_rec.caf_id IS NULL)
480: THEN

Line 497: 'OKL_CASH_FLOWS_V');

493: 'caf_id',
494: g_child_table_token ,
495: 'OKL_CASH_FLOW_LELELS_V',
496: g_parent_table_token ,
497: 'OKL_CASH_FLOWS_V');
498: l_return_status := OKC_API.G_RET_STS_ERROR;
499:
500: END IF;
501: END IF;

Line 922: FROM Okl_Cash_Flows_V

918: ) RETURN VARCHAR2 IS
919: item_not_found_error EXCEPTION;
920: CURSOR okl_cflv_cafv_fk_csr (p_id IN NUMBER) IS
921: SELECT 'x'
922: FROM Okl_Cash_Flows_V
923: WHERE okl_cash_flows_v.id = p_id;
924: l_okl_cflv_cafv_fk okl_cflv_cafv_fk_csr%ROWTYPE;
925:
926: CURSOR okl_cflv_fqy_fk_csr (p_lookup_code IN VARCHAR2) IS

Line 923: WHERE okl_cash_flows_v.id = p_id;

919: item_not_found_error EXCEPTION;
920: CURSOR okl_cflv_cafv_fk_csr (p_id IN NUMBER) IS
921: SELECT 'x'
922: FROM Okl_Cash_Flows_V
923: WHERE okl_cash_flows_v.id = p_id;
924: l_okl_cflv_cafv_fk okl_cflv_cafv_fk_csr%ROWTYPE;
925:
926: CURSOR okl_cflv_fqy_fk_csr (p_lookup_code IN VARCHAR2) IS
927: SELECT 'x'