APPS.JA_TH_AR_TAX_INVOICE dependencies on RA_CUST_TRX_TYPES

Line 140: FROM ra_cust_trx_types

136: RETURN NUMBER IS
137:
138: CURSOR last_issued_date IS
139: SELECT global_attribute2
140: FROM ra_cust_trx_types
141: WHERE cust_trx_type_id = p_cust_trx_type_id
142: FOR UPDATE OF global_attribute2 NOWAIT;
143:
144: cannot_lock EXCEPTION;

Line 157: UPDATE ra_cust_trx_types

153: OPEN last_issued_date;
154:
155: FETCH last_issued_date INTO dummy;
156:
157: UPDATE ra_cust_trx_types
158: SET global_attribute2 = fnd_date.date_to_canonical(p_trx_date)
159: WHERE CURRENT OF last_issued_date;
160:
161: CLOSE last_issued_date;

Line 171: FROM ra_cust_trx_types

167:
168: BEGIN
169: SELECT name
170: INTO trx_type_name
171: FROM ra_cust_trx_types
172: WHERE cust_trx_type_id = p_cust_trx_type_id;
173: EXCEPTION
174: WHEN others THEN
175: raise;