APPS.HR_MEE_VIEWS_GEN dependencies on PER_PEOPLE_F

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

867: IS
868:
869: ln_result NUMBER;
870:
871: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)
872: IS
873: SELECT count(att.absence_attendance_id) total_number_of_absences
874: FROM per_absence_attendances att
875: WHERE att.person_id = p_person_id;

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

908: IS
909:
910: ln_result NUMBER;
911:
912: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)
913: IS
914: SELECT sum(NVL(att.absence_days,0)) total_absence_days
915: FROM per_absence_attendances att
916: WHERE att.person_id = p_person_id;

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

948: IS
949:
950: ln_result NUMBER;
951:
952: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)
953: IS
954: SELECT sum(NVL(att.absence_hours,0)) total_absence_hours
955: FROM per_absence_attendances att
956: WHERE att.person_id = p_person_id;

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

985: RETURN NUMBER
986: IS
987: ln_result NUMBER:=0;
988:
989: CURSOR c_yos (p_person_id IN per_people_f.person_id%TYPE)
990: IS
991: SELECT ROUND(SUM(MONTHS_BETWEEN(
992: decode(sign(p_eff_date-nvl(actual_termination_date, p_eff_date)),
993: -1, trunc(p_eff_date), nvl(actual_termination_date, trunc(p_eff_date))),

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

1052: RETURN NUMBER
1053: IS
1054: ln_result NUMBER;
1055:
1056: CURSOR c_ayos (p_person_id IN per_people_f.person_id%TYPE)
1057: IS
1058: SELECT ROUND(MONTHS_BETWEEN(
1059: decode(sign(p_eff_date-nvl(actual_termination_date, p_eff_date)),
1060: -1, trunc(p_eff_date), nvl(actual_termination_date, trunc(p_eff_date))),

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

1097: IS
1098:
1099: ln_result DATE;
1100:
1101: CURSOR lc_get_lad (p_person_id IN per_people_f.person_id%TYPE)
1102: IS
1103: SELECT MAX(pa.date_received)
1104: FROM per_applications pa,
1105: per_assignments_f ass

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

1128: RETURN NUMBER
1129: IS
1130: ln_result NUMBER:= 0;
1131:
1132: CURSOR c_classes (p_person_id IN per_people_f.person_id%TYPE)
1133: IS
1134: SELECT count(db.booking_id)
1135: FROM ota_booking_status_types bst,
1136: ota_events evt, ota_delegate_bookings db

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

1209: IS
1210:
1211: ln_result NUMBER;
1212:
1213: CURSOR lc_get_other_classes (p_person_id IN per_people_f.person_id%TYPE)
1214: IS
1215: SELECT count(tdb.booking_id)
1216: FROM ota_booking_status_types bst,
1217: ota_delegate_bookings tdb

Line 1443: ln_business_group_id per_people_f.business_group_id%TYPE;

1439: ln_flex_num NUMBER;
1440: lv_flex_code VARCHAR2(3) := 'JOB';
1441: lv_result VARCHAR2(240) DEFAULT NULL;
1442: ltt_segment hr_mee_views_gen.segmentsTable;
1443: ln_business_group_id per_people_f.business_group_id%TYPE;
1444:
1445: BEGIN
1446:
1447: --First Get the name from per_jobs and all the segments

Line 1593: ln_business_group_id per_people_f.business_group_id%TYPE;

1589: ln_flex_num NUMBER;
1590: lv_flex_code VARCHAR2(3) := 'GRD';
1591: lv_result VARCHAR2(240) DEFAULT NULL;
1592: ltt_segment hr_mee_views_gen.segmentsTable;
1593: ln_business_group_id per_people_f.business_group_id%TYPE;
1594:
1595: BEGIN
1596:
1597: --First Get the name from per_grades and all the segments

Line 1749: ln_business_group_id per_people_f.business_group_id%TYPE;

1745: ln_flex_num NUMBER;
1746: lv_flex_code VARCHAR2(3) := 'POS';
1747: lv_result VARCHAR2(240) DEFAULT NULL;
1748: ltt_segment hr_mee_views_gen.segmentsTable;
1749: ln_business_group_id per_people_f.business_group_id%TYPE;
1750:
1751: BEGIN
1752:
1753: --First Get the name from per_positions and all the segments