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 2595: from OKL_INS_POLICIES_B

2591: WHERE id = p_chr_id;
2592:
2593: CURSOR policy_info_cur(p_pol_id IN NUMBER) IS
2594: SELECT policy_number, iss_code, cancellation_date, khr_id
2595: from OKL_INS_POLICIES_B
2596: WHERE id = p_pol_id;
2597:
2598: CURSOR requestor_info_cur(p_requestor_id IN NUMBER) IS
2599: SELECT user_name from fnd_user

Line 2738: FROM OKL_INS_POLICIES_B

2734: l_yn VARCHAR2(1);
2735:
2736: CURSOR policy_info_cur(p_polid IN NUMBER) IS
2737: SELECT iss_code
2738: FROM OKL_INS_POLICIES_B
2739: WHERE id = p_polid;
2740:
2741: CURSOR wf_seq IS
2742: SELECT OKLSSC_WFITEMKEY_S.nextval

Line 2860: FROM OKL_INS_POLICIES_B IPYB, OKL_INS_CLAIMS_B ICMB

2856:
2857:
2858: CURSOR claim_info(claim_id VARCHAR2) IS
2859: SELECT IPYB.POLICY_NUMBER , ICMB.CLAIM_NUMBER
2860: FROM OKL_INS_POLICIES_B IPYB, OKL_INS_CLAIMS_B ICMB
2861: WHERE IPYB.ID = ICMB.IPY_ID
2862: AND ICMB.ID = claim_id;
2863:
2864: