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_ES_ONLINE_SOE dependencies on PAY_ES_ONLINE_SOE

Line 1: PACKAGE BODY pay_es_online_soe AS

1: PACKAGE BODY pay_es_online_soe AS
2: /* $Header: pyessoer.pkb 120.2 2005/08/03 22:06:09 viviswan noship $ */
3: --
4: -------------------------------------------------------------------------------
5: -- FUNCTION Employees

Line 537: decode(et.element_name,''Other Court Order Deductions'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Court Order Type'',''ES_OTHER_COURT_ORDER_TYPE'')

533: --
534: l_sql :=
535: 'select nvl(ettl.reporting_name,et.element_type_id) COL01
536: , nvl(ettl.reporting_name,ettl.element_name) ||
537: decode(et.element_name,''Other Court Order Deductions'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Court Order Type'',''ES_OTHER_COURT_ORDER_TYPE'')
538: ,''Company Loan Detail'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
539: ,''Company Loan'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
540: , '' '') COL02
541: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

Line 538: ,''Company Loan Detail'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')

534: l_sql :=
535: 'select nvl(ettl.reporting_name,et.element_type_id) COL01
536: , nvl(ettl.reporting_name,ettl.element_name) ||
537: decode(et.element_name,''Other Court Order Deductions'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Court Order Type'',''ES_OTHER_COURT_ORDER_TYPE'')
538: ,''Company Loan Detail'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
539: ,''Company Loan'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
540: , '' '') COL02
541: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
542: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator

Line 539: ,''Company Loan'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')

535: 'select nvl(ettl.reporting_name,et.element_type_id) COL01
536: , nvl(ettl.reporting_name,ettl.element_name) ||
537: decode(et.element_name,''Other Court Order Deductions'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Court Order Type'',''ES_OTHER_COURT_ORDER_TYPE'')
538: ,''Company Loan Detail'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
539: ,''Company Loan'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
540: , '' '') COL02
541: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
542: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
543: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18

Line 577: decode(et.element_name,''Other Court Order Deductions'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Court Order Type'',''ES_OTHER_COURT_ORDER_TYPE'')

573: AND ( es.LEGISLATION_CODE IS NULL
574: OR es.LEGISLATION_CODE = '':legislation_code'' )
575: and es.element_set_name = '''|| p_element_set_name ||'''
576: group by nvl(ettl.reporting_name,ettl.element_name) ||
577: decode(et.element_name,''Other Court Order Deductions'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Court Order Type'',''ES_OTHER_COURT_ORDER_TYPE'')
578: ,''Company Loan Detail'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
579: ,''Company Loan'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
580: , '' '')
581: ,nvl(ettl.reporting_name,et.element_type_id)

Line 578: ,''Company Loan Detail'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')

574: OR es.LEGISLATION_CODE = '':legislation_code'' )
575: and es.element_set_name = '''|| p_element_set_name ||'''
576: group by nvl(ettl.reporting_name,ettl.element_name) ||
577: decode(et.element_name,''Other Court Order Deductions'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Court Order Type'',''ES_OTHER_COURT_ORDER_TYPE'')
578: ,''Company Loan Detail'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
579: ,''Company Loan'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
580: , '' '')
581: ,nvl(ettl.reporting_name,et.element_type_id)
582: order by 1,2';

Line 579: ,''Company Loan'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')

575: and es.element_set_name = '''|| p_element_set_name ||'''
576: group by nvl(ettl.reporting_name,ettl.element_name) ||
577: decode(et.element_name,''Other Court Order Deductions'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Court Order Type'',''ES_OTHER_COURT_ORDER_TYPE'')
578: ,''Company Loan Detail'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
579: ,''Company Loan'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
580: , '' '')
581: ,nvl(ettl.reporting_name,et.element_type_id)
582: order by 1,2';
583: --

Line 648: END pay_es_online_soe;

644: --
645: END Get_Input_Value;
646:
647: --
648: END pay_es_online_soe;