APPS.PAY_ORG_PAY_METH_USAGES_F_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 55: from pay_all_payrolls_f prl

51: -- Get payroll end date
52: begin
53: select max(prl.effective_end_date)
54: into v_max_payroll_end_date
55: from pay_all_payrolls_f prl
56: where prl.payroll_id = p_payroll_id;
57: exception
58: when no_data_found then
59: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 159: from pay_all_payrolls_f prl

155: p_validation_start_date date,
156: p_validation_end_date date
157: ) is
158: select prl.payroll_id
159: from pay_all_payrolls_f prl
160: where prl.payroll_id = p_payroll_id
161: and prl.default_payment_method_id = p_org_payment_method_id
162: and prl.effective_start_date <= p_validation_end_date
163: and prl.effective_end_date >= p_validation_start_date;