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.

[Home] [Help]

APPS.PSB_EXCEL_PVT dependencies on PSB_BUDGET_PERIODS

Line 577: FROM psb_budget_periods

573: IS
574: CURSOR C IS
575: SELECT budget_period_id,
576: name
577: FROM psb_budget_periods
578: WHERE parent_budget_period_id = p_budget_year_id
579: AND budget_period_type = 'P';
580:
581: Recinfo C%ROWTYPE;

Line 2967: from psb_budget_periods bp

2963: )
2964: IS
2965: cursor c1 is
2966: select MIN(start_date) start_date , MAX(end_date) end_date
2967: from psb_budget_periods bp
2968: where bp.budget_calendar_id = p_budget_calendar_id
2969: and budget_period_type = 'Y';
2970:
2971: cursor c2 is

Line 2974: psb_budget_periods bp

2970:
2971: cursor c2 is
2972: select bp.budget_period_id, yt.year_category_type, bp.start_date, bp.end_date
2973: from psb_budget_year_types yt,
2974: psb_budget_periods bp
2975: where
2976: yt.budget_year_type_id = bp.budget_year_type_id
2977: and bp.budget_period_type = 'Y'
2978: and bp.budget_calendar_id = p_budget_calendar_id