APPS.SSP_ERN_BUS dependencies on PER_TIME_PERIODS

Line 137: per_time_periods PERIOD,

133: select /*+ ORDERED USE_NL(RUN_VALUE, RUN_RESULT, FEED, BALANCE) */
134: nvl (sum (nvl (run_value.result_value, 0) * feed.scale),0) EARNINGS
135: from pay_assignment_actions ASG_ACTION,
136: pay_payroll_actions PAY_ACTION,
137: per_time_periods PERIOD,
138: pay_balance_types BALANCE,
139: pay_balance_feeds_f FEED,
140: pay_run_results RUN_RESULT,
141: pay_run_result_values RUN_VALUE

Line 220: from per_time_periods PERIOD

216: -- end of the week of the effective date for Maternities.
217: --
218:
219: select max (period.end_date)
220: from per_time_periods PERIOD
221: where period.payroll_id = L_PAYROLL_ID
222: and period.regular_payment_date <= P_EFFECTIVE_DATE +6;
223:
224: --

Line 238: from per_time_periods ptp

234: -- The cursor csr_end_period_m would return null, which is incorrect.
235:
236:
237: select max(ptp.end_date)
238: from per_time_periods ptp
239: where ptp.payroll_id in
240: ( select papf.payroll_id
241: from pay_all_payrolls_f papf,
242: per_all_assignments_f paf,

Line 244: per_time_periods ptp

240: ( select papf.payroll_id
241: from pay_all_payrolls_f papf,
242: per_all_assignments_f paf,
243: per_all_people_f ppf,
244: per_time_periods ptp
245: where ppf.person_id = paf.person_id
246: and papf.payroll_id = paf.payroll_id
247: and paf.payroll_id = ptp.payroll_id
248: and ptp.regular_payment_date <=

Line 259: from per_time_periods PERIOD

255: -- Get the end date of the last payroll period prior to the
256: -- end of the week of the effective date for Sicknesses.
257: --
258: select max (period.end_date)
259: from per_time_periods PERIOD
260: where period.payroll_id = L_PAYROLL_ID
261: and period.regular_payment_date <= P_EFFECTIVE_DATE;
262:
263: --

Line 275: from per_time_periods ptp

271: -- payroll runs and the employee is going on a leave.
272: -- The cursor csr_end_period_s would return null, which is incorrect.
273:
274: select max(ptp.end_date)
275: from per_time_periods ptp
276: where ptp.payroll_id in
277: ( select papf.payroll_id
278: from pay_all_payrolls_f papf,
279: per_all_assignments_f paf,

Line 281: per_time_periods ptp

277: ( select papf.payroll_id
278: from pay_all_payrolls_f papf,
279: per_all_assignments_f paf,
280: per_all_people_f ppf,
281: per_time_periods ptp
282: where ppf.person_id = paf.person_id
283: and papf.payroll_id = paf.payroll_id
284: and paf.payroll_id = ptp.payroll_id
285: and ptp.regular_payment_date <=

Line 296: from per_time_periods PERIOD

292: -- Get the start date of the payroll period which was at least
293: -- 8 weeks prior to the end of the relevant period.
294: --
295: select max (period.end_date) +1
296: from per_time_periods PERIOD
297: where period.payroll_id = L_PAYROLL_ID
298: and period.end_date <= L_END_OF_RELEVANT_PERIOD - 56;
299: --
300: -- Cursor to return the payroll_id, as is no longer returned in