APPS.FV_IPAC dependencies on HZ_PARTIES

Line 26: parm_customer_category hz_parties.category_code%TYPE;

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;
29: parm_trx_date_high DATE;
30: parm_currency ra_customer_trx.invoice_currency_code%TYPE;

Line 27: parm_customer_id hz_parties.party_id%TYPE;

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;
29: parm_trx_date_high DATE;
30: parm_currency ra_customer_trx.invoice_currency_code%TYPE;
31: parm_contact_name fv_ipac_trx_all.cnt_nm%TYPE;

Line 98: FROM hz_parties hzp,

94: rct.initial_customer_trx_id,
95: DECODE(hzp.PARTY_TYPE, 'ORGANIZATION', hzp.DUNS_NUMBER_C, NULL) duns_number_c,
96: rsu.Cust_Acct_site_ID bill_to_address_id,
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 ,

Line 128: FROM hz_parties hp,

124: )
125: AND hzca.cust_account_id IN
126: (
127: (SELECT hzca.cust_account_id
128: FROM hz_parties hp,
129: hz_cust_accounts hca
130: WHERE hp.party_id = hca.party_id
131: AND NVL(category_code,'XXX') LIKE DECODE(parm_customer_category,NULL, NVL(category_code,'XXX'), parm_customer_category)
132: )