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.PQH_PSF_BUS dependencies on PER_TIME_PERIODS

Line 2123: from pqh_budget_periods bpr, per_time_periods tp_s,

2119: and bdt.budget_version_id = bvr.budget_version_id
2120: and bdt.position_id = p_position_id;
2121: cursor c3(p_budget_detail_id number) is
2122: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
2123: from pqh_budget_periods bpr, per_time_periods tp_s,
2124: per_time_periods tp_e
2125: where bpr.budget_detail_id = p_budget_detail_id
2126: and tp_s.time_period_id = bpr.start_time_period_id
2127: and tp_e.time_period_id = bpr.end_time_period_id

Line 2124: per_time_periods tp_e

2120: and bdt.position_id = p_position_id;
2121: cursor c3(p_budget_detail_id number) is
2122: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
2123: from pqh_budget_periods bpr, per_time_periods tp_s,
2124: per_time_periods tp_e
2125: where bpr.budget_detail_id = p_budget_detail_id
2126: and tp_s.time_period_id = bpr.start_time_period_id
2127: and tp_e.time_period_id = bpr.end_time_period_id
2128: and tp_s.period_set_name = l_calendar

Line 2213: per_time_periods stp,

2209: cursor c_date is
2210: select stp.start_date
2211: from pqh_budget_periods bper,
2212: pqh_budget_details bdet,
2213: per_time_periods stp,
2214: per_time_periods etp
2215: where bper.budget_detail_id = bdet.budget_detail_id
2216: and p_position_id = bdet.position_id
2217: and bper.start_time_period_id = stp.time_period_id

Line 2214: per_time_periods etp

2210: select stp.start_date
2211: from pqh_budget_periods bper,
2212: pqh_budget_details bdet,
2213: per_time_periods stp,
2214: per_time_periods etp
2215: where bper.budget_detail_id = bdet.budget_detail_id
2216: and p_position_id = bdet.position_id
2217: and bper.start_time_period_id = stp.time_period_id
2218: and bper.end_time_period_id = etp.time_period_id

Line 2282: per_time_periods stp,

2278: cursor c_date is
2279: select stp.start_date
2280: from pqh_budget_periods bper,
2281: pqh_budget_details bdet,
2282: per_time_periods stp,
2283: per_time_periods etp
2284: where bper.budget_detail_id = bdet.budget_detail_id
2285: and p_job_id = bdet.job_id
2286: and bper.start_time_period_id = stp.time_period_id

Line 2283: per_time_periods etp

2279: select stp.start_date
2280: from pqh_budget_periods bper,
2281: pqh_budget_details bdet,
2282: per_time_periods stp,
2283: per_time_periods etp
2284: where bper.budget_detail_id = bdet.budget_detail_id
2285: and p_job_id = bdet.job_id
2286: and bper.start_time_period_id = stp.time_period_id
2287: and bper.end_time_period_id = etp.time_period_id

Line 2352: per_time_periods stp,

2348:
2349: select stp.start_date
2350: from pqh_budget_periods bper,
2351: pqh_budget_details bdet,
2352: per_time_periods stp,
2353: per_time_periods etp
2354: where bper.budget_detail_id = bdet.budget_detail_id
2355: and p_organization_id = bdet.organization_id
2356: and bper.start_time_period_id = stp.time_period_id

Line 2353: per_time_periods etp

2349: select stp.start_date
2350: from pqh_budget_periods bper,
2351: pqh_budget_details bdet,
2352: per_time_periods stp,
2353: per_time_periods etp
2354: where bper.budget_detail_id = bdet.budget_detail_id
2355: and p_organization_id = bdet.organization_id
2356: and bper.start_time_period_id = stp.time_period_id
2357: and bper.end_time_period_id = etp.time_period_id

Line 2423: per_time_periods stp,

2419: cursor c_date is
2420: select stp.start_date
2421: from pqh_budget_periods bper,
2422: pqh_budget_details bdet,
2423: per_time_periods stp,
2424: per_time_periods etp
2425: where bper.budget_detail_id = bdet.budget_detail_id
2426: and p_grade_id = bdet.grade_id
2427: and bper.start_time_period_id = stp.time_period_id

Line 2424: per_time_periods etp

2420: select stp.start_date
2421: from pqh_budget_periods bper,
2422: pqh_budget_details bdet,
2423: per_time_periods stp,
2424: per_time_periods etp
2425: where bper.budget_detail_id = bdet.budget_detail_id
2426: and p_grade_id = bdet.grade_id
2427: and bper.start_time_period_id = stp.time_period_id
2428: and bper.end_time_period_id = etp.time_period_id

Line 2582: from pqh_budget_periods bpr, per_time_periods tp_s,

2578: nvl(bdet.grade_id, -1);
2579:
2580: cursor c3(p_budget_detail_id number) is
2581: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
2582: from pqh_budget_periods bpr, per_time_periods tp_s,
2583: per_time_periods tp_e
2584: where bpr.budget_detail_id = p_budget_detail_id
2585: and tp_s.time_period_id = bpr.start_time_period_id
2586: and tp_e.time_period_id = bpr.end_time_period_id

Line 2583: per_time_periods tp_e

2579:
2580: cursor c3(p_budget_detail_id number) is
2581: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
2582: from pqh_budget_periods bpr, per_time_periods tp_s,
2583: per_time_periods tp_e
2584: where bpr.budget_detail_id = p_budget_detail_id
2585: and tp_s.time_period_id = bpr.start_time_period_id
2586: and tp_e.time_period_id = bpr.end_time_period_id
2587: and tp_s.period_set_name = l_calendar