APPS.PQH_DE_LOCAL_COST_LIVING_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 39: select person_id from PER_ALL_ASSIGNMENTS_F

35:
36: -- cursor to get the Person_id for teh given Assignment_id
37:
38: cursor c_person_id (p_ASSIGNMENT_ID number,p_effective_date date) is
39: select person_id from PER_ALL_ASSIGNMENTS_F
40: where ASSIGNMENT_ID = p_ASSIGNMENT_ID
41: and p_effective_date between EFFECTIVE_START_DATE and nvl(EFFECTIVE_end_DATE,p_effective_date );
42:
43: