DBA Data[Home] [Help]

APPS.PER_RAA_BUS dependencies on FND_PROFILE

Line 500: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'));

496: and p_date_start between ptu.effective_start_date and ptu.effective_end_date
497: and ptu.person_type_id = ppt.person_type_id
498: and (ppt.system_person_type = 'EMP'
499: or (ppt.system_person_type = 'CWK' and
500: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'));
501: --
502: begin
503: hr_utility.set_location('Entering:'||l_proc,10);
504: --

Line 694: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'));

690: and p_date_start between ptu.effective_start_date and ptu.effective_end_date
691: and ptu.person_type_id = ppt.person_type_id
692: and (ppt.system_person_type = 'EMP'
693: or (ppt.system_person_type = 'CWK' and
694: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'));
695:
696: --
697: begin
698: hr_utility.set_location('Entering:'||l_proc,10);