DBA Data[Home] [Help]

APPS.PAY_PAY_BUS dependencies on PAY_PAYROLLS_F

Line 1274: from pay_payrolls_f prl

1270: select prl.payroll_name
1271: ,prl.number_of_years
1272: ,min(effective_start_date) min_payroll_start_date
1273: ,max(prl.effective_end_date) max_payroll_end_date
1274: from pay_payrolls_f prl
1275: where prl.payroll_id = p_payroll_id
1276: group by prl.payroll_name, prl.number_of_years;
1277: --
1278: l_values_rec csr_current_values%rowtype;

Line 1341: pay_payrolls_f_pkg.chk_payroll_unique

1337: ) is
1338: --
1339: begin
1340: --
1341: pay_payrolls_f_pkg.chk_payroll_unique
1342: (p_payroll_id
1343: ,p_payroll_name
1344: ,p_business_group_id
1345: );

Line 2034: pay_payrolls_f_pkg.validate_delete_payroll

2030: );
2031: --
2032: --Added to check for the other validations.
2033: --
2034: pay_payrolls_f_pkg.validate_delete_payroll
2035: ( p_payroll_id => p_rec.payroll_id
2036: ,p_default_payment_method_id => pay_pay_shd.g_old_rec.default_payment_method_id
2037: ,p_dt_delete_mode => p_datetrack_mode
2038: ,p_validation_start_date => p_validation_start_date