DBA Data[Home] [Help]

APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on HR_GENERAL

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

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

Line 717: hr_general.decode_position_latest_name

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

Line 755: hr_general.decode_lookup ('LEAV_REAS'

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