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 1508: out_rec.background_chk_stat_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.background_check_status);

1504: --
1505: out_rec.last_name :=per_rec.last_name;
1506: out_rec.start_date :=per_rec.start_date;
1507: out_rec.applicant_number :=per_rec.applicant_number;
1508: out_rec.background_chk_stat_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.background_check_status);
1509: out_rec.background_date_check :=per_rec.background_date_check;
1510: out_rec.blood_type_meaning :=hr_reports.get_lookup_meaning('BLOOD_TYPE',per_rec.blood_type);
1511:
1512: --Modified for PMxbg

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

1506: out_rec.start_date :=per_rec.start_date;
1507: out_rec.applicant_number :=per_rec.applicant_number;
1508: out_rec.background_chk_stat_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.background_check_status);
1509: out_rec.background_date_check :=per_rec.background_date_check;
1510: out_rec.blood_type_meaning :=hr_reports.get_lookup_meaning('BLOOD_TYPE',per_rec.blood_type);
1511:
1512: --Modified for PMxbg
1513: if per_rec.person_id is not null then
1514: open csr_bg_name(per_rec.business_group_id);

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

1529: out_rec.date_employee_data_verified :=per_rec.date_employee_data_verified;
1530: out_rec.date_of_birth :=per_rec.date_of_birth;
1531: out_rec.email_address :=per_rec.email_address;
1532: out_rec.employee_number :=per_rec.employee_number;
1533: out_rec.expnse_chk_send_addr_meaning :=hr_reports.get_lookup_meaning('HOME_OFFICE',per_rec.expense_check_send_to_address);
1534: out_rec.npw_number :=per_rec.npw_number;
1535: out_rec.first_name :=per_rec.first_name;
1536: out_rec.per_fte_capacity :=per_rec.fte_capacity;
1537: out_rec.full_name :=per_rec.full_name;

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

1541: out_rec.known_as :=per_rec.known_as;
1542: out_rec.last_medical_test_by :=per_rec.last_medical_test_by;
1543: out_rec.last_medical_test_date :=per_rec.last_medical_test_date;
1544: out_rec.mailstop :=per_rec.mailstop;
1545: out_rec.marital_status_meaning :=hr_reports.get_lookup_meaning('MAR_STATUS',per_rec.marital_status);
1546: out_rec.middle_names :=per_rec.middle_names;
1547: out_rec.nationality_meaning :=hr_reports.get_lookup_meaning('NATIONALITY',per_rec.nationality);
1548: out_rec.national_identifier :=per_rec.national_identifier;
1549: out_rec.office_number :=per_rec.office_number;

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

1543: out_rec.last_medical_test_date :=per_rec.last_medical_test_date;
1544: out_rec.mailstop :=per_rec.mailstop;
1545: out_rec.marital_status_meaning :=hr_reports.get_lookup_meaning('MAR_STATUS',per_rec.marital_status);
1546: out_rec.middle_names :=per_rec.middle_names;
1547: out_rec.nationality_meaning :=hr_reports.get_lookup_meaning('NATIONALITY',per_rec.nationality);
1548: out_rec.national_identifier :=per_rec.national_identifier;
1549: out_rec.office_number :=per_rec.office_number;
1550: out_rec.on_military_service_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.on_military_service);
1551: out_rec.pre_name_adjunct :=per_rec.pre_name_adjunct;

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

1546: out_rec.middle_names :=per_rec.middle_names;
1547: out_rec.nationality_meaning :=hr_reports.get_lookup_meaning('NATIONALITY',per_rec.nationality);
1548: out_rec.national_identifier :=per_rec.national_identifier;
1549: out_rec.office_number :=per_rec.office_number;
1550: out_rec.on_military_service_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.on_military_service);
1551: out_rec.pre_name_adjunct :=per_rec.pre_name_adjunct;
1552: out_rec.previous_last_name :=per_rec.previous_last_name;
1553: out_rec.rehire_recommendation :=per_rec.rehire_recommendation;
1554: out_rec.resume_exists_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.resume_exists);

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

1550: out_rec.on_military_service_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.on_military_service);
1551: out_rec.pre_name_adjunct :=per_rec.pre_name_adjunct;
1552: out_rec.previous_last_name :=per_rec.previous_last_name;
1553: out_rec.rehire_recommendation :=per_rec.rehire_recommendation;
1554: out_rec.resume_exists_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.resume_exists);
1555: out_rec.resume_last_updated :=per_rec.resume_last_updated;
1556: -- Bug 3037019
1557: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
1558: out_rec.secnd_passport_exsts_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.second_passport_exists);

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

1553: out_rec.rehire_recommendation :=per_rec.rehire_recommendation;
1554: out_rec.resume_exists_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.resume_exists);
1555: out_rec.resume_last_updated :=per_rec.resume_last_updated;
1556: -- Bug 3037019
1557: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
1558: out_rec.secnd_passport_exsts_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.second_passport_exists);
1559: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
1560: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
1561: out_rec.suffix :=per_rec.suffix;

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

1554: out_rec.resume_exists_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.resume_exists);
1555: out_rec.resume_last_updated :=per_rec.resume_last_updated;
1556: -- Bug 3037019
1557: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
1558: out_rec.secnd_passport_exsts_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.second_passport_exists);
1559: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
1560: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
1561: out_rec.suffix :=per_rec.suffix;
1562: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);

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

1555: out_rec.resume_last_updated :=per_rec.resume_last_updated;
1556: -- Bug 3037019
1557: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
1558: out_rec.secnd_passport_exsts_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.second_passport_exists);
1559: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
1560: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
1561: out_rec.suffix :=per_rec.suffix;
1562: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
1563: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);

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

1556: -- Bug 3037019
1557: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
1558: out_rec.secnd_passport_exsts_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.second_passport_exists);
1559: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
1560: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
1561: out_rec.suffix :=per_rec.suffix;
1562: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
1563: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
1564: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;

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

1558: out_rec.secnd_passport_exsts_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.second_passport_exists);
1559: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
1560: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
1561: out_rec.suffix :=per_rec.suffix;
1562: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
1563: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
1564: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;
1565: out_rec.cord_ben_no_cvg_flag_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.coord_ben_no_cvg_flag);
1566: out_rec.dpdnt_adoption_date :=per_rec.dpdnt_adoption_date;

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

1559: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
1560: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
1561: out_rec.suffix :=per_rec.suffix;
1562: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
1563: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
1564: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;
1565: out_rec.cord_ben_no_cvg_flag_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.coord_ben_no_cvg_flag);
1566: out_rec.dpdnt_adoption_date :=per_rec.dpdnt_adoption_date;
1567: out_rec.dpdnt_vlntry_svc_flg_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.dpdnt_vlntry_svce_flag);

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

1561: out_rec.suffix :=per_rec.suffix;
1562: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
1563: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
1564: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;
1565: out_rec.cord_ben_no_cvg_flag_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.coord_ben_no_cvg_flag);
1566: out_rec.dpdnt_adoption_date :=per_rec.dpdnt_adoption_date;
1567: out_rec.dpdnt_vlntry_svc_flg_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.dpdnt_vlntry_svce_flag);
1568: out_rec.receipt_of_death_cert_date :=per_rec.receipt_of_death_cert_date;
1569: out_rec.uses_tobacco_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.uses_tobacco_flag);

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

1563: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
1564: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;
1565: out_rec.cord_ben_no_cvg_flag_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.coord_ben_no_cvg_flag);
1566: out_rec.dpdnt_adoption_date :=per_rec.dpdnt_adoption_date;
1567: out_rec.dpdnt_vlntry_svc_flg_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.dpdnt_vlntry_svce_flag);
1568: out_rec.receipt_of_death_cert_date :=per_rec.receipt_of_death_cert_date;
1569: out_rec.uses_tobacco_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.uses_tobacco_flag);
1570: --
1571: if per_rec.benefit_group_id is not null then

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

1565: out_rec.cord_ben_no_cvg_flag_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.coord_ben_no_cvg_flag);
1566: out_rec.dpdnt_adoption_date :=per_rec.dpdnt_adoption_date;
1567: out_rec.dpdnt_vlntry_svc_flg_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.dpdnt_vlntry_svce_flag);
1568: out_rec.receipt_of_death_cert_date :=per_rec.receipt_of_death_cert_date;
1569: out_rec.uses_tobacco_meaning :=hr_reports.get_lookup_meaning('YES_NO',per_rec.uses_tobacco_flag);
1570: --
1571: if per_rec.benefit_group_id is not null then
1572: open csr_benfts_grp(per_rec.benefit_group_id);
1573: fetch csr_benfts_grp into out_rec.benefit_group;

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

1884: out_rec.asg_primary_flag :=asg_rec.primary_flag;
1885: out_rec.assignment_number :=asg_rec.assignment_number;
1886: out_rec.date_probation_end :=asg_rec.date_probation_end;
1887: out_rec.default_code_comb_id :=asg_rec.default_code_comb_id;
1888: out_rec.employment_category_meaning :=hr_reports.get_lookup_meaning('EMP_CAT',asg_rec.employment_category);
1889: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);
1890: out_rec.normal_hours :=asg_rec.normal_hours;
1891: out_rec.probation_period :=asg_rec.probation_period;
1892: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);

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

1885: out_rec.assignment_number :=asg_rec.assignment_number;
1886: out_rec.date_probation_end :=asg_rec.date_probation_end;
1887: out_rec.default_code_comb_id :=asg_rec.default_code_comb_id;
1888: out_rec.employment_category_meaning :=hr_reports.get_lookup_meaning('EMP_CAT',asg_rec.employment_category);
1889: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);
1890: out_rec.normal_hours :=asg_rec.normal_hours;
1891: out_rec.probation_period :=asg_rec.probation_period;
1892: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);
1893: out_rec.time_normal_finish :=asg_rec.time_normal_finish;

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

1888: out_rec.employment_category_meaning :=hr_reports.get_lookup_meaning('EMP_CAT',asg_rec.employment_category);
1889: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);
1890: out_rec.normal_hours :=asg_rec.normal_hours;
1891: out_rec.probation_period :=asg_rec.probation_period;
1892: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);
1893: out_rec.time_normal_finish :=asg_rec.time_normal_finish;
1894: out_rec.time_normal_start :=asg_rec.time_normal_start;
1895: --CWK
1896: out_rec.project_title :=asg_rec.project_title;

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

1964: out_rec.ass_attribute29 :=asg_rec.ass_attribute29;
1965: out_rec.ass_attribute30 :=asg_rec.ass_attribute30;
1966: */
1967:
1968: out_rec.bargaining_unit_code_meaning :=hr_reports.get_lookup_meaning('BARGAINING_UNIT_CODE',asg_rec.bargaining_unit_code);
1969: out_rec.labour_union_member_flag :=asg_rec.labour_union_member_flag;
1970: out_rec.hourly_salaried_meaning :=hr_reports.get_lookup_meaning('HOURLY_SALARIED_CODE',asg_rec.hourly_salaried_code);
1971: --
1972: if asg_rec.special_ceiling_step_id is not null then

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

1966: */
1967:
1968: out_rec.bargaining_unit_code_meaning :=hr_reports.get_lookup_meaning('BARGAINING_UNIT_CODE',asg_rec.bargaining_unit_code);
1969: out_rec.labour_union_member_flag :=asg_rec.labour_union_member_flag;
1970: out_rec.hourly_salaried_meaning :=hr_reports.get_lookup_meaning('HOURLY_SALARIED_CODE',asg_rec.hourly_salaried_code);
1971: --
1972: if asg_rec.special_ceiling_step_id is not null then
1973: open csr_ceiling_step(asg_rec.special_ceiling_step_id,p_effective_date);
1974: fetch csr_ceiling_step into out_rec.special_ceiling_point, out_rec.special_ceiling_step;

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

1977: out_rec.special_ceiling_point:=null;
1978: out_rec.special_ceiling_step:=null;
1979: end if;
1980: --
1981: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('APL_ASSIGN_REASON',asg_rec.change_reason);
1982: out_rec.internal_address_line :=asg_rec.internal_address_line;
1983: out_rec.manager_flag :=asg_rec.manager_flag;
1984: out_rec.perf_review_period :=asg_rec.perf_review_period;
1985: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);

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

1981: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('APL_ASSIGN_REASON',asg_rec.change_reason);
1982: out_rec.internal_address_line :=asg_rec.internal_address_line;
1983: out_rec.manager_flag :=asg_rec.manager_flag;
1984: out_rec.perf_review_period :=asg_rec.perf_review_period;
1985: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);
1986: out_rec.sal_review_period :=asg_rec.sal_review_period;
1987: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);
1988: out_rec.source_type_meaning :=hr_reports.get_lookup_meaning('REC_TYPE',asg_rec.source_type);
1989: --

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

1983: out_rec.manager_flag :=asg_rec.manager_flag;
1984: out_rec.perf_review_period :=asg_rec.perf_review_period;
1985: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);
1986: out_rec.sal_review_period :=asg_rec.sal_review_period;
1987: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);
1988: out_rec.source_type_meaning :=hr_reports.get_lookup_meaning('REC_TYPE',asg_rec.source_type);
1989: --
1990: if asg_rec.contract_id is not null then
1991: open csr_reference(asg_rec.contract_id,p_effective_date);

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

1984: out_rec.perf_review_period :=asg_rec.perf_review_period;
1985: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);
1986: out_rec.sal_review_period :=asg_rec.sal_review_period;
1987: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);
1988: out_rec.source_type_meaning :=hr_reports.get_lookup_meaning('REC_TYPE',asg_rec.source_type);
1989: --
1990: if asg_rec.contract_id is not null then
1991: open csr_reference(asg_rec.contract_id,p_effective_date);
1992: fetch csr_reference into out_rec.contract;