APPS.PAY_BAL_ADJUST dependencies on PER_TIME_PERIODS

Line 326: per_time_periods ptp

322: is
323: select
324: ptp.time_period_id
325: from
326: per_time_periods ptp
327: where
328: ptp.payroll_id = p_payroll_id
329: and p_effective_date between ptp.start_date
330: and ptp.end_date;

Line 533: l_period_status per_time_periods.status%TYPE;

529: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
530: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
531: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
532: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;
533: l_period_status per_time_periods.status%TYPE;
534: l_date_on_which_time_served_ok date;
535: l_date_on_which_old_enough date;
536: l_dummy varchar2(1);
537:

Line 560: FROM per_time_periods ptp,

556: AND ee.effective_end_date;
557:
558: CURSOR c_assignment_details IS
559: SELECT ptp.status
560: FROM per_time_periods ptp,
561: per_all_assignments_f pas
562: WHERE pas.assignment_id = p_assignment_id
563: AND pas.payroll_id = ptp.payroll_id
564: AND l_effective_date BETWEEN ptp.start_date

Line 1237: from per_time_periods ptp

1233:
1234: -- Obtain the time_period_id for this batch.
1235: select ptp.time_period_id
1236: into l_timperid
1237: from per_time_periods ptp
1238: where ptp.payroll_id = l_info.payid
1239: and l_info.effdate between
1240: ptp.start_date and ptp.end_date;
1241:

Line 1441: from per_time_periods tp,per_all_assignments_f asg

1437:
1438: /*
1439: select tp.start_date,tp.end_date
1440: into l_start_date,l_end_date
1441: from per_time_periods tp,per_all_assignments_f asg
1442: where asg.assignment_id = p_assignment_id
1443: and asg.payroll_id=tp.payroll_id
1444: and p_effdate between tp.start_date and tp.end_date
1445: and p_effdate between asg.effective_start_date and asg.effective_end_date;