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 97: FROM hz_parties hzp,

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

Line 127: FROM hz_parties hp,

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