DBA Data[Home] [Help]

APPS.PAY_IE_P35 dependencies on FND_PROFILE_OPTION_VALUES

Line 8913: FROM fnd_profile_option_values fpov, fnd_profile_options fpo

8909: SUBSTR (fpov.profile_option_value, 1, 4)
8910: || '01/01 00:00:00'
8911: )
8912: INTO l_start_date
8913: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
8914: WHERE fpo.profile_option_id = fpov.profile_option_id
8915: AND fpo.application_id = fpov.application_id
8916: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
8917: AND fpov.level_id = 10001

Line 8935: FROM fnd_profile_option_values fpov, fnd_profile_options fpo

8931: SUBSTR (fpov.profile_option_value, 1, 4)
8932: || '12/31 23:59:59'
8933: )
8934: INTO l_end_date
8935: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
8936: WHERE fpo.profile_option_id = fpov.profile_option_id
8937: AND fpo.application_id = fpov.application_id
8938: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
8939: AND fpov.level_id = 10001