APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on HZ_CUST_ACCOUNTS

Line 1789: hz_cust_accounts custacct

1785: g_nit_rec.verifying_digit,
1786: l_customer_num
1787: FROM jl_co_gl_nits jlcgn,
1788: hz_parties rac,
1789: hz_cust_accounts custacct
1790: WHERE custacct.cust_account_id = TO_NUMBER(ar_trx.reference_7)
1791: AND REPLACE(rac.jgzz_fiscal_code,'-') = jlcgn.nit(+)
1792: AND custacct.party_id=rac.party_id;
1793:

Line 2114: hz_cust_accounts custacct

2110: g_nit_rec.verifying_digit,
2111: l_customer_num
2112: FROM jl_co_gl_nits jlcgn,
2113: hz_parties rac,
2114: hz_cust_accounts custacct
2115: WHERE custacct.cust_account_id = ar_trx.party_id
2116: AND substr(jgzz_fiscal_code,1,decode(instr(jgzz_fiscal_code,'-'),0,14,instr(jgzz_fiscal_code,'-')-1)) = jlcgn.nit(+) --bug8685975
2117: AND custacct.party_id=rac.party_id;
2118: FND_FILE.PUT_LINE(FND_FILE.log,'Query(-)');