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 266: (table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

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

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

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

Line 673: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;

669: l_effective_start_date pay_element_entries_f.effective_start_date%type;
670: l_effective_end_date pay_element_entries_f.effective_end_date%type;
671: l_element_entry_id pay_element_entries_f.element_entry_id%type;
672: l_object_version_number pay_element_entries_f.object_version_number%type;
673: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
674: l_screen_entry_value_enrol pay_element_entry_values_f.screen_entry_value%type;
675: l_effective_start_date_enrol pay_element_entry_values_f.effective_start_date%type;
676: l_effective_end_date_enrol pay_element_entry_values_f.effective_end_date%type;
677: l_business_group_id per_assignments_f.business_group_id%type;

Line 674: l_screen_entry_value_enrol pay_element_entry_values_f.screen_entry_value%type;

670: l_effective_end_date pay_element_entries_f.effective_end_date%type;
671: l_element_entry_id pay_element_entries_f.element_entry_id%type;
672: l_object_version_number pay_element_entries_f.object_version_number%type;
673: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
674: l_screen_entry_value_enrol pay_element_entry_values_f.screen_entry_value%type;
675: l_effective_start_date_enrol pay_element_entry_values_f.effective_start_date%type;
676: l_effective_end_date_enrol pay_element_entry_values_f.effective_end_date%type;
677: l_business_group_id per_assignments_f.business_group_id%type;
678: l_update_flag number := 0;

Line 675: l_effective_start_date_enrol pay_element_entry_values_f.effective_start_date%type;

671: l_element_entry_id pay_element_entries_f.element_entry_id%type;
672: l_object_version_number pay_element_entries_f.object_version_number%type;
673: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
674: l_screen_entry_value_enrol pay_element_entry_values_f.screen_entry_value%type;
675: l_effective_start_date_enrol pay_element_entry_values_f.effective_start_date%type;
676: l_effective_end_date_enrol pay_element_entry_values_f.effective_end_date%type;
677: l_business_group_id per_assignments_f.business_group_id%type;
678: l_update_flag number := 0;
679: l_health_plan_mod number := 0;

Line 676: l_effective_end_date_enrol pay_element_entry_values_f.effective_end_date%type;

672: l_object_version_number pay_element_entries_f.object_version_number%type;
673: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
674: l_screen_entry_value_enrol pay_element_entry_values_f.screen_entry_value%type;
675: l_effective_start_date_enrol pay_element_entry_values_f.effective_start_date%type;
676: l_effective_end_date_enrol pay_element_entry_values_f.effective_end_date%type;
677: l_business_group_id per_assignments_f.business_group_id%type;
678: l_update_flag number := 0;
679: l_health_plan_mod number := 0;
680: l_datetrack_update_mode varchar2(25);

Line 727: pay_element_entry_values_f f

723: pay_input_values_f b,
724: pay_element_links_f c,
725: pay_link_input_values_f d,
726: pay_element_entries_f e,
727: pay_element_entry_values_f f
728: where a.element_type_id = b.element_type_id
729: and a.element_type_id = c.element_type_id
730: and c.element_link_id = d.element_link_id
731: 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 790: pay_element_entry_values_f f

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

Line 822: pay_element_entry_values_f f

818: pay_input_values_f b,
819: pay_element_links_f c,
820: pay_link_input_values_f d,
821: pay_element_entries_f e,
822: pay_element_entry_values_f f
823: where a.element_type_id = b.element_type_id
824: and a.element_type_id = c.element_type_id
825: and c.element_link_id = d.element_link_id
826: and b.input_value_id = d.input_value_id

Line 848: pay_element_entry_values_f f

844: pay_input_values_f b,
845: pay_element_links_f c,
846: pay_link_input_values_f d,
847: pay_element_entries_f e,
848: pay_element_entry_values_f f
849: where a.element_type_id = b.element_type_id
850: and a.element_type_id = c.element_type_id
851: and c.element_link_id = d.element_link_id
852: and b.input_value_id = d.input_value_id

Line 875: pay_element_entry_values_f f

871: pay_input_values_f b,
872: pay_element_links_f c,
873: pay_link_input_values_f d,
874: pay_element_entries_f e,
875: pay_element_entry_values_f f
876: where a.element_type_id = b.element_type_id
877: and a.element_type_id = c.element_type_id
878: and c.element_link_id = d.element_link_id
879: and b.input_value_id = d.input_value_id

Line 1180: pay_element_entry_values_f f

1176: pay_input_values_f b,
1177: pay_element_links_f c,
1178: pay_link_input_values_f d,
1179: pay_element_entries_f e,
1180: pay_element_entry_values_f f
1181: where a.element_type_id = b.element_type_id
1182: and a.element_type_id = c.element_type_id
1183: and c.element_link_id = d.element_link_id
1184: and b.input_value_id = d.input_value_id

Line 1211: pay_element_entry_values_f f

1207: pay_input_values_f b,
1208: pay_element_links_f c,
1209: pay_link_input_values_f d,
1210: pay_element_entries_f e,
1211: pay_element_entry_values_f f
1212: where a.element_type_id = b.element_type_id
1213: and a.element_type_id = c.element_type_id
1214: and c.element_link_id = d.element_link_id
1215: and b.input_value_id = d.input_value_id

Line 1241: pay_element_entry_values_f f

1237: pay_input_values_f b,
1238: pay_element_links_f c,
1239: pay_link_input_values_f d,
1240: pay_element_entries_f e,
1241: pay_element_entry_values_f f
1242: where a.element_type_id = b.element_type_id
1243: and a.element_type_id = c.element_type_id
1244: and c.element_link_id = d.element_link_id
1245: and b.input_value_id = d.input_value_id

Line 1272: pay_element_entry_values_f f

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

Line 1297: pay_element_entry_values_f f

1293: pay_input_values_f b,
1294: pay_element_links_f c,
1295: pay_link_input_values_f d,
1296: pay_element_entries_f e,
1297: pay_element_entry_values_f f
1298: where a.element_type_id = b.element_type_id
1299: and a.element_type_id = c.element_type_id
1300: and c.element_link_id = d.element_link_id
1301: and b.input_value_id = d.input_value_id

Line 1324: pay_element_entry_values_f f

1320: pay_input_values_f b,
1321: pay_element_links_f c,
1322: pay_link_input_values_f d,
1323: pay_element_entries_f e,
1324: pay_element_entry_values_f f
1325: where a.element_type_id = b.element_type_id
1326: and a.element_type_id = c.element_type_id
1327: and c.element_link_id = d.element_link_id
1328: and b.input_value_id = d.input_value_id

Line 1634: pay_element_entry_values_f f

1630: pay_input_values_f b,
1631: pay_element_links_f c,
1632: pay_link_input_values_f d,
1633: pay_element_entries_f e,
1634: pay_element_entry_values_f f
1635: where a.element_type_id = b.element_type_id
1636: and a.element_type_id = c.element_type_id
1637: and c.element_link_id = d.element_link_id
1638: and b.input_value_id = d.input_value_id

Line 1665: pay_element_entry_values_f f

1661: pay_input_values_f b,
1662: pay_element_links_f c,
1663: pay_link_input_values_f d,
1664: pay_element_entries_f e,
1665: pay_element_entry_values_f f
1666: where a.element_type_id = b.element_type_id
1667: and a.element_type_id = c.element_type_id
1668: and c.element_link_id = d.element_link_id
1669: and b.input_value_id = d.input_value_id

Line 1695: pay_element_entry_values_f f

1691: pay_input_values_f b,
1692: pay_element_links_f c,
1693: pay_link_input_values_f d,
1694: pay_element_entries_f e,
1695: pay_element_entry_values_f f
1696: where a.element_type_id = b.element_type_id
1697: and a.element_type_id = c.element_type_id
1698: and c.element_link_id = d.element_link_id
1699: and b.input_value_id = d.input_value_id

Line 1726: pay_element_entry_values_f f

1722: pay_input_values_f b,
1723: pay_element_links_f c,
1724: pay_link_input_values_f d,
1725: pay_element_entries_f e,
1726: pay_element_entry_values_f f
1727: where a.element_type_id = b.element_type_id
1728: and a.element_type_id = c.element_type_id
1729: and c.element_link_id = d.element_link_id
1730: and b.input_value_id = d.input_value_id

Line 1751: pay_element_entry_values_f f

1747: pay_input_values_f b,
1748: pay_element_links_f c,
1749: pay_link_input_values_f d,
1750: pay_element_entries_f e,
1751: pay_element_entry_values_f f
1752: where a.element_type_id = b.element_type_id
1753: and a.element_type_id = c.element_type_id
1754: and c.element_link_id = d.element_link_id
1755: and b.input_value_id = d.input_value_id

Line 1778: pay_element_entry_values_f f

1774: pay_input_values_f b,
1775: pay_element_links_f c,
1776: pay_link_input_values_f d,
1777: pay_element_entries_f e,
1778: pay_element_entry_values_f f
1779: where a.element_type_id = b.element_type_id
1780: and a.element_type_id = c.element_type_id
1781: and c.element_link_id = d.element_link_id
1782: and b.input_value_id = d.input_value_id

Line 2071: l_retirement_plan pay_element_entry_values_f.screen_entry_value%type;

2067: l_person_id per_all_assignments_f.person_id%type;
2068: l_agncy_contrib_elig_date per_people_extra_info.pei_information14%type;
2069: l_effective_start_date per_all_people_f.effective_start_date%type;
2070: l_effective_end_date per_all_people_f.effective_end_date%type;
2071: l_retirement_plan pay_element_entry_values_f.screen_entry_value%type;
2072: l_agency_effective_date date;
2073: l_calculated_date date;
2074: l_req VARCHAR2 (25);
2075: l_program_name ghr_process_log.program_name%TYPE;

Line 2082: l_tsp_start_date pay_element_entry_values_f.screen_entry_value%type;

2078: l_effective_date date;
2079:
2080: l_name pay_input_values_f.name%type;
2081: l_input_value_id pay_input_values_f.input_value_id%type;
2082: l_tsp_start_date pay_element_entry_values_f.screen_entry_value%type;
2083: l_elmnt_effective_start_date pay_element_entries_f.effective_start_date%type;
2084: l_elmnt_effective_end_date pay_element_entries_f.effective_end_date%type;
2085: l_element_entry_id pay_element_entries_f.element_entry_id%type;
2086: l_object_version_number pay_element_entries_f.object_version_number%type;

Line 2087: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;

2083: l_elmnt_effective_start_date pay_element_entries_f.effective_start_date%type;
2084: l_elmnt_effective_end_date pay_element_entries_f.effective_end_date%type;
2085: l_element_entry_id pay_element_entries_f.element_entry_id%type;
2086: l_object_version_number pay_element_entries_f.object_version_number%type;
2087: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
2088: l_business_group_id per_assignments_f.business_group_id%type;
2089: l_update_flag number := 0;
2090: l_cotrib_update_flag number := 0;
2091: l_elig_date_flag number := 0;

Line 2158: pay_element_entry_values_f f

2154: pay_input_values_f b,
2155: pay_element_links_f c,
2156: pay_link_input_values_f d,
2157: pay_element_entries_f e,
2158: pay_element_entry_values_f f
2159: where a.element_type_id = b.element_type_id
2160: and a.element_type_id = c.element_type_id
2161: and c.element_link_id = d.element_link_id
2162: and b.input_value_id = d.input_value_id

Line 2188: pay_element_entry_values_f f

2184: pay_input_values_f b,
2185: pay_element_links_f c,
2186: pay_link_input_values_f d,
2187: pay_element_entries_f e,
2188: pay_element_entry_values_f f
2189: where a.element_type_id = b.element_type_id
2190: and a.element_type_id = c.element_type_id
2191: and c.element_link_id = d.element_link_id
2192: and b.input_value_id = d.input_value_id

Line 2213: pay_element_entry_values_f f

2209: pay_input_values_f b,
2210: pay_element_links_f c,
2211: pay_link_input_values_f d,
2212: pay_element_entries_f e,
2213: pay_element_entry_values_f f
2214: where a.element_type_id = b.element_type_id
2215: and a.element_type_id = c.element_type_id
2216: and c.element_link_id = d.element_link_id
2217: and b.input_value_id = d.input_value_id