APPS.HZ_CUST_ACCT_SITE_BO_PUB dependencies on HZ_PARTY_SITES

Line 188: FROM HZ_PARTY_SITES ps, HZ_ORIG_SYS_REFERENCES ref

184: AND a.cust_account_id = l_acct_id;
185:
186: CURSOR get_ps_id(l_os VARCHAR2, l_osr VARCHAR2) IS
187: SELECT ps.party_site_id
188: FROM HZ_PARTY_SITES ps, HZ_ORIG_SYS_REFERENCES ref
189: WHERE ref.owner_table_id = ps.party_site_id
190: AND ref.owner_table_name = 'HZ_PARTY_SITES'
191: AND ref.orig_system = l_os
192: AND ref.orig_system_reference = l_osr

Line 190: AND ref.owner_table_name = 'HZ_PARTY_SITES'

186: CURSOR get_ps_id(l_os VARCHAR2, l_osr VARCHAR2) IS
187: SELECT ps.party_site_id
188: FROM HZ_PARTY_SITES ps, HZ_ORIG_SYS_REFERENCES ref
189: WHERE ref.owner_table_id = ps.party_site_id
190: AND ref.owner_table_name = 'HZ_PARTY_SITES'
191: AND ref.orig_system = l_os
192: AND ref.orig_system_reference = l_osr
193: AND ref.status = 'A'
194: AND rownum = 1;

Line 1625: FROM HZ_PARTY_SITES ps, HZ_ORIG_SYS_REFERENCES ref

1621: AND a.cust_account_id = l_acct_id;
1622:
1623: CURSOR get_ps_id(l_os VARCHAR2, l_osr VARCHAR2) IS
1624: SELECT ps.party_site_id
1625: FROM HZ_PARTY_SITES ps, HZ_ORIG_SYS_REFERENCES ref
1626: WHERE ref.owner_table_id = ps.party_site_id
1627: AND ref.owner_table_name = 'HZ_PARTY_SITES'
1628: AND ref.orig_system = l_os
1629: AND ref.orig_system_reference = l_osr

Line 1627: AND ref.owner_table_name = 'HZ_PARTY_SITES'

1623: CURSOR get_ps_id(l_os VARCHAR2, l_osr VARCHAR2) IS
1624: SELECT ps.party_site_id
1625: FROM HZ_PARTY_SITES ps, HZ_ORIG_SYS_REFERENCES ref
1626: WHERE ref.owner_table_id = ps.party_site_id
1627: AND ref.owner_table_name = 'HZ_PARTY_SITES'
1628: AND ref.orig_system = l_os
1629: AND ref.orig_system_reference = l_osr
1630: AND ref.status = 'A'
1631: AND rownum = 1;