DBA Data[Home] [Help]

APPS.PAY_IE_P35 dependencies on FND_PROFILE_OPTION_VALUES

Line 5642: FROM fnd_profile_option_values fpov, fnd_profile_options fpo

5638: SUBSTR (fpov.profile_option_value, 1, 4)
5639: || '01/01 00:00:00'
5640: )
5641: INTO l_start_date
5642: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
5643: WHERE fpo.profile_option_id = fpov.profile_option_id
5644: AND fpo.application_id = fpov.application_id
5645: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
5646: AND fpov.level_id = 10001

Line 5664: FROM fnd_profile_option_values fpov, fnd_profile_options fpo

5660: SUBSTR (fpov.profile_option_value, 1, 4)
5661: || '12/31 23:59:59'
5662: )
5663: INTO l_end_date
5664: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
5665: WHERE fpo.profile_option_id = fpov.profile_option_id
5666: AND fpo.application_id = fpov.application_id
5667: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
5668: AND fpov.level_id = 10001