APPS.OKL_SUB_PVT dependencies on OKL_FORMULAE_B

Line 1159: FROM OKL_FORMULAE_B fmlb

1155: p_formula_id IN NUMBER) IS
1156:
1157: CURSOR fmlb_csr (p_formula_id IN number) IS
1158: SELECT 'Y'
1159: FROM OKL_FORMULAE_B fmlb
1160: WHERE fmlb.id = p_formula_id
1161: And sysdate between nvl(fmlb.start_date,sysdate) and nvl(fmlb.end_date,sysdate);
1162: l_exists varchar2(1) default 'N';
1163:

Line 1319: FROM OKL_FORMULAE_B fmlb

1315: p_refund_formula_id IN NUMBER) IS
1316:
1317: CURSOR fmlb_csr (p_formula_id IN number) IS
1318: SELECT 'Y'
1319: FROM OKL_FORMULAE_B fmlb
1320: WHERE fmlb.id = p_formula_id
1321: And sysdate between nvl(fmlb.start_date,sysdate) and nvl(fmlb.end_date,sysdate);
1322: l_exists varchar2(1) default 'N';
1323:

Line 2384: FROM Okl_Formulae_B

2380:
2381: CURSOR okl_subsidies_v_fk2_csr (p_id IN NUMBER,
2382: p_org_id IN NUMBER) IS
2383: SELECT 'x'
2384: FROM Okl_Formulae_B
2385: WHERE okl_formulae_b.id = p_id
2386: AND okl_formulae_b.org_id = p_org_id;
2387: l_okl_subsidies_v_fk2 okl_subsidies_v_fk2_csr%ROWTYPE;
2388:

Line 2385: WHERE okl_formulae_b.id = p_id

2381: CURSOR okl_subsidies_v_fk2_csr (p_id IN NUMBER,
2382: p_org_id IN NUMBER) IS
2383: SELECT 'x'
2384: FROM Okl_Formulae_B
2385: WHERE okl_formulae_b.id = p_id
2386: AND okl_formulae_b.org_id = p_org_id;
2387: l_okl_subsidies_v_fk2 okl_subsidies_v_fk2_csr%ROWTYPE;
2388:
2389: CURSOR okl_subsidies_v_fk6_csr (p_id IN NUMBER) IS

Line 2386: AND okl_formulae_b.org_id = p_org_id;

2382: p_org_id IN NUMBER) IS
2383: SELECT 'x'
2384: FROM Okl_Formulae_B
2385: WHERE okl_formulae_b.id = p_id
2386: AND okl_formulae_b.org_id = p_org_id;
2387: l_okl_subsidies_v_fk2 okl_subsidies_v_fk2_csr%ROWTYPE;
2388:
2389: CURSOR okl_subsidies_v_fk6_csr (p_id IN NUMBER) IS
2390: SELECT 'x'