APPS.PAY_KW_SOE dependencies on PAY_KW_SOE

Line 1: PACKAGE BODY pay_kw_soe AS

1: PACKAGE BODY pay_kw_soe AS
2: /* $Header: pykwsoer.pkb 120.0.12000000.3 2007/02/08 05:12:17 spendhar noship $ */
3: /*Function to pick up employee details*/
4: FUNCTION employees(p_assignment_action_id NUMBER) RETURN LONG IS
5: l_sql LONG;

Line 588: , nvl(ettl.reporting_name,ettl.element_name) || pay_kw_soe.kw_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date ) COL02

584: begin
585: --
586: l_sql :=
587: 'select nvl(ettl.reporting_name,et.element_type_id) COL01
588: , nvl(ettl.reporting_name,ettl.element_name) || pay_kw_soe.kw_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date ) COL02
589: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
590: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
591: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
592: from pay_assignment_actions aa

Line 624: group by nvl(ettl.reporting_name,ettl.element_name) || pay_kw_soe.kw_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date )

620: OR es.BUSINESS_GROUP_ID = :business_group_id )
621: AND ( es.LEGISLATION_CODE IS NULL
622: OR es.LEGISLATION_CODE = '':legislation_code'' )
623: and es.element_set_name = '''|| p_element_set_name ||'''
624: group by nvl(ettl.reporting_name,ettl.element_name) || pay_kw_soe.kw_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date )
625: , ettl.reporting_name
626: ,nvl(ettl.reporting_name,et.element_type_id)
627: order by nvl(ettl.reporting_name,ettl.element_name) || pay_kw_soe.kw_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date )';
628: --

Line 627: order by nvl(ettl.reporting_name,ettl.element_name) || pay_kw_soe.kw_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date )';

623: and es.element_set_name = '''|| p_element_set_name ||'''
624: group by nvl(ettl.reporting_name,ettl.element_name) || pay_kw_soe.kw_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date )
625: , ettl.reporting_name
626: ,nvl(ettl.reporting_name,et.element_type_id)
627: order by nvl(ettl.reporting_name,ettl.element_name) || pay_kw_soe.kw_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date )';
628: --
629: return l_sql;
630: --
631: end getElements;

Line 640: END pay_kw_soe;

636: return getElements(p_assignment_action_id
637: ,pay_soe_util.getConfig('ELEMENTS2'));
638: end Elements2;
639: ------------------------------------------------------------------------
640: END pay_kw_soe;
641: