APPS.HRASSACT dependencies on PER_TIME_PERIODS

Line 4732: per_time_periods ptp

4728: and not exists (
4729: select null
4730: from pay_payroll_actions pa2,
4731: pay_assignment_actions ac2,
4732: per_time_periods ptp
4733: where ac2.assignment_id = asg.assignment_id
4734: and pa2.payroll_action_id = ac2.payroll_action_id
4735: and ptp.payroll_id = pac.payroll_id
4736: and pac.effective_date between ptp.start_date and ptp.end_date

Line 4834: per_time_periods ptp

4830: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4831: from pay_assignment_actions ac2,
4832: pay_payroll_actions pa2,
4833: pay_object_groups pog2,
4834: per_time_periods ptp
4835: where pog2.parent_object_group_id = pog.parent_object_group_id
4836: and ac2.assignment_id = pog2.source_id
4837: and pa2.payroll_action_id = ac2.payroll_action_id
4838: and ptp.payroll_id = pac.payroll_id

Line 4942: per_time_periods ptp

4938: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4939: from pay_assignment_actions ac2,
4940: pay_payroll_actions pa2,
4941: per_all_assignments_f as2,
4942: per_time_periods ptp
4943: where as2.period_of_service_id = pos.period_of_service_id
4944: and ac2.assignment_id = as2.assignment_id
4945: and pa2.payroll_action_id = ac2.payroll_action_id
4946: and ptp.payroll_id = pac.payroll_id

Line 6715: index(ptp PER_TIME_PERIODS_N50) */

6711: end if;
6712: select /*+ ordered use_nl(pee asg ptp pbg)
6713: index(pee PAY_ELEMENT_ENTRIES_F_PK)
6714: index(asg PER_ASSIGNMENTS_F_PK)
6715: index(ptp PER_TIME_PERIODS_N50) */
6716: pay_payroll_actions_s.nextval,
6717: asg.business_group_id,
6718: pbg.legislation_code,
6719: asg.assignment_id,

Line 6736: per_time_periods ptp,

6732: creatdate,
6733: l_original_entry_id
6734: from pay_element_entries_f pee,
6735: per_all_assignments_f asg,
6736: per_time_periods ptp,
6737: per_business_groups_perf pbg
6738: where pee.element_entry_id = eentryid
6739: and effdate between
6740: pee.effective_start_date and pee.effective_end_date

Line 6756: from per_time_periods pt2

6752: if (csr_time_period_leg%found) then
6753: close csr_time_period_leg;
6754: select pt2.time_period_id, pt2.end_date
6755: into tperiod, dtearned
6756: from per_time_periods pt2
6757: where pt2.time_period_id in
6758: (select min(time_period_id)
6759: from per_time_periods ptp
6760: where ptp.payroll_id = payid

Line 6759: from per_time_periods ptp

6755: into tperiod, dtearned
6756: from per_time_periods pt2
6757: where pt2.time_period_id in
6758: (select min(time_period_id)
6759: from per_time_periods ptp
6760: where ptp.payroll_id = payid
6761: and effdate between ptp.start_date
6762: and greatest(ptp.end_date, ptp.regular_payment_date));
6763: else