17:
18: /* hr_standard.event('BEFORE REPORT'); */
19:
20: c_business_group_name :=
21: hr_reports.get_business_group(p_business_group_id);
22:
23: select peo.first_name ||
24: decode(peo.first_name,null,null,' ') ||
25: peo.last_name
31: c_header_name := v_name;
32:
33:
34:
35: hr_reports.get_desc_flex_context('PER','PER_ASSIGNMENT_STATUSES',
36: 'sst',v_title,v_label_expr,v_column_expr);
37: if v_column_expr is not null then
38: c_app_sec_status_details := v_column_expr;
39: c_app_sec_status_label := v_label_expr;
42: end if;
43:
44:
45:
46: hr_reports.get_desc_flex_context('PER','PER_EVENTS',
47: 'a',v_title,v_label_expr,v_column_expr);
48: if v_column_expr is not null then
49: c_inter_df_details := v_column_expr;
50: c_inter_df_label := v_label_expr;
52: c_inter_df_details := 'a.attribute1';
53: end if;
54:
55:
56: hr_reports.get_desc_flex_context('PER','PER_ASSIGNMENTS',
57: 'asg',v_title,v_label_expr,v_column_expr);
58: if v_column_expr is not null then
59: c_app_ass_df_details := v_column_expr;
60: c_app_ass_df_label := v_label_expr;
61: else
62: c_app_ass_df_details := 'as'||'g.ass_attribute1';
63: end if;
64:
65: hr_reports.get_desc_flex_context('PER','PER_APPLICATIONS',
66: 'app',v_title,v_label_expr,v_column_expr);
67: if v_column_expr is not null then
68: c_app_df_details := v_column_expr;
69: c_app_df_label := v_label_expr;