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 630: l_assignment_id pay_element_entries_f.assignment_id%type;

626: PROCEDURE execute_conv_hlt_plan ( p_errbuf OUT NOCOPY VARCHAR2,
627: p_retcode OUT NOCOPY NUMBER,
628: p_business_group_id in Number) is
629:
630: l_assignment_id pay_element_entries_f.assignment_id%type;
631: l_req VARCHAR2 (25);
632: l_ssn per_all_people_f.national_identifier%TYPE;
633: l_program_name ghr_process_log.program_name%TYPE;
634: cursor cur_business_group is

Line 654: l_effective_start_date pay_element_entries_f.effective_start_date%type;

650: l_effective_date date;
651: l_name pay_input_values_f.name%type;
652: l_input_value_id pay_input_values_f.input_value_id%type;
653: l_input_value_id_enrol pay_input_values_f.input_value_id%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;

Line 655: l_effective_end_date pay_element_entries_f.effective_end_date%type;

651: l_name pay_input_values_f.name%type;
652: l_input_value_id pay_input_values_f.input_value_id%type;
653: l_input_value_id_enrol pay_input_values_f.input_value_id%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;

Line 656: l_element_entry_id pay_element_entries_f.element_entry_id%type;

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

Line 657: l_object_version_number pay_element_entries_f.object_version_number%type;

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

Line 667: l_out_effective_start_date pay_element_entries_f.effective_start_date%type;

663: l_update_flag number := 0;
664: l_health_plan_mod number := 0;
665: l_datetrack_update_mode varchar2(25);
666:
667: l_out_effective_start_date pay_element_entries_f.effective_start_date%type;
668: l_out_effective_end_date pay_element_entries_f.effective_end_date%type;
669: l_out_update_warning boolean;
670:
671: l_exists boolean := false;

Line 668: l_out_effective_end_date pay_element_entries_f.effective_end_date%type;

664: l_health_plan_mod number := 0;
665: l_datetrack_update_mode varchar2(25);
666:
667: l_out_effective_start_date pay_element_entries_f.effective_start_date%type;
668: l_out_effective_end_date pay_element_entries_f.effective_end_date%type;
669: l_out_update_warning boolean;
670:
671: l_exists boolean := false;
672: l_check_date date;

Line 695: pay_element_entries_f e,

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

Line 727: pay_element_entries_f e,

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

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 790: pay_element_entries_f e,

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

Line 816: pay_element_entries_f e,

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

Line 843: pay_element_entries_f e,

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

Line 1156: pay_element_entries_f e,

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

Line 1187: pay_element_entries_f e,

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

Line 1217: pay_element_entries_f e,

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

Line 1248: pay_element_entries_f e,

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

Line 1273: pay_element_entries_f e,

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

Line 1300: pay_element_entries_f e,

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