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_ELEMENT_TYPES_F

Line 3033: l_element_name pay_element_types_f.element_name%type;

3029:
3030: l_benefit_class_id number;
3031: l_class_name pay_element_classifications.classification_name%type;
3032: l_business_group_id number;
3033: l_element_name pay_element_types_f.element_name%type;
3034: l_legislation_code pay_element_types_f.legislation_code%type;
3035: l_leg_code_class pay_element_types_f.legislation_code%type;
3036: l_full_mls boolean;
3037: l_base_dbi_name varchar2(2000);

Line 3034: l_legislation_code pay_element_types_f.legislation_code%type;

3030: l_benefit_class_id number;
3031: l_class_name pay_element_classifications.classification_name%type;
3032: l_business_group_id number;
3033: l_element_name pay_element_types_f.element_name%type;
3034: l_legislation_code pay_element_types_f.legislation_code%type;
3035: l_leg_code_class pay_element_types_f.legislation_code%type;
3036: l_full_mls boolean;
3037: l_base_dbi_name varchar2(2000);
3038: l_user_entity_id number;

Line 3035: l_leg_code_class pay_element_types_f.legislation_code%type;

3031: l_class_name pay_element_classifications.classification_name%type;
3032: l_business_group_id number;
3033: l_element_name pay_element_types_f.element_name%type;
3034: l_legislation_code pay_element_types_f.legislation_code%type;
3035: l_leg_code_class pay_element_types_f.legislation_code%type;
3036: l_full_mls boolean;
3037: l_base_dbi_name varchar2(2000);
3038: l_user_entity_id number;
3039: l_dbi_prefixes t_dbi_prefixes;

Line 3042: l_legislation_code1 pay_element_types_f.legislation_code%type;

3038: l_user_entity_id number;
3039: l_dbi_prefixes t_dbi_prefixes;
3040: l_languages dbms_sql.varchar2s;
3041: l_startup_mode varchar2(100);
3042: l_legislation_code1 pay_element_types_f.legislation_code%type;
3043: --
3044: ------------------------- create_element_type -------------------------
3045: --
3046: BEGIN

Line 3065: from pay_element_types_f ETYPE

3061: l_benefit_class_id,
3062: l_class_name,
3063: l_created_by,
3064: l_last_login
3065: from pay_element_types_f ETYPE
3066: , pay_element_classifications CLASS
3067: where ETYPE.element_type_id = p_element_type_id
3068: and p_effective_date between ETYPE.effective_start_date
3069: and ETYPE.effective_end_date

Line 3614: from pay_element_types_f ETYPE

3610: --
3611: select nvl (ltrim(rtrim(ETYPE.legislation_code)),
3612: ltrim(rtrim(BUSGP.legislation_code)))
3613: into l_leg_code_class
3614: from pay_element_types_f ETYPE
3615: , per_business_groups_perf BUSGP
3616: where ETYPE.element_type_id = p_element_type_id
3617: and p_effective_date between ETYPE.effective_start_date
3618: and ETYPE.effective_end_date

Line 3628: for c1rec in dflex_c1 ('PAY_ELEMENT_TYPES_F', -- table name

3624: open get_title;
3625: fetch get_title into l_title;
3626: close get_title;
3627: --
3628: for c1rec in dflex_c1 ('PAY_ELEMENT_TYPES_F', -- table name
3629: l_title, -- title of desc. flex
3630: 'N', -- global flag
3631: l_class_name) loop -- context code
3632: l_dbitem_found := FALSE;

Line 3767: from pay_element_types_f

3763: select element_type_id,
3764: max(effective_end_date)
3765: into l_element_type,
3766: l_date
3767: from pay_element_types_f
3768: where element_type_id = p_element_type_id
3769: group by element_type_id;
3770: --
3771: create_element_type (p_element_type_id,

Line 3874: l_element_type_id pay_element_types_f.element_type_id%type;

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;
3877: l_legislation_code pay_element_types_f.legislation_code%type;
3878: l_leg_code_ben pay_element_types_f.legislation_code%type;

Line 3875: l_element_name pay_element_types_f.element_name%type;

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;
3877: l_legislation_code pay_element_types_f.legislation_code%type;
3878: l_leg_code_ben pay_element_types_f.legislation_code%type;
3879: l_uom varchar2(30); -- unit of measure

Line 3876: l_multiple_entries pay_element_types_f.multiple_entries_allowed_flag%type;

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;
3877: l_legislation_code pay_element_types_f.legislation_code%type;
3878: l_leg_code_ben pay_element_types_f.legislation_code%type;
3879: l_uom varchar2(30); -- unit of measure
3880: l_business_group_id number;

Line 3877: l_legislation_code pay_element_types_f.legislation_code%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;
3877: l_legislation_code pay_element_types_f.legislation_code%type;
3878: l_leg_code_ben pay_element_types_f.legislation_code%type;
3879: l_uom varchar2(30); -- unit of measure
3880: l_business_group_id number;
3881: l_start_string varchar2(240);

Line 3878: l_leg_code_ben pay_element_types_f.legislation_code%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;
3877: l_legislation_code pay_element_types_f.legislation_code%type;
3878: l_leg_code_ben pay_element_types_f.legislation_code%type;
3879: l_uom varchar2(30); -- unit of measure
3880: l_business_group_id number;
3881: l_start_string varchar2(240);
3882: l_end_string varchar2(240);

Line 3890: l_legislation_code1 pay_element_types_f.legislation_code%type;

3886: l_record_inserted boolean;
3887: l_full_mls boolean;
3888: l_base_dbi_name varchar2(2000);
3889: l_user_entity_id number;
3890: l_legislation_code1 pay_element_types_f.legislation_code%type;
3891: l_startup_mode varchar2(30);
3892: l_languages dbms_sql.varchar2s;
3893: l_dbi_prefixes t_dbi_prefixes;
3894: --

Line 3920: from pay_element_types_f

3916: to_char(effective_start_date, 'DD-MM-YYYY') esd,
3917: to_char(effective_end_date, 'DD-MM-YYYY') eed,
3918: legislation_code,
3919: business_group_id
3920: from pay_element_types_f
3921: where element_type_id = p_el_id;
3922:
3923: -- This procedure is used to translate hardcoded "Pay Value"
3924: -- for each language installed.

Line 4001: , pay_element_types_f ET

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
4005: and ET.element_type_id = INPUTV.element_type_id

Line 4805: from pay_element_types_f e

4801: procedure refresh_element_types(p_worker_id in number default 0,
4802: p_maxworkers in number default 1) is
4803: cursor c1 is select element_type_id,
4804: max(effective_end_date)
4805: from pay_element_types_f e
4806: where not exists (
4807: select null
4808: from ff_user_entities u
4809: where u.creator_id = e.element_type_id

Line 4929: from pay_element_types_f a

4925: p_worker_id in number default 0,
4926: p_maxworkers in number default 1) is
4927: cursor c1 is select element_type_id,
4928: max(effective_end_date)
4929: from pay_element_types_f a
4930: where not exists (
4931: select null
4932: from ff_user_entities u
4933: where u.creator_id = a.element_type_id

Line 5073: from pay_element_types_f x

5069: delete ff_user_entities u
5070: where u.creator_type = 'E'
5071: and exists (
5072: select null
5073: from pay_element_types_f x
5074: where u.creator_id = x.element_type_id);
5075: end;
5076: --
5077: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 5116: from pay_element_types_f x

5112: delete ff_user_entities u
5113: where u.creator_type = 'E'
5114: and exists (
5115: select null
5116: from pay_element_types_f x
5117: where u.creator_id = x.element_type_id
5118: and (x.legislation_code = p_leg_code
5119: or exists
5120: (select null

Line 5545: from pay_element_types_f et

5541: OR
5542: -- E
5543: (not exists (
5544: select null
5545: from pay_element_types_f et
5546: where ent.creator_id = et.element_type_id
5547: and ent.creator_type = 'E'))
5548: OR
5549: -- I

Line 8328: from pay_element_types_f et

8324: ) is
8325: select et.element_name
8326: , et.legislation_code
8327: , et.business_group_id
8328: from pay_element_types_f et
8329: where et.element_type_id = p_element_type_id
8330: ;
8331: --
8332: l_prefix varchar2(240);

Line 8333: l_ele_name pay_element_types_f.element_name%type;

8329: where et.element_type_id = p_element_type_id
8330: ;
8331: --
8332: l_prefix varchar2(240);
8333: l_ele_name pay_element_types_f.element_name%type;
8334: l_found boolean;
8335: l_leg_code pay_element_types_f.legislation_code%type;
8336: l_bg_id pay_element_types_f.business_group_id%type;
8337: begin

Line 8335: l_leg_code pay_element_types_f.legislation_code%type;

8331: --
8332: l_prefix varchar2(240);
8333: l_ele_name pay_element_types_f.element_name%type;
8334: l_found boolean;
8335: l_leg_code pay_element_types_f.legislation_code%type;
8336: l_bg_id pay_element_types_f.business_group_id%type;
8337: begin
8338: --
8339: -- Fetch the element name if necessary.

Line 8336: l_bg_id pay_element_types_f.business_group_id%type;

8332: l_prefix varchar2(240);
8333: l_ele_name pay_element_types_f.element_name%type;
8334: l_found boolean;
8335: l_leg_code pay_element_types_f.legislation_code%type;
8336: l_bg_id pay_element_types_f.business_group_id%type;
8337: begin
8338: --
8339: -- Fetch the element name if necessary.
8340: --

Line 8390: from pay_element_types_f et

8386: ) is
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: ;

Line 8519: from pay_element_types_f_tl ettl

8515: (p_element_type_id in number
8516: ,p_language in varchar2
8517: ) is
8518: select ettl.element_name
8519: from pay_element_types_f_tl ettl
8520: where ettl.element_type_id = p_element_type_id
8521: and ettl.language = p_language
8522: ;
8523: --

Line 8573: , pay_element_types_f_tl ettl

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
8577: iv.effective_start_date and iv.effective_end_date

Line 8586: l_ele_name pay_element_types_f_tl.element_name%type;

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
8590: --

Line 9184: -- Interface 1: does not reference PAY_ELEMENT_TYPES_F_TL - the core

9180: -- Update dbis for an element type --
9181: -- =============================== --
9182:
9183: --
9184: -- Interface 1: does not reference PAY_ELEMENT_TYPES_F_TL - the core
9185: -- interface.
9186: --
9187: procedure update_element_type
9188: (p_element_type_id in number

Line 9214: from pay_element_types_f et

9210: ) is
9211: select et.benefit_classification_id
9212: , et.legislation_code
9213: , et.business_group_id
9214: from pay_element_types_f et
9215: where et.element_type_id = p_element_type_id
9216: and p_effective_date between
9217: et.effective_start_date and et.effective_end_date
9218: ;

Line 9618: -- Interface 2: references PAY_ELEMENT_TYPES_F_TL.

9614:
9615: end update_element_type;
9616:
9617: --
9618: -- Interface 2: references PAY_ELEMENT_TYPES_F_TL.
9619: --
9620: procedure update_element_type
9621: (p_element_type_id in number
9622: ,p_effective_date in date

Line 9674: , pay_element_types_f et

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
9678: and et.element_type_id = iv.element_type_id

Line 9683: l_multi_entries pay_element_types_f.multiple_entries_allowed_flag%type;

9679: and p_effective_date between
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;

Line 10331: from pay_element_types_f et

10327: cursor csr_ele_eff_date
10328: (p_element_type_id in number
10329: ) is
10330: select et.effective_end_date
10331: from pay_element_types_f et
10332: where et.element_type_id = p_element_type_id
10333: order by 1 desc
10334: ;
10335: --