APPS.ZX_AR_POPULATE_PKG dependencies on HZ_PARTIES

Line 3463: FROM HZ_PARTIES PARTY

3459: PARTY.SIC_CODE,
3460: NULL) ,
3461: PARTY.PARTY_NUMBER,
3462: PARTY.JGZZ_FISCAL_CODE
3463: FROM HZ_PARTIES PARTY
3464: WHERE PARTY.PARTY_ID = c_party_id;
3465:
3466: CURSOR party_site_cur ( c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
3467: select LOC.CITY,

Line 3506: FROM hz_parties br_party,

3502:
3503:
3504: CURSOR bank_tp_taxpayer_cur (c_bank_account_id ZX_REP_TRX_DETAIL_T.BANK_ACCOUNT_ID%TYPE) IS
3505: SELECT NVL(br_party.jgzz_fiscal_code, ba_party.jgzz_fiscal_code)
3506: FROM hz_parties br_party,
3507: hz_parties ba_party,
3508: ce_bank_branches_v ce_branch,
3509: ce_bank_accounts ce_accts
3510: WHERE ce_accts.bank_account_id = c_bank_account_id

Line 3507: hz_parties ba_party,

3503:
3504: CURSOR bank_tp_taxpayer_cur (c_bank_account_id ZX_REP_TRX_DETAIL_T.BANK_ACCOUNT_ID%TYPE) IS
3505: SELECT NVL(br_party.jgzz_fiscal_code, ba_party.jgzz_fiscal_code)
3506: FROM hz_parties br_party,
3507: hz_parties ba_party,
3508: ce_bank_branches_v ce_branch,
3509: ce_bank_accounts ce_accts
3510: WHERE ce_accts.bank_account_id = c_bank_account_id
3511: AND ce_accts.bank_branch_id = ce_branch.branch_party_id