DBA Data[Home] [Help]

APPS.PAY_PAYACVEA_PKG dependencies on HR_UTILITY

Line 60: hr_utility.set_location('pay_payacvea_pkg.get_dates', 1);

56: and ptp.payroll_id = p_payroll_id;
57: --
58: -- get the period start date
59: --
60: hr_utility.set_location('pay_payacvea_pkg.get_dates', 1);
61: select greatest(ptp1.start_date, ptp2.start_date)
62: into p_start_date
63: from per_time_periods ptp1,
64: per_time_periods ptp2

Line 99: hr_utility.set_location('pay_payacvea_pkg.get_dates', 3);

95: *****
96: -- now get the end date of the period in which the element is no longer
97: -- effective; this may return no value
98: --
99: hr_utility.set_location('pay_payacvea_pkg.get_dates', 3);
100: begin
101: select ptp1.end_date
102: into l_end_date
103: from per_time_periods ptp1

Line 130: hr_utility.set_location('pay_payacvea_pkg.get_dates', 4);

126: --
127: -- ...and now the period in which the employee's period of service ends
128: --
129: l_end_date := null;
130: hr_utility.set_location('pay_payacvea_pkg.get_dates', 4);
131: begin
132: select ptp1.end_date
133: into l_end_date
134: from per_time_periods ptp1