APPS.RRS_PARTY_MERGE_PKG dependencies on DUAL

Line 32: SELECT 1 FROM dual

28: x_return_status OUT NOCOPY VARCHAR2) IS
29:
30:
31: Cursor c_sites(c_party_id NUMBER,c_site_type VARCHAR2) IS
32: SELECT 1 FROM dual
33: WHERE EXISTS(
34: SELECT site_party_id
35: FROM rrs_sites_b
36: WHERE site_type_code = c_site_type

Line 118: SELECT 1 FROM DUAL

114: p_batch_party_id IN NUMBER,
115: x_return_status OUT NOCOPY VARCHAR2) IS
116:
117: Cursor get_sites_for_update(c_party_id IN NUMBER) IS
118: SELECT 1 FROM DUAL
119: WHERE EXISTS(
120: SELECT le_party_id
121: FROM rrs_sites_b
122: WHERE le_party_id = c_party_id);