APPS.HRI_OPL_PER_PERSON dependencies on HR_GENERAL

Line 584: ,NVL(per.date_of_birth,hr_general.start_of_time)

580: )
581: then 'Y'
582: else 'N'
583: end
584: ,NVL(per.date_of_birth,hr_general.start_of_time)
585: ,per.middle_names
586: ,per.known_as
587: ,per.honors
588: ,per.pre_name_adjunct

Line 604: ,NVL(per.date_of_death,hr_general.end_of_time)

600: ,per.global_name
601: ,per.last_name
602: ,decode(nvl(per.current_employee_flag,'N'),'Y','Y',current_npw_flag)
603: ,NVL(per.country_of_birth,'NA_EDW')
604: ,NVL(per.date_of_death,hr_general.end_of_time)
605: ,NVL(per.email_address,'NA_EDW')
606: ,per.title
607: ,per.suffix
608: ,per.first_name

Line 805: ,NVL(per.date_of_birth,hr_general.start_of_time)

801: )
802: then 'Y'
803: else 'N'
804: end
805: ,NVL(per.date_of_birth,hr_general.start_of_time)
806: ,per.middle_names
807: ,per.known_as
808: ,per.honors
809: ,per.pre_name_adjunct

Line 825: ,NVL(per.date_of_death,hr_general.end_of_time)

821: ,per.global_name
822: ,per.last_name
823: ,decode(nvl(per.current_employee_flag,'N'),'Y','Y',current_npw_flag)
824: ,NVL(per.country_of_birth,'NA_EDW')
825: ,NVL(per.date_of_death,hr_general.end_of_time)
826: ,NVL(per.email_address,'NA_EDW')
827: ,per.title
828: ,per.suffix
829: ,per.first_name

Line 931: ,hr_general.end_of_time

927: ,id_char
928: ,id_char
929: ,id_char
930: ,id_char
931: ,hr_general.end_of_time
932: ,id_char
933: ,id_char
934: ,hr_general.end_of_time
935: ,id_char

Line 934: ,hr_general.end_of_time

930: ,id_char
931: ,hr_general.end_of_time
932: ,id_char
933: ,id_char
934: ,hr_general.end_of_time
935: ,id_char
936: ,id_char
937: ,id_char
938: ,id

Line 939: ,hr_general.end_of_time

935: ,id_char
936: ,id_char
937: ,id_char
938: ,id
939: ,hr_general.end_of_time
940: ,hr_general.end_of_time
941: ,id_char
942: ,id_char
943: from hri_unassigned ;

Line 940: ,hr_general.end_of_time

936: ,id_char
937: ,id_char
938: ,id
939: ,hr_general.end_of_time
940: ,hr_general.end_of_time
941: ,id_char
942: ,id_char
943: from hri_unassigned ;
944:

Line 1101: g_start_date := hr_general.start_of_time;

1097: -- is correctly maintained.
1098: --
1099: IF g_full_refresh = g_is_full_refresh THEN
1100: --
1101: g_start_date := hr_general.start_of_time;
1102: g_end_date := SYSDATE;
1103: --
1104: -- log('Doing full refresh.');
1105: Full_Refresh;