eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_POSITION_CONTROL_PVT dependencies on PER_TIME_PERIODS

Line 10202: from per_time_periods pt, pqh_psb_budgets pb

10198: and end_time_period_id = end_period_id;
10199:
10200: cursor c_time_periods (startdate DATE) is
10201: select pt.time_period_id, pt.start_date, pt.end_date
10202: from per_time_periods pt, pqh_psb_budgets pb
10203: where pb.budget_id = p_hr_budget_id
10204: and pt.period_set_name = pb.period_set_name
10205: and startdate between pt.start_date and pt.end_date;
10206:

Line 10209: from per_time_periods pt, pqh_psb_budgets pb

10205: and startdate between pt.start_date and pt.end_date;
10206:
10207: cursor c_time_periods_br (startdate DATE, enddate DATE) is
10208: select pt.time_period_id, pt.start_date, pt.end_date
10209: from per_time_periods pt, pqh_psb_budgets pb
10210: where pb.budget_id = p_hr_budget_id
10211: and pt.period_set_name = pb.period_set_name
10212: and ((pt.start_date between startdate and enddate)
10213: or (pt.end_date between startdate and enddate)