eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_EXT_PAYEE_RELSHIPS_PKG SQL Statements

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

Line: 33


	SELECT
	  relationship_id,
	  remit_party_id,
	  remit_supplier_site_id
	INTO
	  x_relationship_id,
	  x_remit_party_id,
	  x_remit_supplier_site_id
	FROM iby_ext_payee_relationships irel
	WHERE party_id = p_party_id
	 AND supplier_site_id = p_supplier_site_id
	 AND primary_flag = 'Y'
	 AND active = 'Y'
	 AND(to_char(nvl(p_date,   sysdate),   'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date,   'YYYY-MM-DD') || ' 00:00:00')
	 AND(to_char(nvl(irel.to_date,   nvl(p_date,   sysdate)),   'YYYY-MM-DD') || ' 23:59:59'));

Line: 99


		SELECT
		  relationship_id,
		  remit_party_id,
		  remit_supplier_site_id
		INTO
		  x_relationship_id,
		  x_remit_party_id,
		  x_remit_supplier_site_id
		FROM iby_ext_payee_relationships irel
		WHERE party_id = p_party_id
		 AND supplier_site_id = p_supplier_site_id
		 AND active = 'Y'
		 AND primary_flag = 'Y'
		 AND(to_char(nvl(p_date,   sysdate),   'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date,   'YYYY-MM-DD') || ' 00:00:00')
		 AND(to_char(nvl(irel.to_date,   nvl(p_date,   sysdate)),   'YYYY-MM-DD') || ' 23:59:59'));

Line: 133


		SELECT
		  relationship_id,
		  remit_party_id
		INTO
		  x_relationship_id,
		  x_remit_party_id
		FROM iby_ext_payee_relationships irel
		WHERE party_id = p_party_id
		 AND supplier_site_id = p_supplier_site_id
		 AND remit_supplier_site_id = x_remit_supplier_site_id
		 AND active = 'Y'
		 AND primary_flag = 'Y'
		 AND(to_char(nvl(p_date,   sysdate),   'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date,   'YYYY-MM-DD') || ' 00:00:00')
		 AND(to_char(nvl(irel.to_date,   nvl(p_date,   sysdate)),   'YYYY-MM-DD') || ' 23:59:59'));

Line: 155


			SELECT count(*)
			INTO p_count
			FROM iby_ext_payee_relationships irel
			WHERE party_id = p_party_id
			 AND supplier_site_id = p_supplier_site_id
			 AND remit_supplier_site_id = x_remit_supplier_site_id
			 AND active = 'Y'
			 AND(to_char(nvl(p_date,   sysdate),   'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date,   'YYYY-MM-DD') || ' 00:00:00')
			 AND(to_char(nvl(irel.to_date,   nvl(p_date,   sysdate)),   'YYYY-MM-DD') || ' 23:59:59'));

Line: 187


		SELECT
		  relationship_id,
		  remit_supplier_site_id
		INTO
		  x_relationship_id,
		  x_remit_supplier_site_id
		FROM iby_ext_payee_relationships irel
		WHERE party_id = p_party_id
		 AND supplier_site_id = p_supplier_site_id
		 AND remit_party_id = x_remit_party_id
		 AND active = 'Y'
		 AND primary_flag = 'Y'
		 AND(to_char(nvl(p_date,   sysdate),   'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date,   'YYYY-MM-DD') || ' 00:00:00')
		 AND(to_char(nvl(irel.to_date,   nvl(p_date,   sysdate)),   'YYYY-MM-DD') || ' 23:59:59'));

Line: 208


			SELECT count(*)
			INTO p_count
			FROM iby_ext_payee_relationships irel
			WHERE party_id = p_party_id
			 AND supplier_site_id = p_supplier_site_id
			 AND remit_party_id = x_remit_party_id
			 AND active = 'Y'
			 AND(to_char(nvl(p_date,   sysdate),   'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date,   'YYYY-MM-DD') || ' 00:00:00')
			 AND(to_char(nvl(irel.to_date,   nvl(p_date,   sysdate)),   'YYYY-MM-DD') || ' 23:59:59'));

Line: 240


		SELECT
		  relationship_id
		INTO
		  x_relationship_id
		FROM iby_ext_payee_relationships irel
		WHERE party_id = p_party_id
		 AND supplier_site_id = p_supplier_site_id
		 AND remit_party_id = x_remit_party_id
		 AND remit_supplier_site_id = x_remit_supplier_site_id
		 AND active = 'Y'
		 AND primary_flag = 'Y'
		 AND(to_char(nvl(p_date,   sysdate),   'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date,   'YYYY-MM-DD') || ' 00:00:00')
		 AND(to_char(nvl(irel.to_date,   nvl(p_date,   sysdate)),   'YYYY-MM-DD') || ' 23:59:59'));

Line: 260


			SELECT count(*)
			INTO p_count
			FROM iby_ext_payee_relationships irel
			WHERE party_id = p_party_id
			 AND supplier_site_id = p_supplier_site_id
			 AND remit_party_id = x_remit_party_id
			 AND remit_supplier_site_id = x_remit_supplier_site_id
			 AND active = 'Y'
			 AND(to_char(nvl(p_date,   sysdate),   'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date,   'YYYY-MM-DD') || ' 00:00:00')
			 AND(to_char(nvl(irel.to_date,   nvl(p_date,   sysdate)),   'YYYY-MM-DD') || ' 23:59:59'));

Line: 294


		SELECT
		  remit_party_id,
		  remit_supplier_site_id
		INTO
		  x_remit_party_id,
		  x_remit_supplier_site_id
		FROM iby_ext_payee_relationships irel
		WHERE party_id = p_party_id
		 AND supplier_site_id = p_supplier_site_id
		 AND active = 'Y'
		 AND relationship_id = x_relationship_id
		 AND(to_char(nvl(p_date,   sysdate),   'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date,   'YYYY-MM-DD') || ' 00:00:00')
		 AND(to_char(nvl(irel.to_date,   nvl(p_date,   sysdate)),   'YYYY-MM-DD') || ' 23:59:59'));

Line: 323


		SELECT
		  remit_party_id
		INTO
		  x_remit_party_id
		FROM iby_ext_payee_relationships irel
		WHERE party_id = p_party_id
		 AND supplier_site_id = p_supplier_site_id
		 AND remit_supplier_site_id = x_remit_supplier_site_id
		 AND active = 'Y'
		 AND relationship_id = x_relationship_id
		 AND(to_char(nvl(p_date,   sysdate),   'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date,   'YYYY-MM-DD') || ' 00:00:00')
		 AND(to_char(nvl(irel.to_date,   nvl(p_date,   sysdate)),   'YYYY-MM-DD') || ' 23:59:59'));

Line: 354


		SELECT
		  remit_supplier_site_id
		INTO
		  x_remit_supplier_site_id
		FROM iby_ext_payee_relationships irel
		WHERE party_id = p_party_id
		 AND supplier_site_id = p_supplier_site_id
		 AND remit_party_id = x_remit_party_id
		 AND active = 'Y'
		 AND relationship_id = x_relationship_id
		 AND(to_char(nvl(p_date,   sysdate),   'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date,   'YYYY-MM-DD') || ' 00:00:00')
		 AND(to_char(nvl(irel.to_date,   nvl(p_date,   sysdate)),   'YYYY-MM-DD') || ' 23:59:59'));

Line: 383


		SELECT
		  relationship_id
		INTO
		  x_relationship_id
		FROM iby_ext_payee_relationships irel
		WHERE party_id = p_party_id
		 AND supplier_site_id = p_supplier_site_id
		 AND remit_party_id = x_remit_party_id
		 AND remit_supplier_site_id = x_remit_supplier_site_id
		 AND active = 'Y'
		 AND relationship_id = x_relationship_id
		 AND(to_char(nvl(p_date,   sysdate),   'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date,   'YYYY-MM-DD') || ' 00:00:00')
		 AND(to_char(nvl(irel.to_date,   nvl(p_date,   sysdate)),   'YYYY-MM-DD') || ' 23:59:59'));