DBA Data[Home] [Help]

APPS.PAY_NL_GENERAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 1670: FROM per_all_assignments_f paf

1666: FUNCTION chk_multiple_assignments(p_effective_date IN DATE
1667: ,p_person_id IN NUMBER) RETURN VARCHAR2 AS
1668: CURSOR get_multiple_assgts IS
1669: SELECT count(DISTINCT paf.assignment_id)
1670: FROM per_all_assignments_f paf
1671: ,per_assignment_status_types pas
1672: WHERE paf.assignment_type = 'E'
1673: AND paf.PERSON_ID = p_person_id
1674: AND p_effective_date between effective_start_date and effective_end_date