APPS.IBY_UPG_PPP_PKG dependencies on FND_PROFILE_OPTIONS

Line 951: FROM fnd_profile_options o,

947: INTO l_jenl_eft_reporting_limit
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

Line 1700: FROM fnd_profile_options o,

1696: INTO l_jenl_eft_dir_value
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

Line 1717: FROM fnd_profile_options o,

1713: INTO l_xxno_signet_file_value
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

Line 1734: FROM fnd_profile_options o,

1730: INTO l_ece_out_file_value
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

Line 1755: FROM fnd_profile_options o,

1751: INTO l_jenl_eft_reporting_limit
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

Line 1777: FROM fnd_profile_options o,

1773: INTO l_jenl_pmt_separation
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