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.PER_QH_FIND_QUERY dependencies on HR_REPORTS

Line 1492: out_rec.background_chk_stat_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.background_check_status);

1488: --
1489: out_rec.last_name :=per_rec.last_name;
1490: out_rec.start_date :=per_rec.start_date;
1491: out_rec.applicant_number :=per_rec.applicant_number;
1492: out_rec.background_chk_stat_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.background_check_status);
1493: out_rec.background_date_check :=per_rec.background_date_check;
1494: out_rec.blood_type_meaning :=hr_reports.get_lookup_meaning('BLOOD_TYPE',per_rec.blood_type);
1495:
1496: --Modified for PMxbg

Line 1494: out_rec.blood_type_meaning :=hr_reports.get_lookup_meaning('BLOOD_TYPE',per_rec.blood_type);

1490: out_rec.start_date :=per_rec.start_date;
1491: out_rec.applicant_number :=per_rec.applicant_number;
1492: out_rec.background_chk_stat_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.background_check_status);
1493: out_rec.background_date_check :=per_rec.background_date_check;
1494: out_rec.blood_type_meaning :=hr_reports.get_lookup_meaning('BLOOD_TYPE',per_rec.blood_type);
1495:
1496: --Modified for PMxbg
1497: if per_rec.person_id is not null then
1498: open csr_bg_name(per_rec.business_group_id);

Line 1517: out_rec.expnse_chk_send_addr_meaning :=hr_reports.get_lookup_meaning('HOME_OFFICE',per_rec.expense_check_send_to_address);

1513: out_rec.date_employee_data_verified :=per_rec.date_employee_data_verified;
1514: out_rec.date_of_birth :=per_rec.date_of_birth;
1515: out_rec.email_address :=per_rec.email_address;
1516: out_rec.employee_number :=per_rec.employee_number;
1517: out_rec.expnse_chk_send_addr_meaning :=hr_reports.get_lookup_meaning('HOME_OFFICE',per_rec.expense_check_send_to_address);
1518: out_rec.npw_number :=per_rec.npw_number;
1519: out_rec.first_name :=per_rec.first_name;
1520: out_rec.per_fte_capacity :=per_rec.fte_capacity;
1521: out_rec.full_name :=per_rec.full_name;

Line 1529: out_rec.marital_status_meaning :=hr_reports.get_lookup_meaning('MAR_STATUS',per_rec.marital_status);

1525: out_rec.known_as :=per_rec.known_as;
1526: out_rec.last_medical_test_by :=per_rec.last_medical_test_by;
1527: out_rec.last_medical_test_date :=per_rec.last_medical_test_date;
1528: out_rec.mailstop :=per_rec.mailstop;
1529: out_rec.marital_status_meaning :=hr_reports.get_lookup_meaning('MAR_STATUS',per_rec.marital_status);
1530: out_rec.middle_names :=per_rec.middle_names;
1531: out_rec.nationality_meaning :=hr_reports.get_lookup_meaning('NATIONALITY',per_rec.nationality);
1532: out_rec.national_identifier :=per_rec.national_identifier;
1533: out_rec.office_number :=per_rec.office_number;

Line 1531: out_rec.nationality_meaning :=hr_reports.get_lookup_meaning('NATIONALITY',per_rec.nationality);

1527: out_rec.last_medical_test_date :=per_rec.last_medical_test_date;
1528: out_rec.mailstop :=per_rec.mailstop;
1529: out_rec.marital_status_meaning :=hr_reports.get_lookup_meaning('MAR_STATUS',per_rec.marital_status);
1530: out_rec.middle_names :=per_rec.middle_names;
1531: out_rec.nationality_meaning :=hr_reports.get_lookup_meaning('NATIONALITY',per_rec.nationality);
1532: out_rec.national_identifier :=per_rec.national_identifier;
1533: out_rec.office_number :=per_rec.office_number;
1534: out_rec.on_military_service_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.on_military_service);
1535: out_rec.pre_name_adjunct :=per_rec.pre_name_adjunct;

Line 1534: out_rec.on_military_service_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.on_military_service);

1530: out_rec.middle_names :=per_rec.middle_names;
1531: out_rec.nationality_meaning :=hr_reports.get_lookup_meaning('NATIONALITY',per_rec.nationality);
1532: out_rec.national_identifier :=per_rec.national_identifier;
1533: out_rec.office_number :=per_rec.office_number;
1534: out_rec.on_military_service_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.on_military_service);
1535: out_rec.pre_name_adjunct :=per_rec.pre_name_adjunct;
1536: out_rec.previous_last_name :=per_rec.previous_last_name;
1537: out_rec.rehire_recommendation :=per_rec.rehire_recommendation;
1538: out_rec.resume_exists_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.resume_exists);

Line 1538: out_rec.resume_exists_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.resume_exists);

1534: out_rec.on_military_service_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.on_military_service);
1535: out_rec.pre_name_adjunct :=per_rec.pre_name_adjunct;
1536: out_rec.previous_last_name :=per_rec.previous_last_name;
1537: out_rec.rehire_recommendation :=per_rec.rehire_recommendation;
1538: out_rec.resume_exists_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.resume_exists);
1539: out_rec.resume_last_updated :=per_rec.resume_last_updated;
1540: -- Bug 3037019
1541: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
1542: out_rec.secnd_passport_exsts_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.second_passport_exists);

Line 1541: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);

1537: out_rec.rehire_recommendation :=per_rec.rehire_recommendation;
1538: out_rec.resume_exists_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.resume_exists);
1539: out_rec.resume_last_updated :=per_rec.resume_last_updated;
1540: -- Bug 3037019
1541: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
1542: out_rec.secnd_passport_exsts_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.second_passport_exists);
1543: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
1544: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
1545: out_rec.suffix :=per_rec.suffix;

Line 1542: out_rec.secnd_passport_exsts_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.second_passport_exists);

1538: out_rec.resume_exists_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.resume_exists);
1539: out_rec.resume_last_updated :=per_rec.resume_last_updated;
1540: -- Bug 3037019
1541: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
1542: out_rec.secnd_passport_exsts_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.second_passport_exists);
1543: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
1544: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
1545: out_rec.suffix :=per_rec.suffix;
1546: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);

Line 1543: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);

1539: out_rec.resume_last_updated :=per_rec.resume_last_updated;
1540: -- Bug 3037019
1541: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
1542: out_rec.secnd_passport_exsts_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.second_passport_exists);
1543: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
1544: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
1545: out_rec.suffix :=per_rec.suffix;
1546: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
1547: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);

Line 1544: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);

1540: -- Bug 3037019
1541: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
1542: out_rec.secnd_passport_exsts_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.second_passport_exists);
1543: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
1544: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
1545: out_rec.suffix :=per_rec.suffix;
1546: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
1547: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
1548: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;

Line 1546: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);

1542: out_rec.secnd_passport_exsts_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.second_passport_exists);
1543: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
1544: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
1545: out_rec.suffix :=per_rec.suffix;
1546: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
1547: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
1548: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;
1549: out_rec.cord_ben_no_cvg_flag_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.coord_ben_no_cvg_flag);
1550: out_rec.dpdnt_adoption_date :=per_rec.dpdnt_adoption_date;

Line 1547: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);

1543: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
1544: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
1545: out_rec.suffix :=per_rec.suffix;
1546: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
1547: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
1548: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;
1549: out_rec.cord_ben_no_cvg_flag_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.coord_ben_no_cvg_flag);
1550: out_rec.dpdnt_adoption_date :=per_rec.dpdnt_adoption_date;
1551: out_rec.dpdnt_vlntry_svc_flg_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.dpdnt_vlntry_svce_flag);

Line 1549: out_rec.cord_ben_no_cvg_flag_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.coord_ben_no_cvg_flag);

1545: out_rec.suffix :=per_rec.suffix;
1546: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
1547: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
1548: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;
1549: out_rec.cord_ben_no_cvg_flag_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.coord_ben_no_cvg_flag);
1550: out_rec.dpdnt_adoption_date :=per_rec.dpdnt_adoption_date;
1551: out_rec.dpdnt_vlntry_svc_flg_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.dpdnt_vlntry_svce_flag);
1552: out_rec.receipt_of_death_cert_date :=per_rec.receipt_of_death_cert_date;
1553: out_rec.uses_tobacco_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.uses_tobacco_flag);

Line 1551: out_rec.dpdnt_vlntry_svc_flg_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.dpdnt_vlntry_svce_flag);

1547: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
1548: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;
1549: out_rec.cord_ben_no_cvg_flag_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.coord_ben_no_cvg_flag);
1550: out_rec.dpdnt_adoption_date :=per_rec.dpdnt_adoption_date;
1551: out_rec.dpdnt_vlntry_svc_flg_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.dpdnt_vlntry_svce_flag);
1552: out_rec.receipt_of_death_cert_date :=per_rec.receipt_of_death_cert_date;
1553: out_rec.uses_tobacco_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.uses_tobacco_flag);
1554: --
1555: if per_rec.benefit_group_id is not null then

Line 1553: out_rec.uses_tobacco_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.uses_tobacco_flag);

1549: out_rec.cord_ben_no_cvg_flag_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.coord_ben_no_cvg_flag);
1550: out_rec.dpdnt_adoption_date :=per_rec.dpdnt_adoption_date;
1551: out_rec.dpdnt_vlntry_svc_flg_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.dpdnt_vlntry_svce_flag);
1552: out_rec.receipt_of_death_cert_date :=per_rec.receipt_of_death_cert_date;
1553: out_rec.uses_tobacco_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.uses_tobacco_flag);
1554: --
1555: if per_rec.benefit_group_id is not null then
1556: open csr_benfts_grp(per_rec.benefit_group_id);
1557: fetch csr_benfts_grp into out_rec.benefit_group;

Line 1872: out_rec.employment_category_meaning :=hr_reports.get_lookup_meaning('EMP_CAT',asg_rec.employment_category);

1868: out_rec.asg_primary_flag :=asg_rec.primary_flag;
1869: out_rec.assignment_number :=asg_rec.assignment_number;
1870: out_rec.date_probation_end :=asg_rec.date_probation_end;
1871: out_rec.default_code_comb_id :=asg_rec.default_code_comb_id;
1872: out_rec.employment_category_meaning :=hr_reports.get_lookup_meaning('EMP_CAT',asg_rec.employment_category);
1873: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);
1874: out_rec.normal_hours :=asg_rec.normal_hours;
1875: out_rec.probation_period :=asg_rec.probation_period;
1876: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);

Line 1873: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);

1869: out_rec.assignment_number :=asg_rec.assignment_number;
1870: out_rec.date_probation_end :=asg_rec.date_probation_end;
1871: out_rec.default_code_comb_id :=asg_rec.default_code_comb_id;
1872: out_rec.employment_category_meaning :=hr_reports.get_lookup_meaning('EMP_CAT',asg_rec.employment_category);
1873: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);
1874: out_rec.normal_hours :=asg_rec.normal_hours;
1875: out_rec.probation_period :=asg_rec.probation_period;
1876: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);
1877: out_rec.time_normal_finish :=asg_rec.time_normal_finish;

Line 1876: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);

1872: out_rec.employment_category_meaning :=hr_reports.get_lookup_meaning('EMP_CAT',asg_rec.employment_category);
1873: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);
1874: out_rec.normal_hours :=asg_rec.normal_hours;
1875: out_rec.probation_period :=asg_rec.probation_period;
1876: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);
1877: out_rec.time_normal_finish :=asg_rec.time_normal_finish;
1878: out_rec.time_normal_start :=asg_rec.time_normal_start;
1879: --CWK
1880: out_rec.project_title :=asg_rec.project_title;

Line 1952: out_rec.bargaining_unit_code_meaning :=hr_reports.get_lookup_meaning('BARGAINING_UNIT_CODE',asg_rec.bargaining_unit_code);

1948: out_rec.ass_attribute29 :=asg_rec.ass_attribute29;
1949: out_rec.ass_attribute30 :=asg_rec.ass_attribute30;
1950: */
1951:
1952: out_rec.bargaining_unit_code_meaning :=hr_reports.get_lookup_meaning('BARGAINING_UNIT_CODE',asg_rec.bargaining_unit_code);
1953: out_rec.labour_union_member_flag :=asg_rec.labour_union_member_flag;
1954: out_rec.hourly_salaried_meaning :=hr_reports.get_lookup_meaning('HOURLY_SALARIED_CODE',asg_rec.hourly_salaried_code);
1955: --
1956: if asg_rec.special_ceiling_step_id is not null then

Line 1954: out_rec.hourly_salaried_meaning :=hr_reports.get_lookup_meaning('HOURLY_SALARIED_CODE',asg_rec.hourly_salaried_code);

1950: */
1951:
1952: out_rec.bargaining_unit_code_meaning :=hr_reports.get_lookup_meaning('BARGAINING_UNIT_CODE',asg_rec.bargaining_unit_code);
1953: out_rec.labour_union_member_flag :=asg_rec.labour_union_member_flag;
1954: out_rec.hourly_salaried_meaning :=hr_reports.get_lookup_meaning('HOURLY_SALARIED_CODE',asg_rec.hourly_salaried_code);
1955: --
1956: if asg_rec.special_ceiling_step_id is not null then
1957: open csr_ceiling_step(asg_rec.special_ceiling_step_id,p_effective_date);
1958: fetch csr_ceiling_step into out_rec.special_ceiling_point, out_rec.special_ceiling_step;

Line 1965: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('APL_ASSIGN_REASON',asg_rec.change_reason);

1961: out_rec.special_ceiling_point:=null;
1962: out_rec.special_ceiling_step:=null;
1963: end if;
1964: --
1965: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('APL_ASSIGN_REASON',asg_rec.change_reason);
1966: out_rec.internal_address_line :=asg_rec.internal_address_line;
1967: out_rec.manager_flag :=asg_rec.manager_flag;
1968: out_rec.perf_review_period :=asg_rec.perf_review_period;
1969: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);

Line 1969: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);

1965: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('APL_ASSIGN_REASON',asg_rec.change_reason);
1966: out_rec.internal_address_line :=asg_rec.internal_address_line;
1967: out_rec.manager_flag :=asg_rec.manager_flag;
1968: out_rec.perf_review_period :=asg_rec.perf_review_period;
1969: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);
1970: out_rec.sal_review_period :=asg_rec.sal_review_period;
1971: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);
1972: out_rec.source_type_meaning :=hr_reports.get_lookup_meaning('REC_TYPE',asg_rec.source_type);
1973: --

Line 1971: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);

1967: out_rec.manager_flag :=asg_rec.manager_flag;
1968: out_rec.perf_review_period :=asg_rec.perf_review_period;
1969: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);
1970: out_rec.sal_review_period :=asg_rec.sal_review_period;
1971: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);
1972: out_rec.source_type_meaning :=hr_reports.get_lookup_meaning('REC_TYPE',asg_rec.source_type);
1973: --
1974: if asg_rec.contract_id is not null then
1975: open csr_reference(asg_rec.contract_id,p_effective_date);

Line 1972: out_rec.source_type_meaning :=hr_reports.get_lookup_meaning('REC_TYPE',asg_rec.source_type);

1968: out_rec.perf_review_period :=asg_rec.perf_review_period;
1969: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);
1970: out_rec.sal_review_period :=asg_rec.sal_review_period;
1971: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);
1972: out_rec.source_type_meaning :=hr_reports.get_lookup_meaning('REC_TYPE',asg_rec.source_type);
1973: --
1974: if asg_rec.contract_id is not null then
1975: open csr_reference(asg_rec.contract_id,p_effective_date);
1976: fetch csr_reference into out_rec.contract;