APPS.PER_US_ADD_LEG_HOOK dependencies on PER_ASSIGNMENTS_F

Line 11: l_assignment_id per_assignments_f.assignment_id%TYPE;

7: ,p_person_id in number
8: ,P_EFFECTIVE_DATE in DATE
9: )
10: AS
11: l_assignment_id per_assignments_f.assignment_id%TYPE;
12:
13: cursor csr_emp_assign(p_person_id number) is
14: select asg.assignment_id
15: from per_assignments_f asg

Line 15: from per_assignments_f asg

11: l_assignment_id per_assignments_f.assignment_id%TYPE;
12:
13: cursor csr_emp_assign(p_person_id number) is
14: select asg.assignment_id
15: from per_assignments_f asg
16: where asg.person_id = p_person_id
17: and asg.assignment_type='E'
18: and asg.payroll_id is not null /*bug 10008870 */
19: and p_effective_date between asg.effective_start_date

Line 57: l_assignment_id per_assignments_f.assignment_id%TYPE;

53: ,P_EFFECTIVE_DATE in DATE
54: )
55: AS
56:
57: l_assignment_id per_assignments_f.assignment_id%TYPE;
58:
59: cursor csr_emp_assign(p_address_id number) is
60: select asg.assignment_id
61: from per_assignments_f asg,

Line 61: from per_assignments_f asg,

57: l_assignment_id per_assignments_f.assignment_id%TYPE;
58:
59: cursor csr_emp_assign(p_address_id number) is
60: select asg.assignment_id
61: from per_assignments_f asg,
62: per_addresses padd
63: where asg.person_id = padd.person_id
64: and padd.address_id = p_address_id
65: and asg.assignment_type='E'