APPS.ZX_AR_POPULATE_PKG dependencies on HZ_PARTIES

Line 3849: FROM HZ_PARTIES PARTY

3845: DECODE(PARTY.PARTY_TYPE,'ORGANIZATION',PARTY.ORGANIZATION_NAME_PHONETIC,NULL),
3846: DECODE(PARTY.PARTY_TYPE,'ORGANIZATION',PARTY.SIC_CODE,NULL),
3847: PARTY.PARTY_NUMBER,
3848: PARTY.JGZZ_FISCAL_CODE
3849: FROM HZ_PARTIES PARTY
3850: WHERE PARTY.PARTY_ID = c_party_id;
3851:
3852: CURSOR party_site_cur ( c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
3853: SELECT LOC.CITY,

Line 3892: FROM hz_parties br_party,

3888:
3889:
3890: CURSOR bank_tp_taxpayer_cur (c_bank_account_id ZX_REP_TRX_DETAIL_T.BANK_ACCOUNT_ID%TYPE) IS
3891: SELECT NVL(br_party.jgzz_fiscal_code, ba_party.jgzz_fiscal_code)
3892: FROM hz_parties br_party,
3893: hz_parties ba_party,
3894: ce_bank_branches_v ce_branch,
3895: ce_bank_accounts ce_accts
3896: WHERE ce_accts.bank_account_id = c_bank_account_id

Line 3893: hz_parties ba_party,

3889:
3890: CURSOR bank_tp_taxpayer_cur (c_bank_account_id ZX_REP_TRX_DETAIL_T.BANK_ACCOUNT_ID%TYPE) IS
3891: SELECT NVL(br_party.jgzz_fiscal_code, ba_party.jgzz_fiscal_code)
3892: FROM hz_parties br_party,
3893: hz_parties ba_party,
3894: ce_bank_branches_v ce_branch,
3895: ce_bank_accounts ce_accts
3896: WHERE ce_accts.bank_account_id = c_bank_account_id
3897: AND ce_accts.bank_branch_id = ce_branch.branch_party_id