APPS.HRI_BPL_PERF_RATING dependencies on HR_GENERAL

Line 679: nvl(ppos.actual_termination_date,hr_general.end_of_time) termination_date

675: pevt.type perf_review_type,
676: NULL app_temp_name,
677: hri_bpl_perf_rating.get_perf_rating_val (perf.review_date,
678: :p_business_group_id,perf.performance_rating,pevt.type,null) nrmlsd_rating,
679: nvl(ppos.actual_termination_date,hr_general.end_of_time) termination_date
680: FROM per_performance_reviews perf,
681: per_events pevt,
682: per_all_assignments_f asgn,
683: per_periods_of_service ppos

Line 701: nvl(ppos.actual_termination_date,hr_general.end_of_time)';

697: AND ppos.person_id = asgn.person_id
698: AND ppos.period_of_service_id = asgn.period_of_service_id
699: AND ppos.date_start = :p_hire_date
700: AND perf.review_date between ppos.date_start and
701: nvl(ppos.actual_termination_date,hr_general.end_of_time)';
702: --
703: -- Determine if Assignment_Id exists in appraisals table
704: -- Bug 4873576, schema name required for performance reason
705: --

Line 741: nvl(ppos.actual_termination_date,hr_general.end_of_time) termination_date

737: null perf_review_type,
738: papt.name app_temp_name,
739: hri_bpl_perf_rating.get_perf_rating_val(papp.appraisal_date ,
740: :p_business_group_id,prl.step_value,null,papt.name) nrmlsd_rating,
741: nvl(ppos.actual_termination_date,hr_general.end_of_time) termination_date
742: FROM per_appraisals papp,
743: per_rating_levels prl,
744: per_appraisal_templates papt,
745: per_all_assignments_f asgn,

Line 766: AND nvl(ppos.actual_termination_date,hr_general.end_of_time)

762: AND papp.appraisal_date BETWEEN asgn.effective_start_date AND asgn.effective_end_date
763: AND ppos.person_id = asgn.person_id
764: AND ppos.period_of_service_id = asgn.period_of_service_id
765: AND papp.appraisal_date between ppos.date_start
766: AND nvl(ppos.actual_termination_date,hr_general.end_of_time)
767: AND ppos.date_start = :p_hire_date
768: ';
769: --
770: -- Case when the assignment_id column is present in per_appraisals (new version)

Line 1012: hr_general.decode_organization(p_business_group_id));

1008: --
1009: fnd_message.set_token('FF_NAME', l_ff_name);
1010: fnd_message.set_token('PERSON_NAME', l_person_name);
1011: fnd_message.set_token('BUSINESS_GROUP_ID',
1012: hr_general.decode_organization(p_business_group_id));
1013: fnd_message.set_token('APPRAISAL_TEMPLATE_NAME', p_appraisal_template_name);
1014: fnd_message.set_token('REVIEW_TYPE', p_review_type);
1015: fnd_message.set_token('PERF_RATING_CD', p_perf_rating_cd);
1016: fnd_message.set_token('PERF_NRMLSD_RATING', p_perf_nrmlsd_rating);