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

Line 450: pay_input_values_f iv

446: from sys.dual
447: where exists
448: (select 1
449: from pay_formula_result_rules_f frr,
450: pay_input_values_f iv
451: where p_element_type_id = iv.element_type_id
452: and iv.input_value_id = frr.input_value_id
453: and frr.effective_start_date <= p_val_end_date
454: and frr.effective_end_date >= p_val_start_date);

Line 526: pay_input_values_f iv,

522: from sys.dual
523: where exists (select 1
524: from pay_status_processing_rules_f spr,
525: pay_formula_result_rules_f fr,
526: pay_input_values_f iv,
527: pay_element_types_f et
528: where spr.element_type_id = p_element_type_id
529: and fr.result_rule_type = 'I'
530: and spr.status_processing_rule_id =

Line 560: pay_input_values_f iv,

556: from sys.dual
557: where exists(select 1
558: from pay_status_processing_rules_f spr,
559: pay_formula_result_rules_f fr,
560: pay_input_values_f iv,
561: pay_element_types_f et
562: where fr.input_value_id = iv.input_value_id
563: and fr.result_rule_type = 'I'
564: and iv.element_type_id = p_element_type_id

Line 618: from pay_input_values_f

614: CURSOR c_find_input_values(p_element_type_id number,
615: p_val_start_date date,
616: p_val_end_date date) is
617: select input_value_id
618: from pay_input_values_f
619: where p_element_type_id = element_type_id
620: And effective_end_date >= p_val_start_date
621: and effective_start_date <= p_val_end_date;
622: --

Line 806: insert into pay_input_values_f

802: hr_utility.set_location('hr_elements.ins_input_value', 3);
803: end if;
804: --
805: -- Create PAY_VALUE for element type.
806: insert into pay_input_values_f
807: (input_value_id,
808: effective_start_date,
809: effective_end_date,
810: element_type_id,

Line 855: insert into PAY_INPUT_VALUES_F_TL (

851: hr_utility.set_message_token('STEP','1');
852: hr_utility.raise_error;
853: end if;
854: --
855: insert into PAY_INPUT_VALUES_F_TL (
856: INPUT_VALUE_ID,
857: NAME,
858: LAST_UPDATE_DATE,
859: LAST_UPDATED_BY,

Line 879: from PAY_INPUT_VALUES_F_TL T

875: from FND_LANGUAGES L
876: where L.INSTALLED_FLAG in ('I', 'B')
877: and not exists
878: (select NULL
879: from PAY_INPUT_VALUES_F_TL T
880: where T.INPUT_VALUE_ID = v_input_value_id
881: and T.LANGUAGE = L.LANGUAGE_CODE);
882: --
883: if g_debug then

Line 927: -- is handled by an insert trigger on pay_input_values_f

923: --
924: -- Create any balance feeds that may be required ie. for any balances which
925: --
926: -- The insertion of rows into application ownerships for startup data
927: -- is handled by an insert trigger on pay_input_values_f
928: --
929: -- Create database items
930: --
931: hrdyndbi.create_input_value_dict(v_input_value_id,

Line 1421: from pay_input_values_f iv

1417: p_val_start_date date,
1418: p_val_end_date date) is
1419: select iv.input_value_id input_value_id,
1420: iv.generate_db_items_flag db_items_flag
1421: from pay_input_values_f iv
1422: where p_element_type_id = iv.element_type_id
1423: and iv.effective_start_date <= p_val_end_date
1424: and iv.effective_end_date >= p_val_start_date
1425: for update;

Line 1463: from pay_input_values_f iv

1459: delete from hr_application_ownerships ao
1460: where ao.key_name = 'INPUT_VALUE_ID'
1461: and exists
1462: (select 1
1463: from pay_input_values_f iv
1464: where iv.element_type_id = p_element_type_id
1465: and ao.key_value = to_char(iv.input_value_id));
1466: --
1467: end if;

Line 1469: delete from pay_input_values_f

1465: and ao.key_value = to_char(iv.input_value_id));
1466: --
1467: end if;
1468: --
1469: delete from pay_input_values_f
1470: where element_type_id = p_element_type_id;
1471: --
1472: elsif p_delete_mode = 'DELETE' then
1473: --

Line 1480: delete from pay_input_values_f

1476: hr_utility.set_location('hr_elements.del_3p_element_type', 3);
1477: end if;
1478: --
1479: -- delete all future records
1480: delete from pay_input_values_f
1481: where element_type_id = p_element_type_id
1482: and effective_start_date > p_val_session_date;
1483: --
1484: -- update current records so that the end date is the session date

Line 1485: update pay_input_values_f

1481: where element_type_id = p_element_type_id
1482: and effective_start_date > p_val_session_date;
1483: --
1484: -- update current records so that the end date is the session date
1485: update pay_input_values_f
1486: set effective_end_date = p_val_session_date
1487: where element_type_id = p_element_type_id
1488: and p_val_session_date between
1489: effective_start_date and effective_end_date;

Line 1527: update pay_input_values_f iv1

1523: end if;
1524: --
1525: v_end_of_time := to_date('31/12/4712', 'DD/MM/YYYY');
1526: --
1527: update pay_input_values_f iv1
1528: set iv1.effective_end_date = v_end_of_time
1529: where (iv1.input_value_id, iv1.effective_end_date) =
1530: (select iv2.input_value_id, max(iv2.effective_end_date)
1531: from pay_input_values_f iv2

Line 1531: from pay_input_values_f iv2

1527: update pay_input_values_f iv1
1528: set iv1.effective_end_date = v_end_of_time
1529: where (iv1.input_value_id, iv1.effective_end_date) =
1530: (select iv2.input_value_id, max(iv2.effective_end_date)
1531: from pay_input_values_f iv2
1532: where iv2.element_type_id = p_element_type_id
1533: group by iv2.input_value_id);
1534: --
1535: end if;