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.HRDYNDBI dependencies on PAY_INPUT_VALUES_F

Line 3736: from pay_input_values_f

3732: -- cursor c1 : select input values to be deleted:
3733: --
3734: cursor c1 is
3735: select input_value_id
3736: from pay_input_values_f
3737: where element_type_id = p_element_type_id;
3738: --
3739: -- cursor c2 : select input values to be used for database items:
3740: --

Line 3744: from pay_input_values_f

3740: --
3741: cursor c2 is
3742: select input_value_id,
3743: max(effective_end_date) c_date
3744: from pay_input_values_f
3745: where generate_db_items_flag = 'Y'
3746: and element_type_id = p_element_type_id
3747: group by input_value_id;
3748: --

Line 3869: l_input_name pay_input_values_f.name%type;

3865: l_route1_name varchar2(50) := 'INPUT_VALUE_FROM_INPUT_VALUE_TABLE' ||p_date_p;
3866: l_route2_name varchar2(50) := 'INPUT_VALUE_USING_PARTIAL_MATCHING' ||p_date_p;
3867: l_entry_route varchar2(50) := 'INPUT_VALUE_ENTRY_LEVEL' || p_date_p;
3868: l_override_entry_route varchar2(50) := 'INPUT_VALUE_ENTRY_LEVEL_OVERRIDE' || p_date_p;
3869: l_input_name pay_input_values_f.name%type;
3870: l_entity_name ff_user_entities.user_entity_name%type;
3871: l_element_type_id pay_element_types_f.element_type_id%type;
3872: l_element_name pay_element_types_f.element_name%type;
3873: l_multiple_entries pay_element_types_f.multiple_entries_allowed_flag%type;

Line 3908: from pay_input_values_f

3904: to_char(effective_start_date, 'DD-MM-YYYY') esd,
3905: to_char(effective_end_date, 'DD-MM-YYYY') eed,
3906: legislation_code,
3907: business_group_id
3908: from pay_input_values_f
3909: where input_value_id = p_iv_id;
3910:
3911: cursor c_list_elements(p_el_id in number) is
3912: select element_name,

Line 3997: from pay_input_values_f INPUTV

3993: l_last_login,
3994: l_element_type_id,
3995: l_element_name,
3996: l_multiple_entries
3997: from pay_input_values_f INPUTV
3998: , pay_element_types_f ET
3999: where INPUTV.input_value_id = p_input_value_id
4000: and p_effective_date between INPUTV.effective_start_date
4001: and INPUTV.effective_end_date

Line 4025: from pay_input_values_f

4021: END LOOP;
4022:
4023: select distinct element_type_id
4024: into l_iv_eltypeid
4025: from pay_input_values_f
4026: where input_value_id = p_input_value_id
4027: and rownum = 1;
4028:
4029: FOR el in c_list_elements(l_iv_eltypeid) LOOP

Line 4739: from pay_input_values_f INPUTV

4735:
4736: select nvl (ltrim(rtrim(INPUTV.legislation_code)),
4737: ltrim(rtrim(BUSGP.legislation_code)))
4738: into l_leg_code_ben
4739: from pay_input_values_f INPUTV
4740: , per_business_groups_perf BUSGP
4741: where INPUTV.input_value_id = p_input_value_id
4742: and p_effective_date between INPUTV.effective_start_date
4743: and INPUTV.effective_end_date

Line 4814: from pay_input_values_f i

4810: order by element_type_id;
4811: --
4812: cursor c2 is select input_value_id,
4813: max(effective_end_date)
4814: from pay_input_values_f i
4815: where generate_db_items_flag = 'Y'
4816: and not exists (
4817: select null
4818: from ff_user_entities u

Line 4943: from pay_input_values_f a

4939: order by element_type_id;
4940: --
4941: cursor c2 is select input_value_id,
4942: max(effective_end_date)
4943: from pay_input_values_f a
4944: where generate_db_items_flag = 'Y'
4945: and not exists (
4946: select null
4947: from ff_user_entities u

Line 5063: from pay_input_values_f a

5059: delete ff_user_entities u
5060: where u.creator_type = 'I'
5061: and exists (
5062: select null
5063: from pay_input_values_f a
5064: where u.creator_id = a.input_value_id);
5065:
5066: delete ff_user_entities u
5067: where u.creator_type = 'E'

Line 5100: from pay_input_values_f a

5096: delete ff_user_entities u
5097: where u.creator_type = 'I'
5098: and exists (
5099: select null
5100: from pay_input_values_f a
5101: where u.creator_id = a.input_value_id
5102: and (a.legislation_code = p_leg_code
5103: or exists
5104: (select null

Line 5549: from pay_input_values_f i

5545: OR
5546: -- I
5547: (not exists (
5548: select null
5549: from pay_input_values_f i
5550: where ent.creator_id = i.input_value_id
5551: and i.generate_db_items_flag = 'Y'
5552: and ent.creator_type = 'I'))
5553: ) -- end B RB E I

Line 8314: , pay_input_values_f iv

8310: select et.element_name || '_' || iv.name
8311: , et.legislation_code
8312: , et.business_group_id
8313: from pay_element_types_f et
8314: , pay_input_values_f iv
8315: where iv.input_value_id = p_input_value_id
8316: and et.element_type_id = iv.element_type_id
8317: ;
8318: --

Line 8320: l_leg_code pay_input_values_f.legislation_code%type;

8316: and et.element_type_id = iv.element_type_id
8317: ;
8318: --
8319: l_prefix ff_database_items.user_name%type;
8320: l_leg_code pay_input_values_f.legislation_code%type;
8321: l_bg_id pay_input_values_f.business_group_id%type;
8322: l_found boolean;
8323: begin
8324: --

Line 8321: l_bg_id pay_input_values_f.business_group_id%type;

8317: ;
8318: --
8319: l_prefix ff_database_items.user_name%type;
8320: l_leg_code pay_input_values_f.legislation_code%type;
8321: l_bg_id pay_input_values_f.business_group_id%type;
8322: l_found boolean;
8323: begin
8324: --
8325: -- Fetch the prefix if necessary.

Line 8483: from pay_input_values_f iv

8479: cursor csr_base_name
8480: (p_input_value_id in number
8481: ) is
8482: select iv.name
8483: from pay_input_values_f iv
8484: where iv.input_value_id = p_input_value_id
8485: and p_effective_date between
8486: iv.effective_start_date and iv.effective_end_date
8487: ;

Line 8495: from pay_input_values_f iv

8491: ,p_language in varchar2
8492: ) is
8493: select ivtl.name
8494: , ettl.element_name
8495: from pay_input_values_f iv
8496: , pay_element_types_f_tl ettl
8497: , pay_input_values_f_tl ivtl
8498: where iv.input_value_id = p_input_value_id
8499: and p_effective_date between

Line 8497: , pay_input_values_f_tl ivtl

8493: select ivtl.name
8494: , ettl.element_name
8495: from pay_input_values_f iv
8496: , pay_element_types_f_tl ettl
8497: , pay_input_values_f_tl ivtl
8498: where iv.input_value_id = p_input_value_id
8499: and p_effective_date between
8500: iv.effective_start_date and iv.effective_end_date
8501: and ettl.element_type_id = iv.element_type_id

Line 8507: l_pay_value pay_input_values_f.name%type := null;

8503: and ivtl.input_value_id = iv.input_value_id
8504: and ivtl.language = p_language
8505: ;
8506: --
8507: l_pay_value pay_input_values_f.name%type := null;
8508: l_ipv_name pay_input_values_f_tl.name%type;
8509: l_ele_name pay_element_types_f_tl.element_name%type;
8510: l_found boolean := true;
8511: l_debug boolean := hr_utility.debug_enabled;

Line 8508: l_ipv_name pay_input_values_f_tl.name%type;

8504: and ivtl.language = p_language
8505: ;
8506: --
8507: l_pay_value pay_input_values_f.name%type := null;
8508: l_ipv_name pay_input_values_f_tl.name%type;
8509: l_ele_name pay_element_types_f_tl.element_name%type;
8510: l_found boolean := true;
8511: l_debug boolean := hr_utility.debug_enabled;
8512: begin

Line 9575: -- Interface 1: does not reference PAY_INPUT_VALUES_F_TL - the core

9571: -- Update all the dbis for an input value --
9572: -- ====================================== --
9573:
9574: --
9575: -- Interface 1: does not reference PAY_INPUT_VALUES_F_TL - the core
9576: -- interface.
9577: --
9578: procedure update_input_value
9579: (p_input_value_id in number

Line 9596: from pay_input_values_f iv

9592: , iv.legislation_code
9593: , iv.business_group_id
9594: , iv.uom
9595: , iv.generate_db_items_flag
9596: from pay_input_values_f iv
9597: , pay_element_types_f et
9598: where iv.input_value_id = p_input_value_id
9599: and p_effective_date between
9600: iv.effective_start_date and iv.effective_end_date

Line 9607: l_uom pay_input_values_f.uom%type;

9603: et.effective_start_date and et.effective_end_date
9604: ;
9605: --
9606: l_multi_entries pay_element_types_f.multiple_entries_allowed_flag%type;
9607: l_uom pay_input_values_f.uom%type;
9608: l_generate_dbis pay_input_values_f.generate_db_items_flag%type;
9609: l_do_date_p boolean;
9610: l_do_non_date_p boolean;
9611: l_date_p varchar2(16);

Line 9608: l_generate_dbis pay_input_values_f.generate_db_items_flag%type;

9604: ;
9605: --
9606: l_multi_entries pay_element_types_f.multiple_entries_allowed_flag%type;
9607: l_uom pay_input_values_f.uom%type;
9608: l_generate_dbis pay_input_values_f.generate_db_items_flag%type;
9609: l_do_date_p boolean;
9610: l_do_non_date_p boolean;
9611: l_date_p varchar2(16);
9612: l_leg_code varchar2(30);

Line 10018: -- Interface 2: references PAY_INPUT_VALUES_F_TL.

10014:
10015: end update_input_value;
10016:
10017: --
10018: -- Interface 2: references PAY_INPUT_VALUES_F_TL.
10019: --
10020: procedure update_input_value
10021: (p_input_value_id in number
10022: ,p_effective_date in date

Line 10263: from pay_input_values_f iv

10259: cursor csr_ipv_eff_date
10260: (p_input_value_id in number
10261: ) is
10262: select iv.effective_end_date
10263: from pay_input_values_f iv
10264: where iv.input_value_id = p_input_value_id
10265: order by 1 desc
10266: ;
10267: --