APPS.PER_HU_ASSIGN_EXTRA_INFO dependencies on PER_ALL_ASSIGNMENTS_F

Line 26: FROM per_all_assignments_f paaf,fnd_sessions fs

22: ,p_aei_information3 varchar2
23: ) IS
24: CURSOR get_assignment_type is
25: SELECT assignment_type
26: FROM per_all_assignments_f paaf,fnd_sessions fs
27: WHERE paaf.assignment_id=p_assignment_id
28: AND fs.session_id=userenv('sessionid')
29: AND fs.effective_date BETWEEN paaf.effective_start_date
30: and paaf.effective_end_date;

Line 32: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

28: AND fs.session_id=userenv('sessionid')
29: AND fs.effective_date BETWEEN paaf.effective_start_date
30: and paaf.effective_end_date;
31:
32: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
33: BEGIN
34: --
35: -- Added for GSI Bug 5472781
36: --

Line 64: FROM per_all_assignments_f paaf, fnd_sessions fs

60: ,p_aei_information3 varchar2
61: ) IS
62: CURSOR get_assignment_type is
63: SELECT assignment_type
64: FROM per_all_assignments_f paaf, fnd_sessions fs
65: WHERE paaf.assignment_id=(select assignment_id from per_assignment_extra_info
66: where assignment_extra_info_id=p_assignment_extra_info_id)
67: AND fs.session_id = userenv('sessionid')
68: AND fs.effective_date BETWEEN paaf.effective_start_date

Line 72: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

68: AND fs.effective_date BETWEEN paaf.effective_start_date
69: and paaf.effective_end_date;
70:
71:
72: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
73: BEGIN
74: --
75: -- Added for GSI Bug 5472781
76: --