DBA Data[Home] [Help]

APPS.PAY_IE_P35_MAGTAPE dependencies on FND_PROFILE_OPTION_VALUES

Line 391: FROM fnd_profile_option_values fpov, fnd_profile_options fpo

387: SUBSTR (fpov.profile_option_value, 1, 4)
388: || '01/01 00:00:00'
389: )
390: INTO l_start_date
391: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
392: WHERE fpo.profile_option_id = fpov.profile_option_id
393: AND fpo.application_id = fpov.application_id
394: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
395: AND fpov.level_id = 10001

Line 413: FROM fnd_profile_option_values fpov, fnd_profile_options fpo

409: SUBSTR (fpov.profile_option_value, 1, 4)
410: || '12/31 23:59:59'
411: )
412: INTO l_end_date
413: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
414: WHERE fpo.profile_option_id = fpov.profile_option_id
415: AND fpo.application_id = fpov.application_id
416: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
417: AND fpov.level_id = 10001