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_ELT_TO_BEN_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 263: (table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

259: FROM ghr_pa_history
260: WHERE person_id = p_person_id
261: AND (
262: (table_name = 'PER_PEOPLE_EXTRA_INFO' and information5 = 'GHR_US_PER_GROUP1') OR
263: (table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
264: AND information4 IN (SELECT b.input_value_id
265: FROM pay_element_types_f a,pay_input_values_f b
266: WHERE a.element_type_id = b.element_type_id
267: AND (

Line 351: ELSIF p_pa_history_rec.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN

347: hr_utility.set_location('Assigning values for FEHB Person EIT',5);
348: p_benefits_eit_rec.FEHB_Date_Eligibility_expires := p_pa_history_rec.information19;
349: p_benefits_eit_rec.FEHB_Date_temp_eligibility := p_pa_history_rec.information20;
350: p_benefits_eit_rec.FEHB_Date_dependent_cert_expir := p_pa_history_rec.information21;
351: ELSIF p_pa_history_rec.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN
352: l_element_name := NULL;
353: l_input_value := NULL;
354: l_input_value_id := p_pa_history_rec.information4;
355: FOR element_inpval_rec IN c_element_inpval(l_input_value_id)

Line 658: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;

654: l_effective_start_date pay_element_entries_f.effective_start_date%type;
655: l_effective_end_date pay_element_entries_f.effective_end_date%type;
656: l_element_entry_id pay_element_entries_f.element_entry_id%type;
657: l_object_version_number pay_element_entries_f.object_version_number%type;
658: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
659: l_screen_entry_value_enrol pay_element_entry_values_f.screen_entry_value%type;
660: l_effective_start_date_enrol pay_element_entry_values_f.effective_start_date%type;
661: l_effective_end_date_enrol pay_element_entry_values_f.effective_end_date%type;
662: l_business_group_id per_assignments_f.business_group_id%type;

Line 659: l_screen_entry_value_enrol pay_element_entry_values_f.screen_entry_value%type;

655: l_effective_end_date pay_element_entries_f.effective_end_date%type;
656: l_element_entry_id pay_element_entries_f.element_entry_id%type;
657: l_object_version_number pay_element_entries_f.object_version_number%type;
658: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
659: l_screen_entry_value_enrol pay_element_entry_values_f.screen_entry_value%type;
660: l_effective_start_date_enrol pay_element_entry_values_f.effective_start_date%type;
661: l_effective_end_date_enrol pay_element_entry_values_f.effective_end_date%type;
662: l_business_group_id per_assignments_f.business_group_id%type;
663: l_update_flag number := 0;

Line 660: l_effective_start_date_enrol pay_element_entry_values_f.effective_start_date%type;

656: l_element_entry_id pay_element_entries_f.element_entry_id%type;
657: l_object_version_number pay_element_entries_f.object_version_number%type;
658: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
659: l_screen_entry_value_enrol pay_element_entry_values_f.screen_entry_value%type;
660: l_effective_start_date_enrol pay_element_entry_values_f.effective_start_date%type;
661: l_effective_end_date_enrol pay_element_entry_values_f.effective_end_date%type;
662: l_business_group_id per_assignments_f.business_group_id%type;
663: l_update_flag number := 0;
664: l_health_plan_mod number := 0;

Line 661: l_effective_end_date_enrol pay_element_entry_values_f.effective_end_date%type;

657: l_object_version_number pay_element_entries_f.object_version_number%type;
658: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
659: l_screen_entry_value_enrol pay_element_entry_values_f.screen_entry_value%type;
660: l_effective_start_date_enrol pay_element_entry_values_f.effective_start_date%type;
661: l_effective_end_date_enrol pay_element_entry_values_f.effective_end_date%type;
662: l_business_group_id per_assignments_f.business_group_id%type;
663: l_update_flag number := 0;
664: l_health_plan_mod number := 0;
665: l_datetrack_update_mode varchar2(25);

Line 696: pay_element_entry_values_f f

692: pay_input_values_f b,
693: pay_element_links_f c,
694: pay_link_input_values_f d,
695: pay_element_entries_f e,
696: pay_element_entry_values_f f
697: where a.element_type_id = b.element_type_id
698: and a.element_type_id = c.element_type_id
699: and c.element_link_id = d.element_link_id
700: and b.input_value_id = d.input_value_id

Line 728: pay_element_entry_values_f f

724: pay_input_values_f b,
725: pay_element_links_f c,
726: pay_link_input_values_f d,
727: pay_element_entries_f e,
728: pay_element_entry_values_f f
729: where a.element_type_id = b.element_type_id
730: and a.element_type_id = c.element_type_id
731: and c.element_link_id = d.element_link_id
732: and b.input_value_id = d.input_value_id

Line 759: pay_element_entry_values_f f

755: pay_input_values_f b,
756: pay_element_links_f c,
757: pay_link_input_values_f d,
758: pay_element_entries_f e,
759: pay_element_entry_values_f f
760: where a.element_type_id = b.element_type_id
761: and a.element_type_id = c.element_type_id
762: and c.element_link_id = d.element_link_id
763: and b.input_value_id = d.input_value_id

Line 791: pay_element_entry_values_f f

787: pay_input_values_f b,
788: pay_element_links_f c,
789: pay_link_input_values_f d,
790: pay_element_entries_f e,
791: pay_element_entry_values_f f
792: where a.element_type_id = b.element_type_id
793: and a.element_type_id = c.element_type_id
794: and c.element_link_id = d.element_link_id
795: and b.input_value_id = d.input_value_id

Line 817: pay_element_entry_values_f f

813: pay_input_values_f b,
814: pay_element_links_f c,
815: pay_link_input_values_f d,
816: pay_element_entries_f e,
817: pay_element_entry_values_f f
818: where a.element_type_id = b.element_type_id
819: and a.element_type_id = c.element_type_id
820: and c.element_link_id = d.element_link_id
821: and b.input_value_id = d.input_value_id

Line 844: pay_element_entry_values_f f

840: pay_input_values_f b,
841: pay_element_links_f c,
842: pay_link_input_values_f d,
843: pay_element_entries_f e,
844: pay_element_entry_values_f f
845: where a.element_type_id = b.element_type_id
846: and a.element_type_id = c.element_type_id
847: and c.element_link_id = d.element_link_id
848: and b.input_value_id = d.input_value_id

Line 1157: pay_element_entry_values_f f

1153: pay_input_values_f b,
1154: pay_element_links_f c,
1155: pay_link_input_values_f d,
1156: pay_element_entries_f e,
1157: pay_element_entry_values_f f
1158: where a.element_type_id = b.element_type_id
1159: and a.element_type_id = c.element_type_id
1160: and c.element_link_id = d.element_link_id
1161: and b.input_value_id = d.input_value_id

Line 1188: pay_element_entry_values_f f

1184: pay_input_values_f b,
1185: pay_element_links_f c,
1186: pay_link_input_values_f d,
1187: pay_element_entries_f e,
1188: pay_element_entry_values_f f
1189: where a.element_type_id = b.element_type_id
1190: and a.element_type_id = c.element_type_id
1191: and c.element_link_id = d.element_link_id
1192: and b.input_value_id = d.input_value_id

Line 1218: pay_element_entry_values_f f

1214: pay_input_values_f b,
1215: pay_element_links_f c,
1216: pay_link_input_values_f d,
1217: pay_element_entries_f e,
1218: pay_element_entry_values_f f
1219: where a.element_type_id = b.element_type_id
1220: and a.element_type_id = c.element_type_id
1221: and c.element_link_id = d.element_link_id
1222: and b.input_value_id = d.input_value_id

Line 1249: pay_element_entry_values_f f

1245: pay_input_values_f b,
1246: pay_element_links_f c,
1247: pay_link_input_values_f d,
1248: pay_element_entries_f e,
1249: pay_element_entry_values_f f
1250: where a.element_type_id = b.element_type_id
1251: and a.element_type_id = c.element_type_id
1252: and c.element_link_id = d.element_link_id
1253: and b.input_value_id = d.input_value_id

Line 1274: pay_element_entry_values_f f

1270: pay_input_values_f b,
1271: pay_element_links_f c,
1272: pay_link_input_values_f d,
1273: pay_element_entries_f e,
1274: pay_element_entry_values_f f
1275: where a.element_type_id = b.element_type_id
1276: and a.element_type_id = c.element_type_id
1277: and c.element_link_id = d.element_link_id
1278: and b.input_value_id = d.input_value_id

Line 1301: pay_element_entry_values_f f

1297: pay_input_values_f b,
1298: pay_element_links_f c,
1299: pay_link_input_values_f d,
1300: pay_element_entries_f e,
1301: pay_element_entry_values_f f
1302: where a.element_type_id = b.element_type_id
1303: and a.element_type_id = c.element_type_id
1304: and c.element_link_id = d.element_link_id
1305: and b.input_value_id = d.input_value_id