APPS.GHR_SS_VIEWS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 270: p_business_group_id in per_all_assignments_f.business_group_id%type,

266: -- This function returns the currency code of an element on an effective date.
267:
268: Function retrieve_element_curr_code (p_element_name in pay_element_types_f.element_name%type,
269: p_assignment_id in pay_element_entries_f.assignment_id%type,
270: p_business_group_id in per_all_assignments_f.business_group_id%type,
271: p_effective_date in date ) return varchar2 is
272:
273: --
274: l_proc varchar2(72);

Line 683: FROM per_all_assignments_f

679: FUNCTION get_assignment_start_date(p_person_id IN NUMBER) RETURN DATE IS
680:
681: CURSOR assignement_start_date(p_person_id NUMBER) IS
682: SELECT MIN(effective_start_date) effective_start_date
683: FROM per_all_assignments_f
684: WHERE person_id = p_person_id AND
685: assignment_id =
686: (SELECT MAX(assignment_id)
687: FROM per_all_assignments_f

Line 687: FROM per_all_assignments_f

683: FROM per_all_assignments_f
684: WHERE person_id = p_person_id AND
685: assignment_id =
686: (SELECT MAX(assignment_id)
687: FROM per_all_assignments_f
688: WHERE person_id = p_person_id AND assignment_type in ('E','C')) AND
689: assignment_type in ('E','C');
690: l_ass_st_date DATE;
691: BEGIN

Line 706: from per_all_assignments_f

702: Function get_assignment_end_date(p_person_id in number) return date is
703:
704: cursor assignement_end_date (p_person_id number) is
705: select max(effective_end_date) effective_end_date
706: from per_all_assignments_f
707: where person_id = p_person_id and
708: assignment_type in ('E','C') ;
709: l_ass_end_date date;
710: Begin