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.PAY_AE_SOE dependencies on PAY_AE_SOE

Line 1: PACKAGE BODY pay_ae_soe AS

1: PACKAGE BODY pay_ae_soe AS
2: /* $Header: pyaesoer.pkb 120.1.12000000.4 2007/06/26 09:27:37 spendhar noship $ */
3:
4: /*Function to pick up employee details*/
5:

Line 598: , nvl(ettl.reporting_name,ettl.element_name) || pay_ae_soe.ae_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date ) COL02

594: begin
595: --
596: l_sql :=
597: 'select nvl(ettl.reporting_name,et.element_type_id) COL01
598: , nvl(ettl.reporting_name,ettl.element_name) || pay_ae_soe.ae_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date ) COL02
599: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
600: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
601: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
602: from pay_assignment_actions aa

Line 634: 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 )

630: OR es.BUSINESS_GROUP_ID = :business_group_id )
631: AND ( es.LEGISLATION_CODE IS NULL
632: OR es.LEGISLATION_CODE = '':legislation_code'' )
633: and es.element_set_name = '''|| p_element_set_name ||'''
634: 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 )
635: , ettl.reporting_name
636: ,nvl(ettl.reporting_name,et.element_type_id)
637: 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 )';
638: --

Line 637: 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 )';

633: and es.element_set_name = '''|| p_element_set_name ||'''
634: 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 )
635: , ettl.reporting_name
636: ,nvl(ettl.reporting_name,et.element_type_id)
637: 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 )';
638: --
639: return l_sql;
640: --
641: end getElements;

Line 650: END pay_ae_soe;

646: return getElements(p_assignment_action_id
647: ,pay_soe_util.getConfig('ELEMENTS2'));
648: end Elements2;
649: ------------------------------------------------------------------------
650: END pay_ae_soe;