APPS.RRS_PARTY_MERGE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 32

SELECT 1 FROM dual
WHERE EXISTS(
SELECT site_party_id
FROM rrs_sites_b
WHERE site_type_code = c_site_type
AND site_party_id = c_party_id);

Line: 71

	        UPDATE  rrs_sites_b
		SET	site_party_id =  p_to_fk_id,
		        last_update_date = SYSDATE,
			last_updated_by	= FND_GLOBAL.user_id,
			last_update_login = FND_GLOBAL.user_id
		WHERE   site_party_id =  p_from_fk_id;

Line: 117

Cursor get_sites_for_update(c_party_id IN NUMBER) IS
SELECT 1 FROM DUAL
WHERE EXISTS(
SELECT le_party_id
FROM rrs_sites_b
WHERE le_party_id = c_party_id);

Line: 133

       OPEN get_sites_for_update(p_from_fk_id);

Line: 134

       FETCH get_sites_for_update INTO l_from_site_num;

Line: 135

       IF ( get_sites_for_update%FOUND )  THEN
	UPDATE  rrs_sites_b
	SET	le_party_id =  p_to_fk_id,
	        last_update_date = SYSDATE,
		last_updated_by	=  FND_GLOBAL.user_id,
		last_update_login = FND_GLOBAL.user_id
        WHERE   le_party_id =  p_from_fk_id;

Line: 143

       CLOSE get_sites_for_update;