DBA Data[Home] [Help]

APPS.HR_DM_BUSINESS dependencies on HR_GENERAL

Line 976: hr_general.start_of_time))

972: WHERE (status = 'F')
973: AND (business_group_id = l_business_group_id)
974: AND (migration_type = l_migration_type_test)
975: AND (effective_date > NVL(l_last_fw_date,
976: hr_general.start_of_time))
977: AND
978: (
979: (
980: UPPER(source_database_instance) =

Line 1032: hr_general.start_of_time)) THEN

1028: l_last_fw_date := NULL;
1029: OPEN csr_mig_date;
1030: FETCH csr_mig_date INTO l_last_date;
1031: IF (l_last_date > NVL(l_last_fw_date,
1032: hr_general.start_of_time)) THEN
1033: l_last_fw_date := l_last_date;
1034: END IF;
1035: CLOSE csr_mig_date;
1036:

Line 1057: IF (NVL(l_last_date, hr_general.start_of_time) >

1053:
1054: l_migration_type_test := r_migration_data.migration_type;
1055: OPEN csr_mig_date_othr;
1056: FETCH csr_mig_date_othr INTO l_last_date;
1057: IF (NVL(l_last_date, hr_general.start_of_time) >
1058: NVL(l_last_migration_date, hr_general.start_of_time)) THEN
1059: l_last_migration_date := l_last_date;
1060: END IF;
1061: CLOSE csr_mig_date_othr;

Line 1058: NVL(l_last_migration_date, hr_general.start_of_time)) THEN

1054: l_migration_type_test := r_migration_data.migration_type;
1055: OPEN csr_mig_date_othr;
1056: FETCH csr_mig_date_othr INTO l_last_date;
1057: IF (NVL(l_last_date, hr_general.start_of_time) >
1058: NVL(l_last_migration_date, hr_general.start_of_time)) THEN
1059: l_last_migration_date := l_last_date;
1060: END IF;
1061: CLOSE csr_mig_date_othr;
1062: