APPS.PER_GET_ELIG dependencies on CAC_SR_SCHEDULES_VL

Line 649: l_schedule_name cac_sr_schedules_vl.schedule_name%TYPE;

645: l_elig_obj_varray per_elig_obj_varray;
646: l_elig_obj per_elig_obj;
647: l_work_sch_obj per_work_sch_obj;
648:
649: l_schedule_name cac_sr_schedules_vl.schedule_name%TYPE;
650: l_schedule_category cac_sr_schedules_vl.schedule_category%TYPE;
651:
652: -- Cursor to fetch schedule details
653: CURSOR c_sch ( cp_schedule_id IN NUMBER

Line 650: l_schedule_category cac_sr_schedules_vl.schedule_category%TYPE;

646: l_elig_obj per_elig_obj;
647: l_work_sch_obj per_work_sch_obj;
648:
649: l_schedule_name cac_sr_schedules_vl.schedule_name%TYPE;
650: l_schedule_category cac_sr_schedules_vl.schedule_category%TYPE;
651:
652: -- Cursor to fetch schedule details
653: CURSOR c_sch ( cp_schedule_id IN NUMBER
654: , cp_start_date IN DATE

Line 659: FROM cac_sr_schedules_vl

655: , cp_end_date IN DATE
656: ) IS
657: SELECT schedule_category
658: ,schedule_name
659: FROM cac_sr_schedules_vl
660: WHERE schedule_id = cp_schedule_id
661: AND start_date_active = cp_start_date
662: AND end_date_active = cp_end_date;
663:

Line 678: , p_table_name => 'CAC_SR_SCHEDULES_VL'

674: -- Get eligible objects for the given person assignments
675: get_elig_obj_for_per_asg( p_person_id => p_person_id
676: , p_assignment_id => p_assignment_id
677: , p_effective_date => p_effective_date
678: , p_table_name => 'CAC_SR_SCHEDULES_VL'
679: , p_data_mode => p_data_mode
680: , x_eligible_object => l_elig_obj_varray
681: , x_return_status => x_return_status
682: , x_return_message => x_return_message

Line 745: l_schedule_id cac_sr_schedules_vl.schedule_id%TYPE;

741: , x_return_message OUT NOCOPY VARCHAR2
742: ) IS
743:
744: l_proc VARCHAR2(50);
745: l_schedule_id cac_sr_schedules_vl.schedule_id%TYPE;
746:
747: -- Cursor to fetch schedule identifier
748: CURSOR c_sch ( cp_schedule_category IN VARCHAR2
749: , cp_schedule_name IN VARCHAR2

Line 753: FROM cac_sr_schedules_vl

749: , cp_schedule_name IN VARCHAR2
750: , cp_effective_date IN DATE
751: ) IS
752: SELECT schedule_id
753: FROM cac_sr_schedules_vl
754: WHERE schedule_category = cp_schedule_category
755: AND schedule_name = cp_schedule_name
756: AND start_date_active <= cp_effective_date
757: AND end_date_active >= cp_effective_date;

Line 777: get_per_asg_for_elig_obj( p_table_name => 'CAC_SR_SCHEDULES_VL'

773:
774: hr_utility.set_location('SchId: '||l_schedule_id, 20);
775:
776: -- Get the person assignments
777: get_per_asg_for_elig_obj( p_table_name => 'CAC_SR_SCHEDULES_VL'
778: , p_column_name => 'SCHEDULE_ID'
779: , p_column_value => l_schedule_id
780: , p_effective_date => p_effective_date
781: , p_business_group_id => p_business_group_id