APPS.PAY_PAYROLLS_F_PKG dependencies on PER_TIME_PERIODS

Line 1348: from per_time_periods tpe

1344: for update of com.comment_id;
1345:
1346: cursor csr_period_end_date is
1347: select max(tpe.end_date), min(tpe.start_date)
1348: from per_time_periods tpe
1349: where tpe.payroll_id = p_payroll_id;
1350: --
1351: l_last_period_end_date date;
1352: l_first_period_start_date date;

Line 1358: delete from per_time_periods tpe

1354: begin
1355: --
1356: if p_dt_delete_mode = 'ZAP' then
1357: --
1358: delete from per_time_periods tpe
1359: where tpe.payroll_id = p_payroll_id;
1360: --
1361: delete from pay_org_pay_method_usages_f opu
1362: where opu.payroll_id = p_payroll_id;

Line 1423: delete from per_time_periods tpe

1419: and opu.effective_end_date >= p_validation_start_date;
1420: --
1421: -- Only time periods that fit completely within the lifetime of the
1422: -- payroll are valid.
1423: delete from per_time_periods tpe
1424: where tpe.payroll_id = p_payroll_id
1425: and tpe.end_date >= p_validation_start_date;
1426:
1427: Open csr_period_end_date;