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_UPG_PPP_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 952: fnd_profile_option_values v

948: FROM ( SELECT o.profile_option_name, v.profile_option_value,
949: row_number() OVER (partition by o.profile_option_name
950: order by count(*) desc) order_rank
951: FROM fnd_profile_options o,
952: fnd_profile_option_values v
953: WHERE o.profile_option_name = UPPER('JENL_REPORTING_THRESHOLD')
954: AND v.application_id = o.application_id
955: AND v.profile_option_id = o.profile_option_id
956: GROUP BY o.profile_option_name, v.profile_option_value) x

Line 1664: l_jenl_eft_dir_value fnd_profile_option_values.profile_option_value%TYPE;

1660: -- l_user_id NUMBER(15);
1661: -- l_login_id NUMBER(15);
1662: -- l_sysdate DATE;
1663: l_max_app NUMBER := 0;
1664: l_jenl_eft_dir_value fnd_profile_option_values.profile_option_value%TYPE;
1665: l_xxno_signet_file_value fnd_profile_option_values.profile_option_value%TYPE;
1666: l_ece_out_file_value fnd_profile_option_values.profile_option_value%TYPE;
1667: l_jenl_eft_reporting_limit NUMBER;
1668: l_jenl_pmt_separation fnd_profile_option_values.profile_option_value%TYPE;

Line 1665: l_xxno_signet_file_value fnd_profile_option_values.profile_option_value%TYPE;

1661: -- l_login_id NUMBER(15);
1662: -- l_sysdate DATE;
1663: l_max_app NUMBER := 0;
1664: l_jenl_eft_dir_value fnd_profile_option_values.profile_option_value%TYPE;
1665: l_xxno_signet_file_value fnd_profile_option_values.profile_option_value%TYPE;
1666: l_ece_out_file_value fnd_profile_option_values.profile_option_value%TYPE;
1667: l_jenl_eft_reporting_limit NUMBER;
1668: l_jenl_pmt_separation fnd_profile_option_values.profile_option_value%TYPE;
1669:

Line 1666: l_ece_out_file_value fnd_profile_option_values.profile_option_value%TYPE;

1662: -- l_sysdate DATE;
1663: l_max_app NUMBER := 0;
1664: l_jenl_eft_dir_value fnd_profile_option_values.profile_option_value%TYPE;
1665: l_xxno_signet_file_value fnd_profile_option_values.profile_option_value%TYPE;
1666: l_ece_out_file_value fnd_profile_option_values.profile_option_value%TYPE;
1667: l_jenl_eft_reporting_limit NUMBER;
1668: l_jenl_pmt_separation fnd_profile_option_values.profile_option_value%TYPE;
1669:
1670: l_remit_advice_format_code VARCHAR2(50) := 'IBY_PAY_REMIT_ADV';

Line 1668: l_jenl_pmt_separation fnd_profile_option_values.profile_option_value%TYPE;

1664: l_jenl_eft_dir_value fnd_profile_option_values.profile_option_value%TYPE;
1665: l_xxno_signet_file_value fnd_profile_option_values.profile_option_value%TYPE;
1666: l_ece_out_file_value fnd_profile_option_values.profile_option_value%TYPE;
1667: l_jenl_eft_reporting_limit NUMBER;
1668: l_jenl_pmt_separation fnd_profile_option_values.profile_option_value%TYPE;
1669:
1670: l_remit_advice_format_code VARCHAR2(50) := 'IBY_PAY_REMIT_ADV';
1671:
1672: BEGIN

Line 1701: fnd_profile_option_values v

1697: FROM ( SELECT o.profile_option_name, v.profile_option_value,
1698: row_number() OVER (partition by o.profile_option_name
1699: order by count(*) desc) order_rank
1700: FROM fnd_profile_options o,
1701: fnd_profile_option_values v
1702: WHERE o.profile_option_name = UPPER('JENL_EFT_DIR')
1703: AND v.application_id = o.application_id
1704: AND v.profile_option_id = o.profile_option_id
1705: GROUP BY o.profile_option_name, v.profile_option_value) x

Line 1718: fnd_profile_option_values v

1714: FROM ( SELECT o.profile_option_name, v.profile_option_value,
1715: row_number() OVER (partition by o.profile_option_name
1716: order by count(*) desc) order_rank
1717: FROM fnd_profile_options o,
1718: fnd_profile_option_values v
1719: WHERE o.profile_option_name = UPPER('XXNO_SIGNET_CONFIG_FILE')
1720: AND v.application_id = o.application_id
1721: AND v.profile_option_id = o.profile_option_id
1722: GROUP BY o.profile_option_name, v.profile_option_value) x

Line 1735: fnd_profile_option_values v

1731: FROM ( SELECT o.profile_option_name, v.profile_option_value,
1732: row_number() OVER (partition by o.profile_option_name
1733: order by count(*) desc) order_rank
1734: FROM fnd_profile_options o,
1735: fnd_profile_option_values v
1736: WHERE o.profile_option_name = UPPER('ECE_OUT_FILE_PATH')
1737: AND v.application_id = o.application_id
1738: AND v.profile_option_id = o.profile_option_id
1739: GROUP BY o.profile_option_name, v.profile_option_value) x

Line 1756: fnd_profile_option_values v

1752: FROM ( SELECT o.profile_option_name, v.profile_option_value,
1753: row_number() OVER (partition by o.profile_option_name
1754: order by count(*) desc) order_rank
1755: FROM fnd_profile_options o,
1756: fnd_profile_option_values v
1757: WHERE o.profile_option_name = UPPER('JENL_REPORTING_THRESHOLD')
1758: AND v.application_id = o.application_id
1759: AND v.profile_option_id = o.profile_option_id
1760: GROUP BY o.profile_option_name, v.profile_option_value) x

Line 1778: fnd_profile_option_values v

1774: FROM ( SELECT o.profile_option_name, v.profile_option_value,
1775: row_number() OVER (partition by o.profile_option_name
1776: order by count(*) desc) order_rank
1777: FROM fnd_profile_options o,
1778: fnd_profile_option_values v
1779: WHERE o.profile_option_name = UPPER('JENL_PAYMENT_SEPARATION')
1780: AND v.application_id = o.application_id
1781: AND v.profile_option_id = o.profile_option_id
1782: GROUP BY o.profile_option_name, v.profile_option_value) x