APPS.HRASSACT dependencies on PER_TIME_PERIODS

Line 6451: index(ptp PER_TIME_PERIODS_N50) */

6447: end if;
6448: select /*+ ordered use_nl(pee asg ptp pbg)
6449: index(pee PAY_ELEMENT_ENTRIES_F_PK)
6450: index(asg PER_ASSIGNMENTS_F_PK)
6451: index(ptp PER_TIME_PERIODS_N50) */
6452: pay_payroll_actions_s.nextval,
6453: asg.business_group_id,
6454: pbg.legislation_code,
6455: asg.assignment_id,

Line 6472: per_time_periods ptp,

6468: creatdate,
6469: l_original_entry_id
6470: from pay_element_entries_f pee,
6471: per_all_assignments_f asg,
6472: per_time_periods ptp,
6473: per_business_groups_perf pbg
6474: where pee.element_entry_id = eentryid
6475: and effdate between
6476: pee.effective_start_date and pee.effective_end_date

Line 6492: from per_time_periods pt2

6488: if (csr_time_period_leg%found) then
6489: close csr_time_period_leg;
6490: select pt2.time_period_id, pt2.end_date
6491: into tperiod, dtearned
6492: from per_time_periods pt2
6493: where pt2.time_period_id in
6494: (select min(time_period_id)
6495: from per_time_periods ptp
6496: where ptp.payroll_id = payid

Line 6495: from per_time_periods ptp

6491: into tperiod, dtearned
6492: from per_time_periods pt2
6493: where pt2.time_period_id in
6494: (select min(time_period_id)
6495: from per_time_periods ptp
6496: where ptp.payroll_id = payid
6497: and effdate between ptp.start_date
6498: and greatest(ptp.end_date, ptp.regular_payment_date));
6499: else