APPS.PAY_KW_GENERAL dependencies on PER_ALL_ASSIGNMENTS_F

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

43: -- This function return NOMATCH If the value for HR: Local Nationality
44: -- Profile does not match with the person's nationality else it retuns MATCH.
45: ------------------------------------------------------------------------
46: function local_nationality_matches
47: (p_assignment_id IN per_all_assignments_f.assignment_id%type,
48: p_date_earned IN Date)
49: return varchar2
50: is
51: begin

Line 55: From PER_ALL_ASSIGNMENTS_F

51: begin
52: BEGIN
53: Select person_id
54: Into l_person_id
55: From PER_ALL_ASSIGNMENTS_F
56: Where ASSIGNMENT_ID = p_assignment_id
57: AND p_date_earned between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
58: EXCEPTION
59: WHEN no_data_found Then

Line 249: FROM per_all_assignments_f paf

245: FUNCTION chk_multiple_assignments(p_effective_date IN DATE
246: ,p_person_id IN NUMBER) RETURN VARCHAR2 AS
247: CURSOR get_multiple_assgts IS
248: SELECT count(DISTINCT paf.assignment_id)
249: FROM per_all_assignments_f paf
250: ,per_assignment_status_types pas
251: WHERE paf.assignment_type = 'E'
252: AND paf.PERSON_ID = p_person_id
253: AND p_effective_date between effective_start_date and effective_end_date