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_TYPES_F

Line 4791: from pay_element_types_f elt,

4787: bg_id number
4788: ) is
4789: select eev.screen_entry_value screen_entry_value,
4790: ele.element_entry_id
4791: from pay_element_types_f elt,
4792: pay_input_values_f ipv,
4793: pay_element_entries_f ele,
4794: pay_element_entry_values_f eev
4795: where trunc(eff_date)

Line 4849: From pay_element_types_f ele,

4845:
4846: Cursor Cur_Sal_Basis_name(p_bg_id NUMBER,p_ele_name VARCHAR2)
4847: IS
4848: Select pb.pay_basis_id
4849: From pay_element_types_f ele,
4850: pay_input_values_f inp,
4851: per_pay_bases pb
4852: where ele.business_group_id=p_bg_id
4853: and upper(element_name)=upper(p_ele_name)

Line 5008: CURSOR c_check_ele(c_element_name pay_element_types_f.element_name%type,

5004:
5005: l_equ_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
5006: -----GPPA Update46 End.
5007:
5008: CURSOR c_check_ele(c_element_name pay_element_types_f.element_name%type,
5009: c_effective_date pay_element_entries_f.effective_start_date%type,
5010: c_assignment_id pay_element_entries_f.assignment_id%type) IS
5011: SELECT 1
5012: FROM pay_element_entries_f pee, pay_element_types_f pet

Line 5012: FROM pay_element_entries_f pee, pay_element_types_f pet

5008: CURSOR c_check_ele(c_element_name pay_element_types_f.element_name%type,
5009: c_effective_date pay_element_entries_f.effective_start_date%type,
5010: c_assignment_id pay_element_entries_f.assignment_id%type) IS
5011: SELECT 1
5012: FROM pay_element_entries_f pee, pay_element_types_f pet
5013: WHERE pee.element_type_id = pet.element_type_id
5014: AND c_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
5015: AND c_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
5016: AND pet.element_name = c_element_name

Line 6701: from pay_element_types_f elt,

6697: ipv.input_value_id,
6698: ipv.uom,
6699: eev.screen_entry_value screen_entry_value,
6700: ele.object_version_number
6701: from pay_element_types_f elt,
6702: pay_input_values_f ipv,
6703: pay_element_entries_f ele,
6704: pay_element_entry_values_f eev
6705: where trunc(eff_date) between elt.effective_start_date