APPS.PAY_FR_SICKNESS_CALC dependencies on PER_CONTACT_RELATIONSHIPS

Line 899: FROM per_contact_relationships

895: -- Cursor for selecting no. of depedents on a person
896: -- as on the parent absence date
897: Cursor csr_dependent(c_person_id NUMBER,c_abs_start_date DATE) IS
898: SELECT count(*)
899: FROM per_contact_relationships
900: WHERE person_id = c_person_id
901: AND business_group_id = p_business_group_id
902: AND c_abs_start_date BETWEEN nvl(date_start, hr_general.start_of_time) and nvl(date_end, hr_general.end_of_time)
903: AND dependent_flag ='Y';