eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SSC_WF dependencies on OKL_INS_POLICIES_B

Line 2509: from OKL_INS_POLICIES_B

2505: WHERE id = p_chr_id;
2506:
2507: CURSOR policy_info_cur(p_pol_id IN NUMBER) IS
2508: SELECT policy_number, iss_code, cancellation_date, khr_id
2509: from OKL_INS_POLICIES_B
2510: WHERE id = p_pol_id;
2511:
2512: CURSOR requestor_info_cur(p_requestor_id IN NUMBER) IS
2513: SELECT user_name from fnd_user

Line 2652: FROM OKL_INS_POLICIES_B

2648: l_yn VARCHAR2(1);
2649:
2650: CURSOR policy_info_cur(p_polid IN NUMBER) IS
2651: SELECT iss_code
2652: FROM OKL_INS_POLICIES_B
2653: WHERE id = p_polid;
2654:
2655: CURSOR wf_seq IS
2656: SELECT OKLSSC_WFITEMKEY_S.nextval

Line 2774: FROM OKL_INS_POLICIES_B IPYB, OKL_INS_CLAIMS_B ICMB

2770:
2771:
2772: CURSOR claim_info(claim_id VARCHAR2) IS
2773: SELECT IPYB.POLICY_NUMBER , ICMB.CLAIM_NUMBER
2774: FROM OKL_INS_POLICIES_B IPYB, OKL_INS_CLAIMS_B ICMB
2775: WHERE IPYB.ID = ICMB.IPY_ID
2776: AND ICMB.ID = claim_id;
2777:
2778: