APPS.PAY_AU_TERMINATIONS dependencies on PER_TIME_PERIODS

Line 629: , per_time_periods PERIOD

625: and result.status <> 'U'
626: and exists ( select 1
627: from pay_assignment_actions ASGT_ACTION
628: , pay_payroll_actions PAY_ACTION
629: , per_time_periods PERIOD
630: where result.assignment_action_id = asgt_action.assignment_action_id
631: and asgt_action.payroll_action_id = pay_action.payroll_action_id
632: and pay_action.payroll_id = period.payroll_id
633: and pay_action.date_earned between period.start_date and period.end_date

Line 1481: from per_time_periods ptp

1477: c_start_date in date,
1478: c_end_date in date)
1479: is
1480: select count(DISTINCT ptp.time_period_id)
1481: from per_time_periods ptp
1482: where exists (select 'EXISTS' from
1483: per_assignments_f paf,
1484: hr_soft_coding_keyflex hsck
1485: where paf.assignment_id = p_assignment_id

Line 3227: per_time_periods ptp,

3223: 'Statutory Paid Parental Leave Payment' , to_date(peev2.screen_entry_value, 'YYYY/MM/DD HH24:MI:SS')))-decode(pet.element_name, 'Rec Statutory PPL Payment',
3224: greatest(to_date(peev1.screen_entry_value, 'YYYY/MM/DD HH24:MI:SS'), ptp.start_date),
3225: 'Statutory Paid Parental Leave Payment' ,to_date(peev1.screen_entry_value, 'YYYY/MM/DD HH24:MI:SS'))),0)
3226: from
3227: per_time_periods ptp,
3228: per_all_assignments_f paa,
3229: pay_assignment_actions pac,
3230: pay_payroll_actions ppa,
3231: pay_element_entries_f pee,