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_ENTRIES_F

Line 642: l_assignment_id pay_element_entries_f.assignment_id%type;

638: PROCEDURE execute_conv_hlt_plan ( p_errbuf OUT NOCOPY VARCHAR2,
639: p_retcode OUT NOCOPY NUMBER,
640: p_business_group_id in Number) is
641:
642: l_assignment_id pay_element_entries_f.assignment_id%type;
643: l_req VARCHAR2 (25);
644: l_full_name per_people_f.full_name%type; --bug# 10419074
645: l_log_text VARCHAR2(2000); --bug# 10419074
646: l_program_name ghr_process_log.program_name%TYPE;

Line 669: l_effective_start_date pay_element_entries_f.effective_start_date%type;

665: l_effective_date date;
666: l_name pay_input_values_f.name%type;
667: l_input_value_id pay_input_values_f.input_value_id%type;
668: l_input_value_id_enrol pay_input_values_f.input_value_id%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;

Line 670: l_effective_end_date pay_element_entries_f.effective_end_date%type;

666: l_name pay_input_values_f.name%type;
667: l_input_value_id pay_input_values_f.input_value_id%type;
668: l_input_value_id_enrol pay_input_values_f.input_value_id%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;

Line 671: l_element_entry_id pay_element_entries_f.element_entry_id%type;

667: l_input_value_id pay_input_values_f.input_value_id%type;
668: l_input_value_id_enrol pay_input_values_f.input_value_id%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;

Line 672: l_object_version_number pay_element_entries_f.object_version_number%type;

668: l_input_value_id_enrol pay_input_values_f.input_value_id%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;

Line 682: l_out_effective_start_date pay_element_entries_f.effective_start_date%type;

678: l_update_flag number := 0;
679: l_health_plan_mod number := 0;
680: l_datetrack_update_mode varchar2(25);
681:
682: l_out_effective_start_date pay_element_entries_f.effective_start_date%type;
683: l_out_effective_end_date pay_element_entries_f.effective_end_date%type;
684: l_out_update_warning boolean;
685:
686: l_exists boolean := false;

Line 683: l_out_effective_end_date pay_element_entries_f.effective_end_date%type;

679: l_health_plan_mod number := 0;
680: l_datetrack_update_mode varchar2(25);
681:
682: l_out_effective_start_date pay_element_entries_f.effective_start_date%type;
683: l_out_effective_end_date pay_element_entries_f.effective_end_date%type;
684: l_out_update_warning boolean;
685:
686: l_exists boolean := false;
687: l_check_date date;

Line 726: pay_element_entries_f e,

722: from pay_element_types_f a,
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

Line 758: pay_element_entries_f e,

754: from pay_element_types_f a,
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

Line 789: pay_element_entries_f e,

785: from pay_element_types_f a,
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

Line 821: pay_element_entries_f e,

817: from pay_element_types_f a,
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

Line 847: pay_element_entries_f e,

843: from pay_element_types_f a,
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

Line 874: pay_element_entries_f e,

870: from pay_element_types_f a,
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

Line 1179: pay_element_entries_f e,

1175: from pay_element_types_f a,
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

Line 1210: pay_element_entries_f e,

1206: from pay_element_types_f a,
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

Line 1240: pay_element_entries_f e,

1236: from pay_element_types_f a,
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

Line 1271: pay_element_entries_f e,

1267: from pay_element_types_f a,
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

Line 1296: pay_element_entries_f e,

1292: from pay_element_types_f a,
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

Line 1323: pay_element_entries_f e,

1319: from pay_element_types_f a,
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

Line 1633: pay_element_entries_f e,

1629: from pay_element_types_f a,
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

Line 1664: pay_element_entries_f e,

1660: from pay_element_types_f a,
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

Line 1694: pay_element_entries_f e,

1690: from pay_element_types_f a,
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

Line 1725: pay_element_entries_f e,

1721: from pay_element_types_f a,
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

Line 1750: pay_element_entries_f e,

1746: from pay_element_types_f a,
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

Line 1777: pay_element_entries_f e,

1773: from pay_element_types_f a,
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

Line 2065: l_assignment_id pay_element_entries_f.assignment_id%type;

2061: p_agency_effective_date in varchar2,
2062: p_agency_code IN varchar2,
2063: p_agency_sub_code IN varchar2) IS
2064:
2065: l_assignment_id pay_element_entries_f.assignment_id%type;
2066: l_position_id per_all_assignments_f.position_id%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;

Line 2083: l_elmnt_effective_start_date pay_element_entries_f.effective_start_date%type;

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;
2087: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;

Line 2084: l_elmnt_effective_end_date pay_element_entries_f.effective_end_date%type;

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;
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;

Line 2085: l_element_entry_id pay_element_entries_f.element_entry_id%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;
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;

Line 2086: l_object_version_number pay_element_entries_f.object_version_number%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;
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;

Line 2094: l_out_effective_start_date pay_element_entries_f.effective_start_date%type;

2090: l_cotrib_update_flag number := 0;
2091: l_elig_date_flag number := 0;
2092: l_datetrack_update_mode varchar2(25);
2093:
2094: l_out_effective_start_date pay_element_entries_f.effective_start_date%type;
2095: l_out_effective_end_date pay_element_entries_f.effective_end_date%type;
2096: l_out_update_warning boolean;
2097:
2098: l_exists boolean := false;

Line 2095: l_out_effective_end_date pay_element_entries_f.effective_end_date%type;

2091: l_elig_date_flag number := 0;
2092: l_datetrack_update_mode varchar2(25);
2093:
2094: l_out_effective_start_date pay_element_entries_f.effective_start_date%type;
2095: l_out_effective_end_date pay_element_entries_f.effective_end_date%type;
2096: l_out_update_warning boolean;
2097:
2098: l_exists boolean := false;
2099: l_check_date date;

Line 2157: pay_element_entries_f e,

2153: from pay_element_types_f a,
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

Line 2187: pay_element_entries_f e,

2183: from pay_element_types_f a,
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

Line 2212: pay_element_entries_f e,

2208: from pay_element_types_f a,
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