DBA Data[Home] [Help]

APPS.PQH_BDGT_REALLOC_LOG_PKG dependencies on PER_TIME_PERIODS

Line 311: per_time_periods tp1,

307: l_folder_log_id NUMBER(15);
308: Cursor Csr_period_dates IS
309: SELECT to_char(tp1.start_date,'DD-MM-RRRR')||' '||to_char(tp2.end_date,'DD-MM-RRRR')
310: FROM pqh_budget_periods bpr,
311: per_time_periods tp1,
312: per_time_periods tp2
313: WHERE bpr.budget_period_id = p_budget_period_id
314: AND tp1.time_period_id = bpr.start_time_period_id
315: AND tp2.time_period_id = bpr.end_time_period_id;

Line 312: per_time_periods tp2

308: Cursor Csr_period_dates IS
309: SELECT to_char(tp1.start_date,'DD-MM-RRRR')||' '||to_char(tp2.end_date,'DD-MM-RRRR')
310: FROM pqh_budget_periods bpr,
311: per_time_periods tp1,
312: per_time_periods tp2
313: WHERE bpr.budget_period_id = p_budget_period_id
314: AND tp1.time_period_id = bpr.start_time_period_id
315: AND tp2.time_period_id = bpr.end_time_period_id;
316: Cursor csr_rcvr_dates IS