[Home] [Help]
1: PACKAGE BODY pay_ae_soe AS
2: /* $Header: pyaesoer.pkb 120.8 2012/01/19 08:38:17 rpahune ship $ */
3:
4: /*Function to pick up employee details*/
5:
600: begin
601: --
602: l_sql :=
603: 'select nvl(ettl.reporting_name,et.element_type_id) COL01
604: , nvl(ettl.reporting_name,ettl.element_name) || pay_ae_soe.ae_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date ) COL02
605: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
606: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
607: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
608: from pay_assignment_actions aa
640: -- OR es.BUSINESS_GROUP_ID = :business_group_id )
641: --AND ( es.LEGISLATION_CODE IS NULL
642: -- OR es.LEGISLATION_CODE = '':legislation_code'' )
643: --and es.element_set_name = '''|| p_element_set_name ||'''
644: group by nvl(ettl.reporting_name,ettl.element_name) || pay_ae_soe.ae_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date )
645: , ettl.reporting_name
646: ,nvl(ettl.reporting_name,et.element_type_id)
647: order by nvl(ettl.reporting_name,ettl.element_name) || pay_ae_soe.ae_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date )';
648: --
643: --and es.element_set_name = '''|| p_element_set_name ||'''
644: group by nvl(ettl.reporting_name,ettl.element_name) || pay_ae_soe.ae_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date )
645: , ettl.reporting_name
646: ,nvl(ettl.reporting_name,et.element_type_id)
647: order by nvl(ettl.reporting_name,ettl.element_name) || pay_ae_soe.ae_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date )';
648: --
649: return l_sql;
650: --
651: end getElements;
656: return getElements(p_assignment_action_id
657: ,pay_soe_util.getConfig('ELEMENTS2'));
658: end Elements2;
659: ------------------------------------------------------------------------
660: END pay_ae_soe;