APPS.POS_BANK_ACCOUNT_BO_PKG dependencies on HZ_PARTIES

Line 105: hz_parties bp,

101: BULK COLLECT
102: INTO l_pos_bank_account_bo_tbl
103: FROM hz_organization_profiles bapr,
104: hz_organization_profiles brpr,
105: hz_parties bp,
106: hz_party_sites s,
107: iby_account_owners ow,
108: hz_parties br,
109: hz_parties op,

Line 108: hz_parties br,

104: hz_organization_profiles brpr,
105: hz_parties bp,
106: hz_party_sites s,
107: iby_account_owners ow,
108: hz_parties br,
109: hz_parties op,
110: iby_ext_bank_accounts eb,
111: hz_code_assignments branchca,
112: hz_contact_points branchcp,

Line 109: hz_parties op,

105: hz_parties bp,
106: hz_party_sites s,
107: iby_account_owners ow,
108: hz_parties br,
109: hz_parties op,
110: iby_ext_bank_accounts eb,
111: hz_code_assignments branchca,
112: hz_contact_points branchcp,
113:

Line 138: AND (branchcp.owner_table_name(+) = 'HZ_PARTIES')

134: AND nvl(ow.end_date, SYSDATE + 10) > SYSDATE
135: AND ow.account_owner_party_id = op.party_id(+)
136: AND (br.party_id = s.party_id(+))
137: AND (s.identifying_address_flag(+) = 'Y')
138: AND (branchcp.owner_table_name(+) = 'HZ_PARTIES')
139: AND (branchcp.owner_table_id(+) = eb.branch_id)
140: AND (branchcp.contact_point_type(+) = 'EFT')
141: AND (nvl(branchcp.status(+), 'A') = 'A')
142: AND (branchca.class_category(+) = 'BANK_BRANCH_TYPE') -- Bug 13586778: Publish Branch Type

Line 143: AND (branchca.owner_table_name(+) = 'HZ_PARTIES')

139: AND (branchcp.owner_table_id(+) = eb.branch_id)
140: AND (branchcp.contact_point_type(+) = 'EFT')
141: AND (nvl(branchcp.status(+), 'A') = 'A')
142: AND (branchca.class_category(+) = 'BANK_BRANCH_TYPE') -- Bug 13586778: Publish Branch Type
143: AND (branchca.owner_table_name(+) = 'HZ_PARTIES')
144: AND (branchca.owner_table_id(+) = eb.branch_id)
145: AND SYSDATE BETWEEN -- Bug 14621927: Check effect end date to prevent publishing ineffective bank record
146: trunc(bapr.effective_start_date) AND
147: nvl(trunc(bapr.effective_end_date), SYSDATE + 1)