DBA Data[Home] [Help]

APPS.JL_ZZ_GLOBE_VAL_PKG dependencies on RA_CUSTOMER_TRX

Line 70: FROM ra_customer_trx rc, fnd_lookups fl

66: IF l_category IS NOT NULL THEN
67:
68: SELECT rc.global_attribute20, fl.meaning
69: INTO p_copy_status_code, p_copy_status_meaning
70: FROM ra_customer_trx rc, fnd_lookups fl
71: WHERE rc.customer_trx_id = p_customer_trx_id
72: AND rc.global_attribute_category = l_category
73: AND rc.global_attribute20 = fl.lookup_code
74: AND fl.lookup_type = 'JLZZ_COPY_STATUS';

Line 105: FROM ra_customer_trx

101: IF p_customer_trx_id IS NOT NULL THEN
102:
103: SELECT cust_trx_type_id
104: INTO p_cust_trx_type_id
105: FROM ra_customer_trx
106: WHERE customer_trx_id = p_customer_trx_id;
107:
108: ELSE
109: