1928:
1929: SELECT count(1)
1930: INTO v_is_manager_present
1931: FROM per_all_assignments_f ass,
1932: fnd_user sup,
1933: fnd_user emp,
1934: per_all_people_f per
1935: WHERE ass.person_id = emp.employee_id
1936: AND ass.supervisor_id = sup.employee_id
1929: SELECT count(1)
1930: INTO v_is_manager_present
1931: FROM per_all_assignments_f ass,
1932: fnd_user sup,
1933: fnd_user emp,
1934: per_all_people_f per
1935: WHERE ass.person_id = emp.employee_id
1936: AND ass.supervisor_id = sup.employee_id
1937: AND ass.primary_flag = 'Y'