APPS.IBY_PAYGROUP_PUB dependencies on HZ_PARTY_SITES

Line 24041: HZ_PARTY_SITES iba_branch_party_site,

24037:
24038: /* Payer bank */
24039: CE_BANK_ACCOUNTS iba,
24040: CE_BANK_BRANCHES_V iba_bnk_branch,
24041: HZ_PARTY_SITES iba_branch_party_site,
24042: /* RFC */
24043: HZ_CODE_ASSIGNMENTS rfc_ca
24044:
24045: WHERE

Line 24503: HZ_PARTY_SITES payee_site

24499: payee_site.addressee
24500:
24501: FROM
24502:
24503: HZ_PARTY_SITES payee_site
24504: WHERE
24505: /* payment related */
24506:
24507: IBY_PAYGROUP_PUB.pmtTable.party_site_id(l_trx_index) = payee_site.party_site_id(+)

Line 25451: HZ_PARTY_SITES hzps

25447: FROM IBY_EXT_BANK_ACCOUNTS EBA,
25448: CE_BANK_BRANCHES_V EBA_BANK_BRANCH,
25449: IBY_ACCOUNT_OWNERS OW,
25450: HZ_PARTIES hzp,
25451: HZ_PARTY_SITES hzps
25452: WHERE IBY_PAYGROUP_PUB.pmtTable.external_bank_account_id(l_trx_index) = EBA.EXT_BANK_ACCOUNT_ID(+)
25453: AND EBA.BANK_ID = EBA_BANK_BRANCH.BANK_PARTY_ID(+)
25454: AND EBA.BRANCH_ID = EBA_BANK_BRANCH.BRANCH_PARTY_ID(+)
25455: AND eba.ext_bank_account_id = ow.ext_bank_account_id(+)

Line 26067: HZ_PARTY_SITES invpayee_site,

26063: FROM
26064:
26065: /* Payee */
26066: HZ_PARTIES invpayee,
26067: HZ_PARTY_SITES invpayee_site,
26068:
26069: AP_SUPPLIERS invvendor,
26070: AP_SUPPLIER_SITES_ALL invvendor_site
26071: