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 1089: FROM okl_trx_types_tl

1085:
1086:
1087: CURSOR okl_trx_types(cp_name VARCHAR2,cp_language VARCHAR2) IS
1088: SELECT id
1089: FROM okl_trx_types_tl
1090: WHERE name = cp_name
1091: AND language = cp_language;
1092:
1093:

Line 1613: FROM okl_trx_types_tl

1609:
1610:
1611: CURSOR c_trx_type (cp_name VARCHAR2, cp_language VARCHAR2) IS
1612: SELECT id
1613: FROM okl_trx_types_tl
1614: WHERE name = cp_name
1615: AND language = cp_language;
1616:
1617: l_trx_type_ID NUMBER ;

Line 2928: FROM okl_trx_types_tl

2924: AND STR.KLE_ID = p_ipyv_rec.KLE_ID;
2925:
2926: CURSOR c_trx_type (cp_name VARCHAR2, cp_language VARCHAR2) IS
2927: SELECT id
2928: FROM okl_trx_types_tl
2929: WHERE name = cp_name
2930: AND language = cp_language;
2931: CURSOR c_ins_opt_premium (p_covered_amount IN NUMBER) IS
2932: SELECT ((INSURER_RATE * p_covered_amount )/100 )

Line 3270: FROM okl_trx_types_tl

3266: --AND STM.PURPOSE_CODE IS NULL;
3267: AND (STM.PURPOSE_CODE IS NULL OR STM.PURPOSE_CODE='REPORT');
3268: CURSOR okl_trx_types (cp_name VARCHAR2, cp_language VARCHAR2) IS
3269: SELECT id
3270: FROM okl_trx_types_tl
3271: WHERE name = cp_name
3272: AND language = cp_language;
3273:
3274: /* Start Bug#5955320

Line 3901: FROM okl_trx_types_tl

3897: AND STEM.ACCRUED_YN = 'Y'
3898: AND STM.PURPOSE_CODE IS NULL;
3899: CURSOR okl_trx_types (cp_name VARCHAR2, cp_language VARCHAR2) IS
3900: SELECT id
3901: FROM okl_trx_types_tl
3902: WHERE name = cp_name
3903: AND language = cp_language;
3904:
3905: /* Start Bug#5955320

Line 4525: FROM okl_trx_types_tl

4521: p_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;
4522: --Get Transaction type Id
4523: CURSOR l_try_id_cur IS
4524: SELECT ID
4525: FROM okl_trx_types_tl
4526: WHERE NAME = 'Billing' AND LANGUAGE = 'US';
4527: BEGIN
4528: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4529: l_return_status := OKL_API.START_ACTIVITY(

Line 4741: FROM okl_trx_types_tl

4737:
4738: -- get transaction type ID
4739: CURSOR okl_trx_types(cp_name VARCHAR2,cp_language VARCHAR2) IS
4740: SELECT id
4741: FROM okl_trx_types_tl
4742: WHERE NAME = cp_name
4743: AND LANGUAGE = cp_language;
4744:
4745: -----------------------------------------

Line 5978: FROM okl_trx_types_tl

5974:
5975:
5976: CURSOR okl_trx_types (cp_name VARCHAR2, cp_language VARCHAR2) IS
5977: SELECT id
5978: FROM okl_trx_types_tl
5979: WHERE name = cp_name
5980: AND language = cp_language;
5981:
5982:

Line 7019: FROM okl_trx_types_tl

7015:
7016:
7017: CURSOR okl_trx_types(cp_name VARCHAR2,cp_language VARCHAR2) IS
7018: SELECT id
7019: FROM okl_trx_types_tl
7020: WHERE name = cp_name
7021: AND language = cp_language;
7022:
7023: