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 2316: from pqh_budget_periods bpr, per_time_periods tp_s,

2312: and bdt.budget_version_id = bvr.budget_version_id
2313: and bdt.position_id = p_position_id;
2314: cursor c3(p_budget_detail_id number) is
2315: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
2316: from pqh_budget_periods bpr, per_time_periods tp_s,
2317: per_time_periods tp_e
2318: where bpr.budget_detail_id = p_budget_detail_id
2319: and tp_s.time_period_id = bpr.start_time_period_id
2320: and tp_e.time_period_id = bpr.end_time_period_id

Line 2317: per_time_periods tp_e

2313: and bdt.position_id = p_position_id;
2314: cursor c3(p_budget_detail_id number) is
2315: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
2316: from pqh_budget_periods bpr, per_time_periods tp_s,
2317: per_time_periods tp_e
2318: where bpr.budget_detail_id = p_budget_detail_id
2319: and tp_s.time_period_id = bpr.start_time_period_id
2320: and tp_e.time_period_id = bpr.end_time_period_id
2321: and tp_s.period_set_name = l_calendar

Line 2406: per_time_periods stp,

2402: cursor c_date is
2403: select stp.start_date
2404: from pqh_budget_periods bper,
2405: pqh_budget_details bdet,
2406: per_time_periods stp,
2407: per_time_periods etp
2408: where bper.budget_detail_id = bdet.budget_detail_id
2409: and p_position_id = bdet.position_id
2410: and bper.start_time_period_id = stp.time_period_id

Line 2407: per_time_periods etp

2403: select stp.start_date
2404: from pqh_budget_periods bper,
2405: pqh_budget_details bdet,
2406: per_time_periods stp,
2407: per_time_periods etp
2408: where bper.budget_detail_id = bdet.budget_detail_id
2409: and p_position_id = bdet.position_id
2410: and bper.start_time_period_id = stp.time_period_id
2411: and bper.end_time_period_id = etp.time_period_id

Line 2475: per_time_periods stp,

2471: cursor c_date is
2472: select stp.start_date
2473: from pqh_budget_periods bper,
2474: pqh_budget_details bdet,
2475: per_time_periods stp,
2476: per_time_periods etp
2477: where bper.budget_detail_id = bdet.budget_detail_id
2478: and p_job_id = bdet.job_id
2479: and bper.start_time_period_id = stp.time_period_id

Line 2476: per_time_periods etp

2472: select stp.start_date
2473: from pqh_budget_periods bper,
2474: pqh_budget_details bdet,
2475: per_time_periods stp,
2476: per_time_periods etp
2477: where bper.budget_detail_id = bdet.budget_detail_id
2478: and p_job_id = bdet.job_id
2479: and bper.start_time_period_id = stp.time_period_id
2480: and bper.end_time_period_id = etp.time_period_id

Line 2545: per_time_periods stp,

2541:
2542: select stp.start_date
2543: from pqh_budget_periods bper,
2544: pqh_budget_details bdet,
2545: per_time_periods stp,
2546: per_time_periods etp
2547: where bper.budget_detail_id = bdet.budget_detail_id
2548: and p_organization_id = bdet.organization_id
2549: and bper.start_time_period_id = stp.time_period_id

Line 2546: per_time_periods etp

2542: select stp.start_date
2543: from pqh_budget_periods bper,
2544: pqh_budget_details bdet,
2545: per_time_periods stp,
2546: per_time_periods etp
2547: where bper.budget_detail_id = bdet.budget_detail_id
2548: and p_organization_id = bdet.organization_id
2549: and bper.start_time_period_id = stp.time_period_id
2550: and bper.end_time_period_id = etp.time_period_id

Line 2616: per_time_periods stp,

2612: cursor c_date is
2613: select stp.start_date
2614: from pqh_budget_periods bper,
2615: pqh_budget_details bdet,
2616: per_time_periods stp,
2617: per_time_periods etp
2618: where bper.budget_detail_id = bdet.budget_detail_id
2619: and p_grade_id = bdet.grade_id
2620: and bper.start_time_period_id = stp.time_period_id

Line 2617: per_time_periods etp

2613: select stp.start_date
2614: from pqh_budget_periods bper,
2615: pqh_budget_details bdet,
2616: per_time_periods stp,
2617: per_time_periods etp
2618: where bper.budget_detail_id = bdet.budget_detail_id
2619: and p_grade_id = bdet.grade_id
2620: and bper.start_time_period_id = stp.time_period_id
2621: and bper.end_time_period_id = etp.time_period_id

Line 2775: from pqh_budget_periods bpr, per_time_periods tp_s,

2771: nvl(bdet.grade_id, -1);
2772:
2773: cursor c3(p_budget_detail_id number) is
2774: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
2775: from pqh_budget_periods bpr, per_time_periods tp_s,
2776: per_time_periods tp_e
2777: where bpr.budget_detail_id = p_budget_detail_id
2778: and tp_s.time_period_id = bpr.start_time_period_id
2779: and tp_e.time_period_id = bpr.end_time_period_id

Line 2776: per_time_periods tp_e

2772:
2773: cursor c3(p_budget_detail_id number) is
2774: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
2775: from pqh_budget_periods bpr, per_time_periods tp_s,
2776: per_time_periods tp_e
2777: where bpr.budget_detail_id = p_budget_detail_id
2778: and tp_s.time_period_id = bpr.start_time_period_id
2779: and tp_e.time_period_id = bpr.end_time_period_id
2780: and tp_s.period_set_name = l_calendar