[Home] [Help]
70: ( p_assignment_id number
71: , p_upload_date date) is
72: select p_upload_date - 28
73: from per_assignments_f paf
74: , per_time_periods ptp
75: where paf.assignment_id = p_assignment_id
76: and ptp.payroll_id = paf.payroll_id
77: and p_upload_date between ptp.start_date and ptp.end_date
78: and p_upload_date between paf.effective_start_date and paf.effective_end_date;
83: ( p_assignment_id number
84: , p_upload_date date) is
85: select hr_nz_routes.fiscal_span_start( p_upload_date, 1, paf.business_group_id )
86: from per_assignments_f paf
87: , per_time_periods ptp
88: where paf.assignment_id = p_assignment_id
89: and ptp.payroll_id = paf.payroll_id
90: and p_upload_date between ptp.start_date and ptp.end_date
91: and p_upload_date between paf.effective_start_date and paf.effective_end_date;
96: ( p_assignment_id number
97: , p_upload_date date) is
98: select hr_nz_routes.fiscal_span_start( p_upload_date, 4, paf.business_group_id )
99: from per_assignments_f paf
100: , per_time_periods ptp
101: where paf.assignment_id = p_assignment_id
102: and ptp.payroll_id = paf.payroll_id
103: and p_upload_date between ptp.start_date and ptp.end_date
104: and p_upload_date between paf.effective_start_date and paf.effective_end_date;
108: cursor csr_period_start
109: ( p_assignment_id number
110: , p_upload_date date) is
111: select nvl(ptp.start_date, end_of_time)
112: from per_time_periods ptp
113: , per_assignments_f paf
114: where paf.assignment_id = p_assignment_id
115: and p_upload_date between paf.effective_start_date and paf.effective_end_date
116: and ptp.payroll_id = paf.payroll_id
123: , p_upload_date date) is
124: select nvl(greatest(min(ptp.start_date), min(paf.effective_start_date)),end_of_time)
125: , paf.business_group_id
126: from per_assignments_f paf
127: , per_time_periods ptp
128: where paf.assignment_id = p_assignment_id
129: and paf.payroll_id = ptp.payroll_id
130: and paf.effective_start_date <= p_upload_date
131: and ptp.start_date <= p_upload_date
138: , p_upload_date date
139: , p_expiry_date date) is
140: select nvl(greatest(min(paf.effective_start_date), p_expiry_date), end_of_time)
141: from per_assignments_f paf
142: , per_time_periods ptp
143: where paf.assignment_id = p_assignment_id
144: and ptp.payroll_id = paf.payroll_id
145: and p_upload_date between ptp.start_date and ptp.end_date
146: and paf.effective_start_date <= p_upload_date