APPS.PQH_FR_SPEED dependencies on HR_GENERAL

Line 125: AND appraisal_date >= NVL(p_appraisal_start_date,HR_GENERAL.start_of_time)

121: FROM per_appraisals
122: WHERE appraisee_person_id = p_person_id
123: AND type = p_appraisal_type
124: AND appraisal_system_status = p_appraisal_status
125: AND appraisal_date >= NVL(p_appraisal_start_date,HR_GENERAL.start_of_time)
126: AND appraisal_date <= NVL(p_appraisal_end_date,HR_GENERAL.end_of_time)
127: AND appraisal_date <= p_effective_date
128: ORDER BY appraisal_date DESC;
129: --

Line 126: AND appraisal_date <= NVL(p_appraisal_end_date,HR_GENERAL.end_of_time)

122: WHERE appraisee_person_id = p_person_id
123: AND type = p_appraisal_type
124: AND appraisal_system_status = p_appraisal_status
125: AND appraisal_date >= NVL(p_appraisal_start_date,HR_GENERAL.start_of_time)
126: AND appraisal_date <= NVL(p_appraisal_end_date,HR_GENERAL.end_of_time)
127: AND appraisal_date <= p_effective_date
128: ORDER BY appraisal_date DESC;
129: --
130: --Variable Declarations.

Line 333: p_speed_meaning := HR_GENERAL.decode_lookup('FR_PQH_PROGRESSION_SPEED',p_speed);

329: ELSE
330: l_speed_quota_chk := 'S'; --Quota check success because Speed Quota not defined
331: END IF;
332: --
333: p_speed_meaning := HR_GENERAL.decode_lookup('FR_PQH_PROGRESSION_SPEED',p_speed);
334: p_num_allowed := l_speed_quota;
335: p_return_status := l_speed_quota_chk;
336: --
337: END IF;

Line 662: AND p_effective_date BETWEEN NVL(start_date,HR_GENERAL.start_of_time) AND NVL(end_date,HR_GENERAL.end_of_time);

658: CURSOR csr_fnduser IS
659: SELECT user_name
660: FROM fnd_user
661: WHERE employee_id = p_mgr_id
662: AND p_effective_date BETWEEN NVL(start_date,HR_GENERAL.start_of_time) AND NVL(end_date,HR_GENERAL.end_of_time);
663: --
664: --Variable Declarations.
665: l_proc VARCHAR2(72) := g_package||'get_mgr_user';
666: BEGIN