APPS.PER_FR_D2_PKG dependencies on HR_API

Line 897: and nvl(block1.asg_hours,hr_api.g_number) =

893: and block1.asg_primary = block2.asg_primary
894: and nvl(block1.asg_employment_category,' ') =
895: nvl(block2.asg_employment_category,' ')
896: and nvl(block1.asg_freq,' ') = nvl(block2.asg_freq,' ')
897: and nvl(block1.asg_hours,hr_api.g_number) =
898: nvl(block2.asg_hours,hr_api.g_number)
899: and block1.asg_type = block2.asg_type
900: and nvl(block1.ctr_type,' ') = nvl(block2.ctr_type,' ')
901: and nvl(block1.ctr_fr_person_replaced,' ') =

Line 898: nvl(block2.asg_hours,hr_api.g_number)

894: and nvl(block1.asg_employment_category,' ') =
895: nvl(block2.asg_employment_category,' ')
896: and nvl(block1.asg_freq,' ') = nvl(block2.asg_freq,' ')
897: and nvl(block1.asg_hours,hr_api.g_number) =
898: nvl(block2.asg_hours,hr_api.g_number)
899: and block1.asg_type = block2.asg_type
900: and nvl(block1.ctr_type,' ') = nvl(block2.ctr_type,' ')
901: and nvl(block1.ctr_fr_person_replaced,' ') =
902: nvl(block2.ctr_fr_person_replaced,' ')

Line 907: and nvl(block1.asg_full_time_hours,hr_api.g_number) =

903: and nvl(block1.ctr_status,' ') = nvl(block2.ctr_status,' ')
904: and nvl(block1.ass_employee_category,' ') =
905: nvl(block2.ass_employee_category,' ')
906: and nvl(block1.asg_full_time_freq,' ') = nvl(block2.asg_full_time_freq,' ')
907: and nvl(block1.asg_full_time_hours,hr_api.g_number) =
908: nvl(block2.asg_full_time_hours,hr_api.g_number)
909: and nvl(block1.asg_fte_value,hr_api.g_number) =
910: nvl(block2.asg_fte_value,hr_api.g_number)
911: and block1.per_type_id = block2.per_type_id

Line 908: nvl(block2.asg_full_time_hours,hr_api.g_number)

904: and nvl(block1.ass_employee_category,' ') =
905: nvl(block2.ass_employee_category,' ')
906: and nvl(block1.asg_full_time_freq,' ') = nvl(block2.asg_full_time_freq,' ')
907: and nvl(block1.asg_full_time_hours,hr_api.g_number) =
908: nvl(block2.asg_full_time_hours,hr_api.g_number)
909: and nvl(block1.asg_fte_value,hr_api.g_number) =
910: nvl(block2.asg_fte_value,hr_api.g_number)
911: and block1.per_type_id = block2.per_type_id
912: and block1.person_type_usages = block2.person_type_usages

Line 909: and nvl(block1.asg_fte_value,hr_api.g_number) =

905: nvl(block2.ass_employee_category,' ')
906: and nvl(block1.asg_full_time_freq,' ') = nvl(block2.asg_full_time_freq,' ')
907: and nvl(block1.asg_full_time_hours,hr_api.g_number) =
908: nvl(block2.asg_full_time_hours,hr_api.g_number)
909: and nvl(block1.asg_fte_value,hr_api.g_number) =
910: nvl(block2.asg_fte_value,hr_api.g_number)
911: and block1.per_type_id = block2.per_type_id
912: and block1.person_type_usages = block2.person_type_usages
913: then

Line 910: nvl(block2.asg_fte_value,hr_api.g_number)

906: and nvl(block1.asg_full_time_freq,' ') = nvl(block2.asg_full_time_freq,' ')
907: and nvl(block1.asg_full_time_hours,hr_api.g_number) =
908: nvl(block2.asg_full_time_hours,hr_api.g_number)
909: and nvl(block1.asg_fte_value,hr_api.g_number) =
910: nvl(block2.asg_fte_value,hr_api.g_number)
911: and block1.per_type_id = block2.per_type_id
912: and block1.person_type_usages = block2.person_type_usages
913: then
914: l_return := false;