DBA Data[Home] [Help]

APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on HR_GENERAL

Line 717: l_job_name := hr_general.decode_job (lr_assignment_info.job_id);

713: --logger ('l_absence_from', l_absence_from);
714: --logger ('l_absence_to', l_absence_to);
715: --logger (' l_absence_percentage', l_absence_percentage);
716: -- *****************************************************************************
717: l_job_name := hr_general.decode_job (lr_assignment_info.job_id);
718: l_position_name :=
719: hr_general.decode_position_latest_name
720: (lr_assignment_info.position_id
721: ,lr_assignment_info.effective_start_date

Line 719: hr_general.decode_position_latest_name

715: --logger (' l_absence_percentage', l_absence_percentage);
716: -- *****************************************************************************
717: l_job_name := hr_general.decode_job (lr_assignment_info.job_id);
718: l_position_name :=
719: hr_general.decode_position_latest_name
720: (lr_assignment_info.position_id
721: ,lr_assignment_info.effective_start_date
722: );
723: l_form_of_employment := lr_assignment_info.EMPLOYMENT_CATEGORY;

Line 757: hr_general.decode_lookup ('LEAV_REAS'

753: CLOSE csr_soft_coded_keyflex_info;
754:
755: l_local_unit_id := lr_soft_coded_keyflex_info.segment2;
756: l_reason :=
757: hr_general.decode_lookup ('LEAV_REAS'
758: ,lr_soft_coded_keyflex_info.segment7
759: );
760: l_notification_date := lr_soft_coded_keyflex_info.segment5;
761: l_termination_reason := lr_soft_coded_keyflex_info.segment7;