DBA Data[Home] [Help]

APPS.PAY_IE_P35_XML_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 512: FROM fnd_profile_option_values fpov, fnd_profile_options fpo

508: SUBSTR (fpov.profile_option_value, 1, 4)
509: || '01/01 00:00:00'
510: )
511: INTO l_start_date
512: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
513: WHERE fpo.profile_option_id = fpov.profile_option_id
514: AND fpo.application_id = fpov.application_id
515: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
516: AND fpov.level_id = 10001

Line 534: FROM fnd_profile_option_values fpov, fnd_profile_options fpo

530: SUBSTR (fpov.profile_option_value, 1, 4)
531: || '12/31 23:59:59'
532: )
533: INTO l_end_date
534: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
535: WHERE fpo.profile_option_id = fpov.profile_option_id
536: AND fpo.application_id = fpov.application_id
537: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
538: AND fpov.level_id = 10001