DBA Data[Home] [Help]

APPS.PAY_IE_P35_XML_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 450: FROM fnd_profile_option_values fpov, fnd_profile_options fpo

446: SUBSTR (fpov.profile_option_value, 1, 4)
447: || '01/01 00:00:00'
448: )
449: INTO l_start_date
450: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
451: WHERE fpo.profile_option_id = fpov.profile_option_id
452: AND fpo.application_id = fpov.application_id
453: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
454: AND fpov.level_id = 10001

Line 472: FROM fnd_profile_option_values fpov, fnd_profile_options fpo

468: SUBSTR (fpov.profile_option_value, 1, 4)
469: || '12/31 23:59:59'
470: )
471: INTO l_end_date
472: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
473: WHERE fpo.profile_option_id = fpov.profile_option_id
474: AND fpo.application_id = fpov.application_id
475: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
476: AND fpov.level_id = 10001