APPS.PAY_ES_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 57: ,per_assignments_f ass

53: CURSOR csr_period_start (p_assignment_id NUMBER
54: ,p_upload_date DATE) IS
55: SELECT nvl(ptp.start_date, end_of_time)
56: FROM per_time_periods ptp
57: ,per_assignments_f ass
58: WHERE ass.assignment_id = p_assignment_id
59: AND ptp.payroll_id = ass.payroll_id
60: AND p_upload_date between ass.effective_start_date and ass.effective_end_date
61: AND p_upload_date between ptp.start_date and ptp.end_date;

Line 66: FROM per_assignments_f ass

62: -- Returns the start date of the assignment.
63: CURSOR csr_asg_itd_start(p_assignment_id NUMBER
64: ,p_upload_date DATE) IS
65: SELECT nvl(min(ass.effective_start_date), end_of_time)
66: FROM per_assignments_f ass
67: WHERE ass.assignment_id = p_assignment_id
68: AND ass.payroll_id IS NOT NULL
69: AND ass.effective_start_date <= p_upload_date;
70: -- Generic start date variable.

Line 132: FROM per_assignments_f

128: IF substr(p_dimension_name, 31, 4) = 'USER' THEN
129: -- User balance
130: SELECT business_group_id
131: INTO l_business_group_id
132: FROM per_assignments_f
133: WHERE assignment_id = p_assignment_id;
134: l_expiry_date := hr_gbbal.dimension_reset_date(p_dimension_name
135: ,p_upload_date
136: ,l_business_group_id);