APPS.HR_PERSON_ABSENCE_SWI dependencies on PER_ABSENCE_ATTENDANCES

Line 543: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%type;

539: --7382975 begin
540: l_populate_sickness_dates boolean := false;
541: l_sickness_start_date date := p_sickness_start_date;
542: l_sickness_end_date date := p_sickness_end_date;
543: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%type;
544: l_business_group_id per_absence_attendances.business_group_id%type;
545:
546: Cursor c_is_gb_leg is
547: select absence_attendance_type_id, business_group_id

Line 544: l_business_group_id per_absence_attendances.business_group_id%type;

540: l_populate_sickness_dates boolean := false;
541: l_sickness_start_date date := p_sickness_start_date;
542: l_sickness_end_date date := p_sickness_end_date;
543: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%type;
544: l_business_group_id per_absence_attendances.business_group_id%type;
545:
546: Cursor c_is_gb_leg is
547: select absence_attendance_type_id, business_group_id
548: from per_absence_attendances

Line 548: from per_absence_attendances

544: l_business_group_id per_absence_attendances.business_group_id%type;
545:
546: Cursor c_is_gb_leg is
547: select absence_attendance_type_id, business_group_id
548: from per_absence_attendances
549: where absence_attendance_id = p_absence_attendance_id;
550: --7382975 End
551:
552:

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

1144: l_proc varchar2(72) := g_package ||'merge_attachments';
1145: l_rowid varchar2(50);
1146: lv_pk1_value varchar2(72) := p_absence_attendance_id||'_'||p_transaction_id ;
1147: data_error exception;
1148: lv_entity_name constant varchar2(30) := 'PER_ABSENCE_ATTENDANCES';
1149:
1150: cursor csr_get_attached_doc is
1151: select *
1152: from fnd_attached_documents