DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on PER_TIME_PERIODS

Line 545: , per_time_periods PERIOD

541: and result.status <> 'U'
542: and exists ( select 1
543: from pay_assignment_actions ASGT_ACTION
544: , pay_payroll_actions PAY_ACTION
545: , per_time_periods PERIOD
546: where result.assignment_action_id = asgt_action.assignment_action_id
547: and asgt_action.payroll_action_id = pay_action.payroll_action_id
548: and pay_action.payroll_id = period.payroll_id
549: and pay_action.date_earned between period.start_date and period.end_date

Line 1385: from per_time_periods ptp

1381: c_start_date in date,
1382: c_end_date in date)
1383: is
1384: select count(DISTINCT ptp.time_period_id)
1385: from per_time_periods ptp
1386: where exists (select 'EXISTS' from
1387: per_assignments_f paf,
1388: hr_soft_coding_keyflex hsck
1389: where paf.assignment_id = p_assignment_id