DBA Data[Home] [Help]

APPS.JAI_ETCS_PKG dependencies on HZ_PARTIES

Line 2892: v_party_name hz_parties.party_name%type ;

2888: v_book_entry VARCHAR2(1) ;
2889:
2890: -- Deductee Detail
2891: v_challan_line_num number ;
2892: v_party_name hz_parties.party_name%type ;
2893: v_deductee_state_code number;
2894: v_reason_for_nDeduction varchar2(1);
2895: ln_diff_rate number ;
2896: v_deductee_slno number ;

Line 2921: Hence joined hz_parties and hz_cust_accounts to get Party Name

2917:
2918:
2919: /*
2920: Bug 8429168 - Customer Account ID was passed as parameter
2921: Hence joined hz_parties and hz_cust_accounts to get Party Name
2922: */
2923: cursor c_cust_name(cp_customer_id in number)
2924: is
2925: select hp.party_name

Line 2926: from hz_parties hp, hz_cust_accounts hca

2922: */
2923: cursor c_cust_name(cp_customer_id in number)
2924: is
2925: select hp.party_name
2926: from hz_parties hp, hz_cust_accounts hca
2927: where hca.cust_account_id = cp_customer_id
2928: and hca.party_id = hp.party_id;
2929:
2930: