APPS.HXC_FF_DICT dependencies on PER_ASSIGNMENTS_F

Line 28: l_assignment_id per_assignments_f.assignment_id%TYPE;

24: l_outputs ff_exec.outputs_t;
25:
26: l_proc varchar2(72);
27:
28: l_assignment_id per_assignments_f.assignment_id%TYPE;
29:
30: CURSOR csr_get_asg_id IS
31: SELECT asg.assignment_id
32: FROM per_assignments_f asg

Line 32: FROM per_assignments_f asg

28: l_assignment_id per_assignments_f.assignment_id%TYPE;
29:
30: CURSOR csr_get_asg_id IS
31: SELECT asg.assignment_id
32: FROM per_assignments_f asg
33: WHERE asg.person_id = p_resource_id
34: AND p_submission_date BETWEEN
35: asg.effective_start_date AND asg.effective_end_date
36: AND asg.primary_flag = 'Y'

Line 856: FROM per_assignments_f asg

852: l_submission_date DATE;
853:
854: CURSOR csr_get_first_asg_date ( p_resource_id NUMBER ) IS
855: SELECT MIN( asg.effective_start_date)
856: FROM per_assignments_f asg
857: WHERE asg.person_id = p_resource_id
858: AND asg.primary_flag = 'Y'
859: AND asg.assignment_type in ('E','C');
860: