APPS.IBY_PAYGROUP_PUB dependencies on HZ_PARTIES

Line 23900: HZ_PARTIES payer_party

23896: '' -- payer federal us employer id
23897:
23898: FROM
23899: XLE_FIRSTPARTY_INFORMATION_V payer,
23900: HZ_PARTIES payer_party
23901:
23902: WHERE
23903:
23904: /* payer */

Line 24053: AND rfc_ca.owner_table_name(+) = 'HZ_PARTIES'

24049:
24050: /* payer bank location */
24051: AND iba_bnk_branch.branch_party_id = iba_branch_party_site.party_id(+)
24052: /* RFC related */
24053: AND rfc_ca.owner_table_name(+) = 'HZ_PARTIES'
24054: AND rfc_ca.class_category(+) = 'RFC_IDENTIFIER'
24055: AND rfc_ca.owner_table_id(+) = iba.bank_branch_id
24056: ;
24057:

Line 24231: FROM HZ_PARTIES hzp

24227:
24228: CURSOR c_le_registration_num_info(l_trxn_index BINARY_INTEGER)
24229: IS
24230: SELECT hzp.jgzz_fiscal_code
24231: FROM HZ_PARTIES hzp
24232: WHERE
24233: IBY_PAYGROUP_PUB.pmtTable.payee_party_id(l_trxn_index) = hzp.party_id;
24234:
24235: BEGIN

Line 24387: HZ_PARTIES benef_party

24383: payee.party_name,
24384: (SELECT
24385: benef_party.party_name
24386: FROM
24387: HZ_PARTIES benef_party
24388: WHERE
24389: benef_party.party_id=IBY_PAYGROUP_PUB.pmtTable.beneficiary_party(l_trx_index)
24390: )
24391: ), -- beneficiary name

Line 24396: HZ_PARTIES payee

24392:
24393: payee.attribute_category -- payee party attr category
24394:
24395: FROM
24396: HZ_PARTIES payee
24397:
24398: WHERE
24399:
24400: IBY_PAYGROUP_PUB.pmtTable.payee_party_id(l_trx_index) = payee.party_id

Line 25450: HZ_PARTIES hzp,

25446: hzp.party_name PRIMARY_ACCT_OWNER_NAME
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(+)

Line 26026: HZ_PARTIES benef_party

26022: invpayee.party_name,
26023: (SELECT
26024: benef_party.party_name
26025: FROM
26026: HZ_PARTIES benef_party
26027: WHERE
26028: benef_party.party_id=l_inv_beneficiary_party
26029: )
26030: ) inv_beneficiary_name,

Line 26066: HZ_PARTIES invpayee,

26062:
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