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 100: ra_cust_trx_types rtt,

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

Line 116: FROM ra_cust_trx_types

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