87: prd_information1
88: into
89: l_owner_tax_year
90: from
91: per_time_periods
92: where
93: payroll_id = l_owner_payroll_id
94: and
95: l_owner_date_earned between start_date and end_date;
99: prd_information1
100: into
101: l_user_tax_year
102: from
103: per_time_periods
104: where
105: payroll_id = l_user_payroll_id
106: and
107: l_user_date_earned between start_date and end_date;
260: prd_information3
261: into
262: l_owner_cal_year
263: from
264: per_time_periods
265: where
266: payroll_id = l_owner_payroll_id
267: and
268: l_owner_date_earned between start_date and end_date;
272: prd_information3
273: into
274: l_user_cal_year
275: from
276: per_time_periods
277: where
278: payroll_id = l_user_payroll_id
279: and
280: l_user_date_earned between start_date and end_date;
398: prd_information1, prd_information2
399: into
400: l_owner_tax_year, l_owner_tax_quarter
401: from
402: per_time_periods
403: where
404: payroll_id = l_owner_payroll_id
405: and
406: l_owner_date_earned between start_date and end_date;
410: prd_information1, prd_information2
411: into
412: l_user_tax_year, l_user_tax_quarter
413: from
414: per_time_periods
415: where
416: payroll_id = l_user_payroll_id
417: and
418: l_user_date_earned between start_date and end_date;
558: pay_advice_date
559: into
560: l_owner_month
561: from
562: per_time_periods
563: where
564: payroll_id = l_owner_payroll_id
565: and
566: l_owner_date_earned between start_date and end_date;
570: pay_advice_date
571: into
572: l_user_month
573: from
574: per_time_periods
575: where
576: payroll_id = l_user_payroll_id
577: and
578: l_user_date_earned between start_date and end_date;
726: ) IS
727: BEGIN
728: SELECT ptp.end_date
729: INTO p_expiry_information
730: FROM per_time_periods ptp
731: ,pay_payroll_actions ppa
732: WHERE ppa.payroll_action_id = p_owner_payroll_action_id
733: AND ppa.payroll_id = ptp.payroll_id
734: AND p_owner_effective_date BETWEEN ptp.start_date AND ptp.end_date;