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 3739: from pay_input_values_f

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

Line 3747: from pay_input_values_f

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

Line 3872: l_input_name pay_input_values_f.name%type;

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

Line 3911: from pay_input_values_f

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

Line 4000: from pay_input_values_f INPUTV

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

Line 4028: from pay_input_values_f

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

Line 4742: from pay_input_values_f INPUTV

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

Line 4817: from pay_input_values_f i

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

Line 4946: from pay_input_values_f a

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

Line 5066: from pay_input_values_f a

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

Line 5103: from pay_input_values_f a

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

Line 5552: from pay_input_values_f i

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

Line 8391: , pay_input_values_f iv

8387: select et.element_name || '_' || iv.name
8388: , et.legislation_code
8389: , et.business_group_id
8390: from pay_element_types_f et
8391: , pay_input_values_f iv
8392: where iv.input_value_id = p_input_value_id
8393: and et.element_type_id = iv.element_type_id
8394: ;
8395: --

Line 8397: l_leg_code pay_input_values_f.legislation_code%type;

8393: and et.element_type_id = iv.element_type_id
8394: ;
8395: --
8396: l_prefix ff_database_items.user_name%type;
8397: l_leg_code pay_input_values_f.legislation_code%type;
8398: l_bg_id pay_input_values_f.business_group_id%type;
8399: l_found boolean;
8400: begin
8401: --

Line 8398: l_bg_id pay_input_values_f.business_group_id%type;

8394: ;
8395: --
8396: l_prefix ff_database_items.user_name%type;
8397: l_leg_code pay_input_values_f.legislation_code%type;
8398: l_bg_id pay_input_values_f.business_group_id%type;
8399: l_found boolean;
8400: begin
8401: --
8402: -- Fetch the prefix if necessary.

Line 8560: from pay_input_values_f iv

8556: cursor csr_base_name
8557: (p_input_value_id in number
8558: ) is
8559: select iv.name
8560: from pay_input_values_f iv
8561: where iv.input_value_id = p_input_value_id
8562: and p_effective_date between
8563: iv.effective_start_date and iv.effective_end_date
8564: ;

Line 8572: from pay_input_values_f iv

8568: ,p_language in varchar2
8569: ) is
8570: select ivtl.name
8571: , ettl.element_name
8572: from pay_input_values_f iv
8573: , pay_element_types_f_tl ettl
8574: , pay_input_values_f_tl ivtl
8575: where iv.input_value_id = p_input_value_id
8576: and p_effective_date between

Line 8574: , pay_input_values_f_tl ivtl

8570: select ivtl.name
8571: , ettl.element_name
8572: from pay_input_values_f iv
8573: , pay_element_types_f_tl ettl
8574: , pay_input_values_f_tl ivtl
8575: where iv.input_value_id = p_input_value_id
8576: and p_effective_date between
8577: iv.effective_start_date and iv.effective_end_date
8578: and ettl.element_type_id = iv.element_type_id

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

8580: and ivtl.input_value_id = iv.input_value_id
8581: and ivtl.language = p_language
8582: ;
8583: --
8584: l_pay_value pay_input_values_f.name%type := null;
8585: l_ipv_name pay_input_values_f_tl.name%type;
8586: l_ele_name pay_element_types_f_tl.element_name%type;
8587: l_found boolean := true;
8588: l_debug boolean := hr_utility.debug_enabled;

Line 8585: l_ipv_name pay_input_values_f_tl.name%type;

8581: and ivtl.language = p_language
8582: ;
8583: --
8584: l_pay_value pay_input_values_f.name%type := null;
8585: l_ipv_name pay_input_values_f_tl.name%type;
8586: l_ele_name pay_element_types_f_tl.element_name%type;
8587: l_found boolean := true;
8588: l_debug boolean := hr_utility.debug_enabled;
8589: begin

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

9648: -- Update all the dbis for an input value --
9649: -- ====================================== --
9650:
9651: --
9652: -- Interface 1: does not reference PAY_INPUT_VALUES_F_TL - the core
9653: -- interface.
9654: --
9655: procedure update_input_value
9656: (p_input_value_id in number

Line 9673: from pay_input_values_f iv

9669: , iv.legislation_code
9670: , iv.business_group_id
9671: , iv.uom
9672: , iv.generate_db_items_flag
9673: from pay_input_values_f iv
9674: , pay_element_types_f et
9675: where iv.input_value_id = p_input_value_id
9676: and p_effective_date between
9677: iv.effective_start_date and iv.effective_end_date

Line 9684: l_uom pay_input_values_f.uom%type;

9680: et.effective_start_date and et.effective_end_date
9681: ;
9682: --
9683: l_multi_entries pay_element_types_f.multiple_entries_allowed_flag%type;
9684: l_uom pay_input_values_f.uom%type;
9685: l_generate_dbis pay_input_values_f.generate_db_items_flag%type;
9686: l_do_date_p boolean;
9687: l_do_non_date_p boolean;
9688: l_date_p varchar2(16);

Line 9685: l_generate_dbis pay_input_values_f.generate_db_items_flag%type;

9681: ;
9682: --
9683: l_multi_entries pay_element_types_f.multiple_entries_allowed_flag%type;
9684: l_uom pay_input_values_f.uom%type;
9685: l_generate_dbis pay_input_values_f.generate_db_items_flag%type;
9686: l_do_date_p boolean;
9687: l_do_non_date_p boolean;
9688: l_date_p varchar2(16);
9689: l_leg_code varchar2(30);

Line 10095: -- Interface 2: references PAY_INPUT_VALUES_F_TL.

10091:
10092: end update_input_value;
10093:
10094: --
10095: -- Interface 2: references PAY_INPUT_VALUES_F_TL.
10096: --
10097: procedure update_input_value
10098: (p_input_value_id in number
10099: ,p_effective_date in date

Line 10340: from pay_input_values_f iv

10336: cursor csr_ipv_eff_date
10337: (p_input_value_id in number
10338: ) is
10339: select iv.effective_end_date
10340: from pay_input_values_f iv
10341: where iv.input_value_id = p_input_value_id
10342: order by 1 desc
10343: ;
10344: --