APPS.JA_ZZ_VALIDATE_INVOICE_GDF dependencies on RA_CUST_TRX_TYPES

Line 157: FROM ra_cust_trx_types ctt

153: SELECT
154: ctt.type inv_class
155: -- R12 Changes : , ctt.global_attribute1 gui_type
156: , NULL gui_type
157: FROM ra_cust_trx_types ctt
158: WHERE ctt.cust_trx_type_id = p_cust_trx_type_id;
159:
160: l_cust_trx_type_id NUMBER;
161: l_trx_type_info c_trx_type_info%ROWTYPE;

Line 1060: FROM ra_cust_trx_types

1056: RETURN NUMBER IS
1057:
1058: CURSOR last_issued_date IS
1059: SELECT global_attribute2
1060: FROM ra_cust_trx_types
1061: WHERE cust_trx_type_id = p_cust_trx_type_id
1062: FOR UPDATE OF global_attribute2 NOWAIT;
1063:
1064: cannot_lock EXCEPTION;

Line 1082: UPDATE ra_cust_trx_types

1078: OPEN last_issued_date;
1079:
1080: FETCH last_issued_date INTO dummy;
1081:
1082: UPDATE ra_cust_trx_types
1083: SET global_attribute2 = fnd_date.date_to_canonical(p_trx_date)
1084: WHERE CURRENT OF last_issued_date;
1085:
1086: CLOSE last_issued_date;

Line 1096: FROM ra_cust_trx_types

1092:
1093: BEGIN
1094: SELECT name
1095: INTO trx_type_name
1096: FROM ra_cust_trx_types
1097: WHERE cust_trx_type_id = p_cust_trx_type_id;
1098: EXCEPTION
1099: WHEN others THEN
1100: raise;