[Home] [Help]
29: l_date_earned date;
30: l_start_date date;
31: l_end_date date;
32: l_date_paid date;
33: l_period_type per_time_periods.period_type%type;
34: l_days_since_hired number;
35: l_frequency number;
36:
37: BEGIN -- main
49: ptp.end_date,ppa.effective_date date_paid, ptp.period_type
50: into l_period_number,l_payroll_id, l_start_date,
51: l_end_date,l_date_paid, l_period_type
52: from per_time_period_types pty,
53: per_time_periods ptp,
54: pay_payroll_actions ppa
55: where ppa.payroll_action_id = p_pact_id
56: and ptp.time_period_id = ppa.time_period_id
57: and pty.period_type = ptp.period_type;
91:
92:
93: -- following query can raise an exception if the payroll is not defined as of the hire date
94: select ptp.period_num into l_period_number
95: from per_time_periods ptp
96: where ptp.payroll_id = l_payroll_id
97: and l_hire_date between ptp.start_date and ptp.end_date;
98:
99: /* Return the difference in the paid period number and the hired period number */