[Home] [Help]
9800: DECODE(g_dff_grouping_option, 'Y', psl.attribute8, NULL),
9801: DECODE(g_dff_grouping_option, 'Y', psl.attribute9, NULL),
9802: DECODE(g_dff_grouping_option, 'Y', psl.attribute10, NULL),
9803: DECODE(psl.expenditure_type, NULL, 'N', 'E') acct_type
9804: FROM psp_element_types pet,
9805: psp_group_element_list pgel,
9806: psp_schedule_hierarchy psh,
9807: psp_schedule_lines psl
9808: WHERE pet.element_type_id = p_element_type_id