DBA Data[Home] [Help]

APPS.ARP_RW_BATCHES_PKG dependencies on HZ_PARTIES

Line 899: hz_parties CHParty,

895: FROM ar_receipt_method_accounts rma2,
896: ce_bank_accounts cba2,
897: ce_bank_acct_uses ba2,
898: ce_bank_branches_v bb2,
899: hz_parties CHParty,
900: hz_parties RelParty,
901: hz_relationships BCRel,
902: hz_contact_points Eft
903: WHERE rma2.receipt_method_id = l_batch_rec.receipt_method_id

Line 900: hz_parties RelParty,

896: ce_bank_accounts cba2,
897: ce_bank_acct_uses ba2,
898: ce_bank_branches_v bb2,
899: hz_parties CHParty,
900: hz_parties RelParty,
901: hz_relationships BCRel,
902: hz_contact_points Eft
903: WHERE rma2.receipt_method_id = l_batch_rec.receipt_method_id
904: AND rma2.remit_bank_acct_use_id = ba2.bank_acct_use_id

Line 910: AND BCRel.subject_table_name = 'HZ_PARTIES'

906: AND cba2.currency_code = l_batch_rec.currency_code
907: AND cba2.bank_branch_id = bb2.branch_party_id
908: AND BCRel.subject_id = bb2.branch_party_id
909: AND BCRel.subject_type = 'ORGANIZATION'
910: AND BCRel.subject_table_name = 'HZ_PARTIES'
911: AND BCRel.object_id = CHParty.party_id
912: AND BCRel.object_type = 'ORGANIZATION'
913: AND BCRel.object_table_name = 'HZ_PARTIES'
914: AND BCRel.relationship_type = 'CLEARINGHOUSE_BANK'

Line 913: AND BCRel.object_table_name = 'HZ_PARTIES'

909: AND BCRel.subject_type = 'ORGANIZATION'
910: AND BCRel.subject_table_name = 'HZ_PARTIES'
911: AND BCRel.object_id = CHParty.party_id
912: AND BCRel.object_type = 'ORGANIZATION'
913: AND BCRel.object_table_name = 'HZ_PARTIES'
914: AND BCRel.relationship_type = 'CLEARINGHOUSE_BANK'
915: AND BCRel.relationship_code = 'USES_CLEARINGHOUSE'
916: AND BCRel.status = 'A'
917: AND RelParty.party_id = BCRel.party_id

Line 918: AND Eft.owner_table_name(+) = 'HZ_PARTIES'

914: AND BCRel.relationship_type = 'CLEARINGHOUSE_BANK'
915: AND BCRel.relationship_code = 'USES_CLEARINGHOUSE'
916: AND BCRel.status = 'A'
917: AND RelParty.party_id = BCRel.party_id
918: AND Eft.owner_table_name(+) = 'HZ_PARTIES'
919: AND Eft.owner_table_id(+) = CHParty.party_id
920: AND Eft.contact_point_type(+) = 'EFT'
921: AND Eft.status(+) = 'A'
922: AND CHParty.party_id = bb.branch_party_id));