DBA Data[Home] [Help]

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_TRX_TYPES_V

Line 13221: FROM okl_trx_types_v

13217: AND language = 'US';
13218:
13219: CURSOR l_bookingtrxtypeid_csr IS
13220: SELECT id
13221: FROM okl_trx_types_v
13222: WHERE NAME = 'Booking';
13223:
13224: CURSOR l_tax_src_info_csr(cp_khr_id IN NUMBER, cp_trx_id IN NUMBER) IS
13225: SELECT org_id, application_id, entity_code, event_class_code

Line 19097: FROM okl_trx_types_v

19093:
19094: --13-Jun-11 sechawla 12653340 : added : begin
19095: CURSOR l_trxtypename_csr(cp_try_id IN NUMBER) IS
19096: SELECT name
19097: FROM okl_trx_types_v
19098: WHERE id = cp_try_id;
19099:
19100: CURSOR l_trxtypeid_csr(cp_trx_type_name IN VARCHAR2) IS
19101: SELECT id

Line 19102: FROM okl_trx_types_v

19098: WHERE id = cp_try_id;
19099:
19100: CURSOR l_trxtypeid_csr(cp_trx_type_name IN VARCHAR2) IS
19101: SELECT id
19102: FROM okl_trx_types_v
19103: WHERE name = cp_trx_type_name;
19104:
19105: l_trx_type_name VARCHAR2(150);
19106: l_trx_type_id NUMBER;