APPS.POS_SUPPLIER_PUB_JOB_PKG dependencies on HZ_PARTIES

Line 71: FROM hz_parties hz,

67: FROM ap_suppliers
68: WHERE last_update_date BETWEEN l_from_date AND l_to_date
69: UNION
70: SELECT ap.party_id
71: FROM hz_parties hz,
72: ap_suppliers ap
73: WHERE hz.party_id = ap.party_id
74: AND hz.last_update_date BETWEEN l_from_date AND l_to_date
75: UNION

Line 134: hz_parties bp,

130: UNION
131: SELECT ap.party_id
132: FROM hz_organization_profiles bapr,
133: hz_organization_profiles brpr,
134: hz_parties bp,
135: hz_party_sites s,
136: iby_account_owners ow,
137: hz_parties br,
138: ap_suppliers ap,

Line 137: hz_parties br,

133: hz_organization_profiles brpr,
134: hz_parties bp,
135: hz_party_sites s,
136: iby_account_owners ow,
137: hz_parties br,
138: ap_suppliers ap,
139: iby_ext_bank_accounts eb,
140: hz_code_assignments branchca,
141: hz_contact_points branchcp

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

148: AND nvl(ow.end_date, SYSDATE + 10) > SYSDATE
149: AND ow.account_owner_party_id = ap.party_id
150: AND (br.party_id = s.party_id(+))
151: AND (s.identifying_address_flag(+) = 'Y')
152: AND (branchcp.owner_table_name(+) = 'HZ_PARTIES')
153: AND (branchcp.owner_table_id(+) = eb.branch_id)
154: AND (branchcp.contact_point_type(+) = 'EFT')
155: AND (nvl(branchcp.status(+), 'A') = 'A')
156: AND (branchca.class_category(+) =

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

154: AND (branchcp.contact_point_type(+) = 'EFT')
155: AND (nvl(branchcp.status(+), 'A') = 'A')
156: AND (branchca.class_category(+) =
157: 'BANK_INSTITUTION_TYPE')
158: AND (branchca.owner_table_name(+) = 'HZ_PARTIES')
159: AND (branchca.owner_table_id(+) = eb.branch_id)
160: AND eb.last_update_date BETWEEN l_from_date AND l_to_date
161:
162: UNION