APPS.FV_GTAS_TRX_REGISTER dependencies on HZ_CUST_ACCOUNTS_ALL

Line 3023: FROM hz_cust_accounts_all

3019: log(l_module,'12.2 or above, using dynamic select');
3020: l_select := ' SELECT cust_account_id,
3021: NVL(federal_entity_type,''N''),
3022: SUBSTR(trading_partner_agency_id,1,3)
3023: FROM hz_cust_accounts_all
3024: WHERE cust_account_id = :party_id';
3025: EXECUTE IMMEDIATE l_select
3026: INTO l_vendor_id,
3027: l_vendor_type,

Line 3048: FROM hz_cust_accounts_all c

3044: 'ATTRIBUTE14', C.ATTRIBUTE14, 'ATTRIBUTE15', C.ATTRIBUTE15) eliminations_id
3045: INTO l_vendor_id,
3046: l_vendor_type,
3047: l_eliminations_id
3048: FROM hz_cust_accounts_all c
3049: WHERE c.cust_account_id = to_number(l_reference_7);
3050: END IF;
3051: ELSE
3052: log(l_module,' REFERENCE_7 I.E. '|| 'customer_id is NULL');

Line 3103: l_cust_class_code hz_cust_accounts_all.customer_class_code%TYPE;

3099: --SELECT dept_id||main_account
3100: --FROM fv_be_trx_dtls
3101: --WHERE transaction_id = to_number(l_reference_1);
3102: l_doc_number fv_be_trx_hdrs.doc_number%TYPE;
3103: l_cust_class_code hz_cust_accounts_all.customer_class_code%TYPE;
3104: BEGIN
3105:
3106: log(l_module,'BUDGETARY TRANSACTION');
3107:

Line 5114: hz_cust_accounts_all hzca

5110:
5111: SELECT hzca.customer_class_code
5112: INTO l_cust_class_code
5113: FROM ra_customer_trx_all rct,
5114: hz_cust_accounts_all hzca
5115: WHERE rct.trx_number = p_reimb_agree_seg_val
5116: AND rct.set_of_books_id = g_set_of_books_id
5117: AND hzca.cust_account_id = rct.bill_to_customer_id;
5118:

Line 5156: hz_cust_accounts_all hzca

5152:
5153: SELECT hzca.customer_class_code
5154: INTO l_cust_class_code
5155: FROM ra_customer_trx_all rct,
5156: hz_cust_accounts_all hzca
5157: WHERE rct.trx_number = p_reimb_agree_seg_val
5158: AND rct.set_of_books_id = g_set_of_books_id
5159: AND hzca.cust_account_id = rct.bill_to_customer_id;
5160: