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.ZPB_ACVAL_PVT dependencies on ZPB_STATUS_SQL

Line 25: l_edt_status_sql zpb_status_sql.status_sql%type;

21: l_pub_ac_id zpb_analysis_cycles.analysis_cycle_id%type;
22: l_edt_ac_id zpb_analysis_cycles.analysis_cycle_id%type;
23: l_edt_query_path zpb_cycle_model_dimensions.query_object_path%type;
24: l_pub_query_path zpb_cycle_model_dimensions.query_object_path%type;
25: l_edt_status_sql zpb_status_sql.status_sql%type;
26: l_pub_status_sql zpb_status_sql.status_sql%type;
27: l_sql zpb_status_sql.status_sql%type;
28: l_cycle_dim zpb_cycle_model_dimensions.dimension_name%type;
29: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;

Line 26: l_pub_status_sql zpb_status_sql.status_sql%type;

22: l_edt_ac_id zpb_analysis_cycles.analysis_cycle_id%type;
23: l_edt_query_path zpb_cycle_model_dimensions.query_object_path%type;
24: l_pub_query_path zpb_cycle_model_dimensions.query_object_path%type;
25: l_edt_status_sql zpb_status_sql.status_sql%type;
26: l_pub_status_sql zpb_status_sql.status_sql%type;
27: l_sql zpb_status_sql.status_sql%type;
28: l_cycle_dim zpb_cycle_model_dimensions.dimension_name%type;
29: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
30: l_dataset_dim zpb_cycle_model_dimensions.dataset_dimension_flag%type;

Line 27: l_sql zpb_status_sql.status_sql%type;

23: l_edt_query_path zpb_cycle_model_dimensions.query_object_path%type;
24: l_pub_query_path zpb_cycle_model_dimensions.query_object_path%type;
25: l_edt_status_sql zpb_status_sql.status_sql%type;
26: l_pub_status_sql zpb_status_sql.status_sql%type;
27: l_sql zpb_status_sql.status_sql%type;
28: l_cycle_dim zpb_cycle_model_dimensions.dimension_name%type;
29: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
30: l_dataset_dim zpb_cycle_model_dimensions.dataset_dimension_flag%type;
31: l_removed_dim zpb_cycle_model_dimensions.remove_dimension_flag%type;

Line 245: from zpb_status_sql

241: and pub.analysis_cycle_id = l_pub_ac_id;
242:
243: cursor status_sql(l_query_path in varchar2) is
244: select status_sql
245: from zpb_status_sql
246: where query_path = l_query_path
247: and dimension_name = l_line_dim
248: order by row_num;
249: