APPS.PAY_NZ_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 73: from per_assignments_f paf

69: cursor csr_asg_4week
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

Line 86: from per_assignments_f paf

82: cursor csr_fiscal_year
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

Line 99: from per_assignments_f paf

95: cursor csr_fiscal_quarter
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

Line 113: , per_assignments_f paf

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
117: and p_upload_date between ptp.start_date and ptp.end_date;

Line 126: from per_assignments_f paf

122: ( p_assignment_id number
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

Line 141: from per_assignments_f paf

137: ( p_assignment_id number
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

Line 161: l_business_group_id per_assignments_f.business_group_id%type;

157: l_asg_start_date date; -- earliest date on which the assignment exists.
158: l_asg_4week_start date; -- start of 4 weeks prior to upload date
159: l_start_date date;
160: l_anniversary_date date; -- start date of the last anniversary
161: l_business_group_id per_assignments_f.business_group_id%type;
162: --
163: begin
164: --
165: -- get the earliest effective date that the assignment can exist