APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on HZ_CUST_SITE_USES

Line 106: FROM HZ_CUST_SITE_USES ---FROM ra_site_uses --Replaced by the R12 table

102: -- Bug#7718063 Start
103: BEGIN
104: SELECT gl_id_rev, gl_id_rec
105: INTO X_site_rev_id, X_site_rec_id
106: FROM HZ_CUST_SITE_USES ---FROM ra_site_uses --Replaced by the R12 table
107: WHERE site_use_id = x_billto_site_use_id;
108:
109: EXCEPTION
110: WHEN NO_DATA_FOUND THEN NULL;

Line 153: ELSIF X_table_name = 'HZ_CUST_SITE_USES' THEN

149:
150: -- Bug#7718063 Start
151: --ELSIF X_table_name = 'RA_SITE_USES' THEN -- Replaced by the R12 table
152:
153: ELSIF X_table_name = 'HZ_CUST_SITE_USES' THEN
154: IF X_account_type = 'REV' THEN
155: X_gl_id := X_site_rev_id;
156: ELSIF X_account_type = 'REC' THEN
157: X_gl_id := X_site_rec_id;