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.GHR_SF52_DO_UPDATE dependencies on PAY_ELEMENT_ENTRIES_F

Line 5052: pay_element_entries_f ele,

5048: select eev.screen_entry_value screen_entry_value,
5049: ele.element_entry_id
5050: from pay_element_types_f elt,
5051: pay_input_values_f ipv,
5052: pay_element_entries_f ele,
5053: pay_element_entry_values_f eev
5054: where trunc(eff_date)
5055: between elt.effective_start_date and elt.effective_end_date
5056: and trunc(eff_date)

Line 5181: ll_element_entry_id pay_element_entries_f.element_entry_id%type;

5177: l_pay_intg BOOLEAN:=FALSE;
5178:
5179: ll_element_link_id pay_element_links_f.element_link_id%type;
5180: ll_input_value_id pay_input_values_f.input_value_id%type;
5181: ll_element_entry_id pay_element_entries_f.element_entry_id%type;
5182: ll_value pay_element_entry_values_f.screen_entry_value%type;
5183: ll_object_version_number pay_element_entries_f.object_version_number%type;
5184: ll_multiple_error_flag varchar2(50);
5185: l_error_text varchar2(4000);

Line 5183: ll_object_version_number pay_element_entries_f.object_version_number%type;

5179: ll_element_link_id pay_element_links_f.element_link_id%type;
5180: ll_input_value_id pay_input_values_f.input_value_id%type;
5181: ll_element_entry_id pay_element_entries_f.element_entry_id%type;
5182: ll_value pay_element_entry_values_f.screen_entry_value%type;
5183: ll_object_version_number pay_element_entries_f.object_version_number%type;
5184: ll_multiple_error_flag varchar2(50);
5185: l_error_text varchar2(4000);
5186: l_dt_mode varchar2(200);
5187:

Line 5268: c_effective_date pay_element_entries_f.effective_start_date%type,

5264: l_equ_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
5265: -----GPPA Update46 End.
5266:
5267: CURSOR c_check_ele(c_element_name pay_element_types_f.element_name%type,
5268: c_effective_date pay_element_entries_f.effective_start_date%type,
5269: c_assignment_id pay_element_entries_f.assignment_id%type) IS
5270: SELECT 1
5271: FROM pay_element_entries_f pee, pay_element_types_f pet
5272: WHERE pee.element_type_id = pet.element_type_id

Line 5269: c_assignment_id pay_element_entries_f.assignment_id%type) IS

5265: -----GPPA Update46 End.
5266:
5267: CURSOR c_check_ele(c_element_name pay_element_types_f.element_name%type,
5268: c_effective_date pay_element_entries_f.effective_start_date%type,
5269: c_assignment_id pay_element_entries_f.assignment_id%type) IS
5270: SELECT 1
5271: FROM pay_element_entries_f pee, pay_element_types_f pet
5272: WHERE pee.element_type_id = pet.element_type_id
5273: AND c_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date

Line 5271: FROM pay_element_entries_f pee, pay_element_types_f pet

5267: CURSOR c_check_ele(c_element_name pay_element_types_f.element_name%type,
5268: c_effective_date pay_element_entries_f.effective_start_date%type,
5269: c_assignment_id pay_element_entries_f.assignment_id%type) IS
5270: SELECT 1
5271: FROM pay_element_entries_f pee, pay_element_types_f pet
5272: WHERE pee.element_type_id = pet.element_type_id
5273: AND c_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
5274: AND c_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
5275: AND pet.element_name = c_element_name

Line 6979: pay_element_entries_f ele,

6975: eev.screen_entry_value screen_entry_value,
6976: ele.object_version_number
6977: from pay_element_types_f elt,
6978: pay_input_values_f ipv,
6979: pay_element_entries_f ele,
6980: pay_element_entry_values_f eev
6981: where trunc(eff_date) between elt.effective_start_date
6982: and elt.effective_end_date
6983: and trunc(eff_date) between ipv.effective_start_date

Line 7016: l_element_entry_id pay_element_entries_f.element_entry_id%type;

7012: l_business_group_id per_business_groups.business_group_id%type;
7013: l_input_value_id1 pay_input_values_f.input_value_id%type;
7014: l_input_value_id2 pay_input_values_f.input_value_id%type;
7015: l_input_value_id3 pay_input_values_f.input_value_id%type;
7016: l_element_entry_id pay_element_entries_f.element_entry_id%type;
7017: l_object_version_number pay_element_entries_f.object_version_number%type;
7018: l_update_mode VARCHAR2(25);
7019: l_ctr NUMBER;
7020: l_element_ctr NUMBER;

Line 7017: l_object_version_number pay_element_entries_f.object_version_number%type;

7013: l_input_value_id1 pay_input_values_f.input_value_id%type;
7014: l_input_value_id2 pay_input_values_f.input_value_id%type;
7015: l_input_value_id3 pay_input_values_f.input_value_id%type;
7016: l_element_entry_id pay_element_entries_f.element_entry_id%type;
7017: l_object_version_number pay_element_entries_f.object_version_number%type;
7018: l_update_mode VARCHAR2(25);
7019: l_ctr NUMBER;
7020: l_element_ctr NUMBER;
7021: l_update_warning boolean;