APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_TRX_TYPES_TL

Line 473: FROM okl_trx_types_tl

469: /* 22-JAN-2007 ANSETHUR BUILD: R12 B DISBURSEMENT End Changes */
470:
471: CURSOR c_trx_type (cp_name VARCHAR2, cp_language VARCHAR2) IS
472: SELECT id
473: FROM okl_trx_types_tl
474: WHERE name = cp_name
475: AND language = cp_language;
476:
477: CURSOR c_tap_info (P_TAP_ID NUMBER) IS

Line 796: FROM okl_trx_types_tl

792: AND IPOV.PAY_SITE_FLAG = 'Y';
793:
794: CURSOR c_trx_type (cp_name VARCHAR2, cp_language VARCHAR2) IS
795: SELECT id
796: FROM okl_trx_types_tl
797: WHERE name = cp_name
798: AND language = cp_language;
799:
800: CURSOR c_tap_info (P_TAP_ID NUMBER) IS

Line 1108: FROM okl_trx_types_tl

1104:
1105:
1106: CURSOR okl_trx_types(cp_name VARCHAR2,cp_language VARCHAR2) IS
1107: SELECT id
1108: FROM okl_trx_types_tl
1109: WHERE name = cp_name
1110: AND language = cp_language;
1111:
1112:

Line 1632: FROM okl_trx_types_tl

1628:
1629:
1630: CURSOR c_trx_type (cp_name VARCHAR2, cp_language VARCHAR2) IS
1631: SELECT id
1632: FROM okl_trx_types_tl
1633: WHERE name = cp_name
1634: AND language = cp_language;
1635:
1636: l_trx_type_ID NUMBER ;

Line 2947: FROM okl_trx_types_tl

2943: AND STR.KLE_ID = p_ipyv_rec.KLE_ID;
2944:
2945: CURSOR c_trx_type (cp_name VARCHAR2, cp_language VARCHAR2) IS
2946: SELECT id
2947: FROM okl_trx_types_tl
2948: WHERE name = cp_name
2949: AND language = cp_language;
2950: CURSOR c_ins_opt_premium (p_covered_amount IN NUMBER) IS
2951: SELECT ((INSURER_RATE * p_covered_amount )/100 )

Line 3289: FROM okl_trx_types_tl

3285: --AND STM.PURPOSE_CODE IS NULL;
3286: AND (STM.PURPOSE_CODE IS NULL OR STM.PURPOSE_CODE='REPORT');
3287: CURSOR okl_trx_types (cp_name VARCHAR2, cp_language VARCHAR2) IS
3288: SELECT id
3289: FROM okl_trx_types_tl
3290: WHERE name = cp_name
3291: AND language = cp_language;
3292:
3293: /* Start Bug#5955320

Line 3926: FROM okl_trx_types_tl

3922: --AND STM.PURPOSE_CODE IS NULL;
3923: AND (STM.PURPOSE_CODE IS NULL OR STM.PURPOSE_CODE='REPORT'); --Bug# 9191475
3924: CURSOR okl_trx_types (cp_name VARCHAR2, cp_language VARCHAR2) IS
3925: SELECT id
3926: FROM okl_trx_types_tl
3927: WHERE name = cp_name
3928: AND language = cp_language;
3929:
3930: /* Start Bug#5955320

Line 4553: FROM okl_trx_types_tl

4549:
4550: --Get Transaction type Id
4551: CURSOR l_try_id_cur IS
4552: SELECT ID
4553: FROM okl_trx_types_tl
4554: WHERE NAME = 'Billing' AND LANGUAGE = 'US';
4555:
4556: -- Bug 8810880 Start
4557: lp_taiv_rec okl_tai_pvt.taiv_rec_type;

Line 4732: FROM okl_trx_types_tl

4728:
4729: -- get transaction type ID
4730: CURSOR okl_trx_types(cp_name VARCHAR2,cp_language VARCHAR2) IS
4731: SELECT id
4732: FROM okl_trx_types_tl
4733: WHERE NAME = cp_name
4734: AND LANGUAGE = cp_language;
4735:
4736: -----------------------------------------

Line 5971: FROM okl_trx_types_tl

5967:
5968:
5969: CURSOR okl_trx_types (cp_name VARCHAR2, cp_language VARCHAR2) IS
5970: SELECT id
5971: FROM okl_trx_types_tl
5972: WHERE name = cp_name
5973: AND language = cp_language;
5974:
5975:

Line 7012: FROM okl_trx_types_tl

7008:
7009:
7010: CURSOR okl_trx_types(cp_name VARCHAR2,cp_language VARCHAR2) IS
7011: SELECT id
7012: FROM okl_trx_types_tl
7013: WHERE name = cp_name
7014: AND language = cp_language;
7015:
7016: