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_SO_CREDIT_APP_WF dependencies on OKL_LEASE_QUOTES_B

Line 1145: FROM OKL_LEASE_QUOTES_B

1141:
1142: --Bug 7140398 START
1143: CURSOR get_main_offer_csr(cp_lap_id NUMBER) IS
1144: SELECT ID
1145: FROM OKL_LEASE_QUOTES_B
1146: WHERE PARENT_OBJECT_ID = cp_lap_id
1147: AND PARENT_OBJECT_CODE = 'LEASEAPP'
1148: AND PRIMARY_QUOTE = 'Y';
1149:

Line 1150: l_lsq_id okl_lease_quotes_b.id%type;

1146: WHERE PARENT_OBJECT_ID = cp_lap_id
1147: AND PARENT_OBJECT_CODE = 'LEASEAPP'
1148: AND PRIMARY_QUOTE = 'Y';
1149:
1150: l_lsq_id okl_lease_quotes_b.id%type;
1151:
1152: CURSOR is_counter_offer_exist(cp_lap_id NUMBER) IS
1153: SELECT DISTINCT STATUS
1154: FROM okl_lease_quotes_b

Line 1154: FROM okl_lease_quotes_b

1150: l_lsq_id okl_lease_quotes_b.id%type;
1151:
1152: CURSOR is_counter_offer_exist(cp_lap_id NUMBER) IS
1153: SELECT DISTINCT STATUS
1154: FROM okl_lease_quotes_b
1155: WHERE status = 'CR-RECOMMENDATION'
1156: AND parent_object_code = 'LEASEAPP'
1157: AND PARENT_OBJECT_ID = cp_lap_id;
1158:

Line 1160: l_status okl_lease_quotes_b.status%type;

1156: AND parent_object_code = 'LEASEAPP'
1157: AND PARENT_OBJECT_ID = cp_lap_id;
1158:
1159: l_counter_offer_exist VARCHAR2(1) := 'N';
1160: l_status okl_lease_quotes_b.status%type;
1161: l_lsqv_rec lsqv_rec_type;
1162: x_lsqv_rec lsqv_rec_type;
1163: --Bug 7140398 END
1164: