APPS.HR_PERSON_ABSENCE_SWI dependencies on PER_ABSENCE_ATTENDANCES

Line 759: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%type;

755: --7382975 begin
756: l_populate_sickness_dates boolean := false;
757: l_sickness_start_date date := p_sickness_start_date;
758: l_sickness_end_date date := p_sickness_end_date;
759: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%type;
760: l_business_group_id per_absence_attendances.business_group_id%type;
761:
762: Cursor c_is_gb_leg is
763: select absence_attendance_type_id, business_group_id

Line 760: l_business_group_id per_absence_attendances.business_group_id%type;

756: l_populate_sickness_dates boolean := false;
757: l_sickness_start_date date := p_sickness_start_date;
758: l_sickness_end_date date := p_sickness_end_date;
759: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%type;
760: l_business_group_id per_absence_attendances.business_group_id%type;
761:
762: Cursor c_is_gb_leg is
763: select absence_attendance_type_id, business_group_id
764: from per_absence_attendances

Line 764: from per_absence_attendances

760: l_business_group_id per_absence_attendances.business_group_id%type;
761:
762: Cursor c_is_gb_leg is
763: select absence_attendance_type_id, business_group_id
764: from per_absence_attendances
765: where absence_attendance_id = p_absence_attendance_id;
766: --7382975 End
767:
768: lv_PERSON_ID number;

Line 803: select date_start into l_date_start from per_absence_attendances where

799: -- Bug 6347488,8671547 fix starts
800:
801: if p_date_start is null or p_date_start = hr_api.g_date then
802:
803: select date_start into l_date_start from per_absence_attendances where
804: absence_attendance_id = p_absence_attendance_id;
805:
806: if(l_date_start) is null then
807: p_absence_days := null;

Line 1022: from per_absence_attendances

1018:
1019: select PERSON_ID,BUSINESS_GROUP_ID,DATE_START,DATE_END,TIME_START,TIME_END,DATE_PROJECTED_START,DATE_PROJECTED_END,TIME_PROJECTED_START,TIME_PROJECTED_END
1020: into
1021: lv_PERSON_ID,lv_BUSINESS_GROUP_ID,lv_DATE_START,lv_DATE_END,lv_TIME_START,lv_TIME_END,lv_DATE_PROJECTED_START,lv_DATE_PROJECTED_END,lv_TIME_PROJECTED_START,lv_TIME_PROJECTED_END
1022: from per_absence_attendances
1023: where ABSENCE_ATTENDANCE_ID = p_absence_attendance_id;
1024: end;
1025:
1026: l_abs_overlap_warning := chk_overlap(lv_PERSON_ID,lv_BUSINESS_GROUP_ID,nvl(nvl(p_date_start,p_date_projected_start),nvl(lv_DATE_START,lv_DATE_PROJECTED_START)),nvl(nvl(p_date_end,p_date_projected_end),

Line 1428: lv_entity_name constant varchar2(30) := 'PER_ABSENCE_ATTENDANCES';

1424: l_proc varchar2(72) := g_package ||'merge_attachments';
1425: l_rowid varchar2(50);
1426: lv_pk1_value varchar2(72) := p_absence_attendance_id||'_'||p_transaction_id ;
1427: data_error exception;
1428: lv_entity_name constant varchar2(30) := 'PER_ABSENCE_ATTENDANCES';
1429:
1430: cursor csr_get_attached_doc is
1431: select *
1432: from fnd_attached_documents

Line 1523: from per_absence_attendances

1519: lv_action varchar2(30);
1520:
1521: Cursor c_get_dur(p_absence_attendance_id number) is
1522: select absence_days, absence_hours
1523: from per_absence_attendances
1524: where absence_attendance_id = p_absence_attendance_id;
1525:
1526: --Fix for Bug 14560350 start
1527: l_msg_count number;