APPS.FV_IPAC dependencies on RA_CUST_TRX_TYPES

Line 24: parm_transaction_type ra_cust_trx_types.cust_trx_type_id%TYPE;

20:
21: -- ------------------------------------
22: -- Stored Input Parameters
23: -- ------------------------------------
24: parm_transaction_type ra_cust_trx_types.cust_trx_type_id%TYPE;
25: parm_profile_class_id NUMBER;
26: parm_customer_category hz_parties.category_code%TYPE;
27: parm_customer_id hz_parties.party_id%TYPE;
28: parm_trx_date_low DATE;

Line 101: ra_cust_trx_types rtt,

97: rct.invoice_currency_code
98: FROM hz_parties hzp,
99: hz_cust_accounts hzca,
100: ra_customer_trx rct,
101: ra_cust_trx_types rtt,
102: HZ_CUST_SITE_USES rsu ,
103: ar_remit_to_addresses_v arem,
104: fv_facts_customers_v ffc
105: WHERE hzp.party_id = hzca.party_id

Line 117: FROM ra_cust_trx_types

113: AND UPPER(hzca.customer_class_code) = 'FEDERAL'
114: AND rtt.TYPE = 'INV'
115: AND rct.cust_trx_type_id IN
116: (SELECT cust_trx_type_id
117: FROM ra_cust_trx_types
118: WHERE cust_trx_type_id = DECODE(parm_transaction_type,NULL, cust_trx_type_id,parm_transaction_type)
119: )
120: AND rct.bill_to_customer_id IN
121: (SELECT DISTINCT cust_account_id