APPS.HR_MEE_VIEWS_GEN dependencies on PER_PEOPLE_F

Line 828: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)

824: IS
825:
826: ln_result NUMBER;
827:
828: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)
829: IS
830: SELECT count(att.absence_attendance_id) total_number_of_absences
831: FROM per_absence_attendances att
832: WHERE att.person_id = p_person_id;

Line 869: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)

865: IS
866:
867: ln_result NUMBER;
868:
869: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)
870: IS
871: SELECT sum(NVL(att.absence_days,0)) total_absence_days
872: FROM per_absence_attendances att
873: WHERE att.person_id = p_person_id;

Line 909: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)

905: IS
906:
907: ln_result NUMBER;
908:
909: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)
910: IS
911: SELECT sum(NVL(att.absence_hours,0)) total_absence_hours
912: FROM per_absence_attendances att
913: WHERE att.person_id = p_person_id;

Line 946: CURSOR c_yos (p_person_id IN per_people_f.person_id%TYPE)

942: RETURN NUMBER
943: IS
944: ln_result NUMBER:=0;
945:
946: CURSOR c_yos (p_person_id IN per_people_f.person_id%TYPE)
947: IS
948: SELECT ROUND(SUM(MONTHS_BETWEEN(
949: decode(sign(p_eff_date-nvl(actual_termination_date, p_eff_date)),
950: -1, trunc(p_eff_date), nvl(actual_termination_date, trunc(p_eff_date))),

Line 1013: CURSOR c_ayos (p_person_id IN per_people_f.person_id%TYPE)

1009: RETURN NUMBER
1010: IS
1011: ln_result NUMBER;
1012:
1013: CURSOR c_ayos (p_person_id IN per_people_f.person_id%TYPE)
1014: IS
1015: SELECT ROUND(MONTHS_BETWEEN(
1016: decode(sign(p_eff_date-nvl(actual_termination_date, p_eff_date)),
1017: -1, trunc(p_eff_date), nvl(actual_termination_date, trunc(p_eff_date))),

Line 1058: CURSOR lc_get_lad (p_person_id IN per_people_f.person_id%TYPE)

1054: IS
1055:
1056: ln_result DATE;
1057:
1058: CURSOR lc_get_lad (p_person_id IN per_people_f.person_id%TYPE)
1059: IS
1060: SELECT MAX(pa.date_received)
1061: FROM per_applications pa,
1062: per_assignments_f ass

Line 1089: CURSOR c_classes (p_person_id IN per_people_f.person_id%TYPE)

1085: RETURN NUMBER
1086: IS
1087: ln_result NUMBER:= 0;
1088:
1089: CURSOR c_classes (p_person_id IN per_people_f.person_id%TYPE)
1090: IS
1091: SELECT count(db.booking_id)
1092: FROM ota_booking_status_types bst,
1093: ota_events evt, ota_delegate_bookings db

Line 1170: CURSOR lc_get_other_classes (p_person_id IN per_people_f.person_id%TYPE)

1166: IS
1167:
1168: ln_result NUMBER;
1169:
1170: CURSOR lc_get_other_classes (p_person_id IN per_people_f.person_id%TYPE)
1171: IS
1172: SELECT count(tdb.booking_id)
1173: FROM ota_booking_status_types bst,
1174: ota_delegate_bookings tdb

Line 1400: ln_business_group_id per_people_f.business_group_id%TYPE;

1396: ln_flex_num NUMBER;
1397: lv_flex_code VARCHAR2(3) := 'JOB';
1398: lv_result VARCHAR2(240) DEFAULT NULL;
1399: ltt_segment hr_mee_views_gen.segmentsTable;
1400: ln_business_group_id per_people_f.business_group_id%TYPE;
1401:
1402: BEGIN
1403:
1404: --First Get the name from per_jobs and all the segments

Line 1550: ln_business_group_id per_people_f.business_group_id%TYPE;

1546: ln_flex_num NUMBER;
1547: lv_flex_code VARCHAR2(3) := 'GRD';
1548: lv_result VARCHAR2(240) DEFAULT NULL;
1549: ltt_segment hr_mee_views_gen.segmentsTable;
1550: ln_business_group_id per_people_f.business_group_id%TYPE;
1551:
1552: BEGIN
1553:
1554: --First Get the name from per_grades and all the segments

Line 1706: ln_business_group_id per_people_f.business_group_id%TYPE;

1702: ln_flex_num NUMBER;
1703: lv_flex_code VARCHAR2(3) := 'POS';
1704: lv_result VARCHAR2(240) DEFAULT NULL;
1705: ltt_segment hr_mee_views_gen.segmentsTable;
1706: ln_business_group_id per_people_f.business_group_id%TYPE;
1707:
1708: BEGIN
1709:
1710: --First Get the name from per_positions and all the segments