APPS.PAY_SA_GENERAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 32: (p_assignment_id IN per_all_assignments_f.assignment_id%type,

28: -- This function return NOMATCH If the value for HR: Local Nationality
29: -- Profile does not match with the person's nationality else it retuns MATCH.
30: ------------------------------------------------------------------------
31: function local_nationality_matches
32: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
33: p_date_earned IN Date)
34: return varchar2
35: is
36: l_person_id number;

Line 44: From PER_ALL_ASSIGNMENTS_F

40:
41: BEGIN
42: Select person_id
43: Into l_person_id
44: From PER_ALL_ASSIGNMENTS_F
45: Where ASSIGNMENT_ID = p_assignment_id
46: AND p_date_earned between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
47: EXCEPTION
48: WHEN no_data_found Then

Line 175: FROM per_all_assignments_f paf

171: FUNCTION chk_multiple_assignments(p_effective_date IN DATE
172: ,p_person_id IN NUMBER) RETURN VARCHAR2 AS
173: CURSOR get_multiple_assgts IS
174: SELECT count(DISTINCT paf.assignment_id)
175: FROM per_all_assignments_f paf
176: ,per_assignment_status_types pas
177: WHERE paf.assignment_type = 'E'
178: AND paf.PERSON_ID = p_person_id
179: AND p_effective_date between effective_start_date and effective_end_date