DBA Data[Home] [Help]

APPS.FA_JP_TAX_EXTN_PVT dependencies on FND_PROFILE_OPTIONS_VL

Line 819: FROM fnd_profile_options_vl

815: *
816: ***********************************************************************/
817: IS
818: SELECT user_profile_option_name
819: FROM fnd_profile_options_vl
820: WHERE profile_option_name = p_option_name;
821:
822: CURSOR lcr_books (
823: p_book_type_code IN fa_books.book_type_code%TYPE

Line 1137: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;

1133: ln_acc_deprn NUMBER;
1134: ln_first_elg_period NUMBER;
1135: ln_first_beg_period NUMBER;
1136: l_period fa_deprn_periods.period_name%TYPE;
1137: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1138: l_period_counter fa_deprn_periods.period_counter%TYPE;
1139: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1140: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1141: l_period_name fa_deprn_periods.period_name%TYPE;

Line 1424: FROM fnd_profile_options_vl

1420: *
1421: ***********************************************************************/
1422: IS
1423: SELECT user_profile_option_name
1424: FROM fnd_profile_options_vl
1425: WHERE profile_option_name = p_option_name;
1426:
1427: CURSOR lcr_books (
1428: p_book_type_code IN fa_books.book_type_code%TYPE

Line 1855: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;

1851: l_end_date_check DATE;
1852: l_extd_period_name VARCHAR2 (10);
1853: l_extended_date DATE;
1854: l_period fa_deprn_periods.period_name%TYPE;
1855: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1856: l_period_counter fa_deprn_periods.period_counter%TYPE;
1857: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1858: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1859: l_period_name fa_deprn_periods.period_name%TYPE;