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 855: FROM per_assignments_f asg

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