[Home] [Help]
475: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type);
476: --
477: type recruitment_bonus_type is record
478: (p_recruitment_bonus_flag varchar2(1)
479: ,p_recruitment_bonus ghr_pa_request_extra_info.rei_information1%type
480: ,p_date_recruit_exp ghr_pa_request_extra_info.rei_information2%type
481: ,p_percentage ghr_pa_request_extra_info.rei_information3%type);
482: --
483: type relocation_bonus_type is record
476: --
477: type recruitment_bonus_type is record
478: (p_recruitment_bonus_flag varchar2(1)
479: ,p_recruitment_bonus ghr_pa_request_extra_info.rei_information1%type
480: ,p_date_recruit_exp ghr_pa_request_extra_info.rei_information2%type
481: ,p_percentage ghr_pa_request_extra_info.rei_information3%type);
482: --
483: type relocation_bonus_type is record
484: (p_relocation_bonus_flag varchar2(1)
477: type recruitment_bonus_type is record
478: (p_recruitment_bonus_flag varchar2(1)
479: ,p_recruitment_bonus ghr_pa_request_extra_info.rei_information1%type
480: ,p_date_recruit_exp ghr_pa_request_extra_info.rei_information2%type
481: ,p_percentage ghr_pa_request_extra_info.rei_information3%type);
482: --
483: type relocation_bonus_type is record
484: (p_relocation_bonus_flag varchar2(1)
485: ,p_relocation_bonus ghr_pa_request_extra_info.rei_information1%type
481: ,p_percentage ghr_pa_request_extra_info.rei_information3%type);
482: --
483: type relocation_bonus_type is record
484: (p_relocation_bonus_flag varchar2(1)
485: ,p_relocation_bonus ghr_pa_request_extra_info.rei_information1%type
486: ,p_date_reloc_exp ghr_pa_request_extra_info.rei_information2%type
487: ,p_percentage ghr_pa_request_extra_info.rei_information3%type);
488: --
489: type agency_sf52_type is record
482: --
483: type relocation_bonus_type is record
484: (p_relocation_bonus_flag varchar2(1)
485: ,p_relocation_bonus ghr_pa_request_extra_info.rei_information1%type
486: ,p_date_reloc_exp ghr_pa_request_extra_info.rei_information2%type
487: ,p_percentage ghr_pa_request_extra_info.rei_information3%type);
488: --
489: type agency_sf52_type is record
490: (agency_flag VARCHAR2(1)
483: type relocation_bonus_type is record
484: (p_relocation_bonus_flag varchar2(1)
485: ,p_relocation_bonus ghr_pa_request_extra_info.rei_information1%type
486: ,p_date_reloc_exp ghr_pa_request_extra_info.rei_information2%type
487: ,p_percentage ghr_pa_request_extra_info.rei_information3%type);
488: --
489: type agency_sf52_type is record
490: (agency_flag VARCHAR2(1)
491: ,agency_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type
487: ,p_percentage ghr_pa_request_extra_info.rei_information3%type);
488: --
489: type agency_sf52_type is record
490: (agency_flag VARCHAR2(1)
491: ,agency_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type
492: ,object_version_number ghr_pa_request_extra_info.object_version_number%type
493: ,agency_use_block_25 ghr_pa_request_extra_info.rei_information3%type
494: ,agency_data_block_40 ghr_pa_request_extra_info.rei_information4%type
495: ,agency_data_block_41 ghr_pa_request_extra_info.rei_information5%type
488: --
489: type agency_sf52_type is record
490: (agency_flag VARCHAR2(1)
491: ,agency_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type
492: ,object_version_number ghr_pa_request_extra_info.object_version_number%type
493: ,agency_use_block_25 ghr_pa_request_extra_info.rei_information3%type
494: ,agency_data_block_40 ghr_pa_request_extra_info.rei_information4%type
495: ,agency_data_block_41 ghr_pa_request_extra_info.rei_information5%type
496: ,agency_data_block_42 ghr_pa_request_extra_info.rei_information6%type
489: type agency_sf52_type is record
490: (agency_flag VARCHAR2(1)
491: ,agency_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type
492: ,object_version_number ghr_pa_request_extra_info.object_version_number%type
493: ,agency_use_block_25 ghr_pa_request_extra_info.rei_information3%type
494: ,agency_data_block_40 ghr_pa_request_extra_info.rei_information4%type
495: ,agency_data_block_41 ghr_pa_request_extra_info.rei_information5%type
496: ,agency_data_block_42 ghr_pa_request_extra_info.rei_information6%type
497: ,agency_data_block_43 ghr_pa_request_extra_info.rei_information7%type
490: (agency_flag VARCHAR2(1)
491: ,agency_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type
492: ,object_version_number ghr_pa_request_extra_info.object_version_number%type
493: ,agency_use_block_25 ghr_pa_request_extra_info.rei_information3%type
494: ,agency_data_block_40 ghr_pa_request_extra_info.rei_information4%type
495: ,agency_data_block_41 ghr_pa_request_extra_info.rei_information5%type
496: ,agency_data_block_42 ghr_pa_request_extra_info.rei_information6%type
497: ,agency_data_block_43 ghr_pa_request_extra_info.rei_information7%type
498: ,agency_data_block_44 ghr_pa_request_extra_info.rei_information8%type);
491: ,agency_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type
492: ,object_version_number ghr_pa_request_extra_info.object_version_number%type
493: ,agency_use_block_25 ghr_pa_request_extra_info.rei_information3%type
494: ,agency_data_block_40 ghr_pa_request_extra_info.rei_information4%type
495: ,agency_data_block_41 ghr_pa_request_extra_info.rei_information5%type
496: ,agency_data_block_42 ghr_pa_request_extra_info.rei_information6%type
497: ,agency_data_block_43 ghr_pa_request_extra_info.rei_information7%type
498: ,agency_data_block_44 ghr_pa_request_extra_info.rei_information8%type);
499: ----
492: ,object_version_number ghr_pa_request_extra_info.object_version_number%type
493: ,agency_use_block_25 ghr_pa_request_extra_info.rei_information3%type
494: ,agency_data_block_40 ghr_pa_request_extra_info.rei_information4%type
495: ,agency_data_block_41 ghr_pa_request_extra_info.rei_information5%type
496: ,agency_data_block_42 ghr_pa_request_extra_info.rei_information6%type
497: ,agency_data_block_43 ghr_pa_request_extra_info.rei_information7%type
498: ,agency_data_block_44 ghr_pa_request_extra_info.rei_information8%type);
499: ----
500:
493: ,agency_use_block_25 ghr_pa_request_extra_info.rei_information3%type
494: ,agency_data_block_40 ghr_pa_request_extra_info.rei_information4%type
495: ,agency_data_block_41 ghr_pa_request_extra_info.rei_information5%type
496: ,agency_data_block_42 ghr_pa_request_extra_info.rei_information6%type
497: ,agency_data_block_43 ghr_pa_request_extra_info.rei_information7%type
498: ,agency_data_block_44 ghr_pa_request_extra_info.rei_information8%type);
499: ----
500:
501: type within_grade_increase_type is record
494: ,agency_data_block_40 ghr_pa_request_extra_info.rei_information4%type
495: ,agency_data_block_41 ghr_pa_request_extra_info.rei_information5%type
496: ,agency_data_block_42 ghr_pa_request_extra_info.rei_information6%type
497: ,agency_data_block_43 ghr_pa_request_extra_info.rei_information7%type
498: ,agency_data_block_44 ghr_pa_request_extra_info.rei_information8%type);
499: ----
500:
501: type within_grade_increase_type is record
502: (p_wgi_flag varchar2(1)
499: ----
500:
501: type within_grade_increase_type is record
502: (p_wgi_flag varchar2(1)
503: ,p_wgi_status ghr_pa_request_extra_info.rei_information1%type
504: ,p_date_wgi_due ghr_pa_request_extra_info.rei_information2%type
505: ,p_wgi_pay_date ghr_pa_request_extra_info.rei_information3%type
506: ,p_date_wgi_postpone_effective ghr_pa_request_extra_info.rei_information3%type
507: ,p_date_wgi_postpone_detail_due ghr_pa_request_extra_info.rei_information4%type
500:
501: type within_grade_increase_type is record
502: (p_wgi_flag varchar2(1)
503: ,p_wgi_status ghr_pa_request_extra_info.rei_information1%type
504: ,p_date_wgi_due ghr_pa_request_extra_info.rei_information2%type
505: ,p_wgi_pay_date ghr_pa_request_extra_info.rei_information3%type
506: ,p_date_wgi_postpone_effective ghr_pa_request_extra_info.rei_information3%type
507: ,p_date_wgi_postpone_detail_due ghr_pa_request_extra_info.rei_information4%type
508: ,p_date_wgi_due_temp_prom ghr_pa_request_extra_info.rei_information5%type
501: type within_grade_increase_type is record
502: (p_wgi_flag varchar2(1)
503: ,p_wgi_status ghr_pa_request_extra_info.rei_information1%type
504: ,p_date_wgi_due ghr_pa_request_extra_info.rei_information2%type
505: ,p_wgi_pay_date ghr_pa_request_extra_info.rei_information3%type
506: ,p_date_wgi_postpone_effective ghr_pa_request_extra_info.rei_information3%type
507: ,p_date_wgi_postpone_detail_due ghr_pa_request_extra_info.rei_information4%type
508: ,p_date_wgi_due_temp_prom ghr_pa_request_extra_info.rei_information5%type
509: ,p_last_equi_incr ghr_pa_request_extra_info.rei_information5%type);
502: (p_wgi_flag varchar2(1)
503: ,p_wgi_status ghr_pa_request_extra_info.rei_information1%type
504: ,p_date_wgi_due ghr_pa_request_extra_info.rei_information2%type
505: ,p_wgi_pay_date ghr_pa_request_extra_info.rei_information3%type
506: ,p_date_wgi_postpone_effective ghr_pa_request_extra_info.rei_information3%type
507: ,p_date_wgi_postpone_detail_due ghr_pa_request_extra_info.rei_information4%type
508: ,p_date_wgi_due_temp_prom ghr_pa_request_extra_info.rei_information5%type
509: ,p_last_equi_incr ghr_pa_request_extra_info.rei_information5%type);
510:
503: ,p_wgi_status ghr_pa_request_extra_info.rei_information1%type
504: ,p_date_wgi_due ghr_pa_request_extra_info.rei_information2%type
505: ,p_wgi_pay_date ghr_pa_request_extra_info.rei_information3%type
506: ,p_date_wgi_postpone_effective ghr_pa_request_extra_info.rei_information3%type
507: ,p_date_wgi_postpone_detail_due ghr_pa_request_extra_info.rei_information4%type
508: ,p_date_wgi_due_temp_prom ghr_pa_request_extra_info.rei_information5%type
509: ,p_last_equi_incr ghr_pa_request_extra_info.rei_information5%type);
510:
511: -- Added 14-AUG-97
504: ,p_date_wgi_due ghr_pa_request_extra_info.rei_information2%type
505: ,p_wgi_pay_date ghr_pa_request_extra_info.rei_information3%type
506: ,p_date_wgi_postpone_effective ghr_pa_request_extra_info.rei_information3%type
507: ,p_date_wgi_postpone_detail_due ghr_pa_request_extra_info.rei_information4%type
508: ,p_date_wgi_due_temp_prom ghr_pa_request_extra_info.rei_information5%type
509: ,p_last_equi_incr ghr_pa_request_extra_info.rei_information5%type);
510:
511: -- Added 14-AUG-97
512: type government_awards_type is record
505: ,p_wgi_pay_date ghr_pa_request_extra_info.rei_information3%type
506: ,p_date_wgi_postpone_effective ghr_pa_request_extra_info.rei_information3%type
507: ,p_date_wgi_postpone_detail_due ghr_pa_request_extra_info.rei_information4%type
508: ,p_date_wgi_due_temp_prom ghr_pa_request_extra_info.rei_information5%type
509: ,p_last_equi_incr ghr_pa_request_extra_info.rei_information5%type);
510:
511: -- Added 14-AUG-97
512: type government_awards_type is record
513: (award_flag varchar2(1)
510:
511: -- Added 14-AUG-97
512: type government_awards_type is record
513: (award_flag varchar2(1)
514: ,award_agency ghr_pa_request_extra_info.rei_information3%type
515: ,award_type ghr_pa_request_extra_info.rei_information4%type
516: ,percentage ghr_pa_request_extra_info.rei_information5%type
517: ,group_award ghr_pa_request_extra_info.rei_information6%type
518: ,tangible_benefit_dollars ghr_pa_request_extra_info.rei_information7%type
511: -- Added 14-AUG-97
512: type government_awards_type is record
513: (award_flag varchar2(1)
514: ,award_agency ghr_pa_request_extra_info.rei_information3%type
515: ,award_type ghr_pa_request_extra_info.rei_information4%type
516: ,percentage ghr_pa_request_extra_info.rei_information5%type
517: ,group_award ghr_pa_request_extra_info.rei_information6%type
518: ,tangible_benefit_dollars ghr_pa_request_extra_info.rei_information7%type
519: ,award_payment ghr_pa_request_extra_info.rei_information8%type
512: type government_awards_type is record
513: (award_flag varchar2(1)
514: ,award_agency ghr_pa_request_extra_info.rei_information3%type
515: ,award_type ghr_pa_request_extra_info.rei_information4%type
516: ,percentage ghr_pa_request_extra_info.rei_information5%type
517: ,group_award ghr_pa_request_extra_info.rei_information6%type
518: ,tangible_benefit_dollars ghr_pa_request_extra_info.rei_information7%type
519: ,award_payment ghr_pa_request_extra_info.rei_information8%type
520: ,date_award_earned ghr_pa_request_extra_info.rei_information9%type
513: (award_flag varchar2(1)
514: ,award_agency ghr_pa_request_extra_info.rei_information3%type
515: ,award_type ghr_pa_request_extra_info.rei_information4%type
516: ,percentage ghr_pa_request_extra_info.rei_information5%type
517: ,group_award ghr_pa_request_extra_info.rei_information6%type
518: ,tangible_benefit_dollars ghr_pa_request_extra_info.rei_information7%type
519: ,award_payment ghr_pa_request_extra_info.rei_information8%type
520: ,date_award_earned ghr_pa_request_extra_info.rei_information9%type
521: ,award_appropriation_code ghr_pa_request_extra_info.rei_information10%type
514: ,award_agency ghr_pa_request_extra_info.rei_information3%type
515: ,award_type ghr_pa_request_extra_info.rei_information4%type
516: ,percentage ghr_pa_request_extra_info.rei_information5%type
517: ,group_award ghr_pa_request_extra_info.rei_information6%type
518: ,tangible_benefit_dollars ghr_pa_request_extra_info.rei_information7%type
519: ,award_payment ghr_pa_request_extra_info.rei_information8%type
520: ,date_award_earned ghr_pa_request_extra_info.rei_information9%type
521: ,award_appropriation_code ghr_pa_request_extra_info.rei_information10%type
522: ,date_exemp_award ghr_pa_request_extra_info.rei_information11%type );
515: ,award_type ghr_pa_request_extra_info.rei_information4%type
516: ,percentage ghr_pa_request_extra_info.rei_information5%type
517: ,group_award ghr_pa_request_extra_info.rei_information6%type
518: ,tangible_benefit_dollars ghr_pa_request_extra_info.rei_information7%type
519: ,award_payment ghr_pa_request_extra_info.rei_information8%type
520: ,date_award_earned ghr_pa_request_extra_info.rei_information9%type
521: ,award_appropriation_code ghr_pa_request_extra_info.rei_information10%type
522: ,date_exemp_award ghr_pa_request_extra_info.rei_information11%type );
523: -- award_payment - 10/24/97
516: ,percentage ghr_pa_request_extra_info.rei_information5%type
517: ,group_award ghr_pa_request_extra_info.rei_information6%type
518: ,tangible_benefit_dollars ghr_pa_request_extra_info.rei_information7%type
519: ,award_payment ghr_pa_request_extra_info.rei_information8%type
520: ,date_award_earned ghr_pa_request_extra_info.rei_information9%type
521: ,award_appropriation_code ghr_pa_request_extra_info.rei_information10%type
522: ,date_exemp_award ghr_pa_request_extra_info.rei_information11%type );
523: -- award_payment - 10/24/97
524: -- date_award_earned - 02/16/98
517: ,group_award ghr_pa_request_extra_info.rei_information6%type
518: ,tangible_benefit_dollars ghr_pa_request_extra_info.rei_information7%type
519: ,award_payment ghr_pa_request_extra_info.rei_information8%type
520: ,date_award_earned ghr_pa_request_extra_info.rei_information9%type
521: ,award_appropriation_code ghr_pa_request_extra_info.rei_information10%type
522: ,date_exemp_award ghr_pa_request_extra_info.rei_information11%type );
523: -- award_payment - 10/24/97
524: -- date_award_earned - 02/16/98
525: -- award_appropriation_code - 02/29/00
518: ,tangible_benefit_dollars ghr_pa_request_extra_info.rei_information7%type
519: ,award_payment ghr_pa_request_extra_info.rei_information8%type
520: ,date_award_earned ghr_pa_request_extra_info.rei_information9%type
521: ,award_appropriation_code ghr_pa_request_extra_info.rei_information10%type
522: ,date_exemp_award ghr_pa_request_extra_info.rei_information11%type );
523: -- award_payment - 10/24/97
524: -- date_award_earned - 02/16/98
525: -- award_appropriation_code - 02/29/00
526: type government_payroll_type is record
523: -- award_payment - 10/24/97
524: -- date_award_earned - 02/16/98
525: -- award_appropriation_code - 02/29/00
526: type government_payroll_type is record
527: (payroll_type ghr_pa_request_extra_info.rei_information3%type);
528:
529: type retention_allow_review_type is record
530: ( retention_allow_review_flag varchar2(1)
531: ,review_date ghr_pa_request_extra_info.rei_information3%type);
527: (payroll_type ghr_pa_request_extra_info.rei_information3%type);
528:
529: type retention_allow_review_type is record
530: ( retention_allow_review_flag varchar2(1)
531: ,review_date ghr_pa_request_extra_info.rei_information3%type);
532: -- added date_init_appr_due on 5-oct-98 by skutteti
533: type performance_appraisal_type is record
534: (perf_appr_flag varchar2(1)
535: ,rating_rec ghr_pa_request_extra_info.rei_information3%type
531: ,review_date ghr_pa_request_extra_info.rei_information3%type);
532: -- added date_init_appr_due on 5-oct-98 by skutteti
533: type performance_appraisal_type is record
534: (perf_appr_flag varchar2(1)
535: ,rating_rec ghr_pa_request_extra_info.rei_information3%type
536: ,rating_rec_pattern ghr_pa_request_extra_info.rei_information4%type
537: ,rating_rec_level ghr_pa_request_extra_info.rei_information5%type
538: ,date_appr_starts ghr_pa_request_extra_info.rei_information19%type --Bug#4753117
539: ,date_appr_ends ghr_pa_request_extra_info.rei_information6%type
532: -- added date_init_appr_due on 5-oct-98 by skutteti
533: type performance_appraisal_type is record
534: (perf_appr_flag varchar2(1)
535: ,rating_rec ghr_pa_request_extra_info.rei_information3%type
536: ,rating_rec_pattern ghr_pa_request_extra_info.rei_information4%type
537: ,rating_rec_level ghr_pa_request_extra_info.rei_information5%type
538: ,date_appr_starts ghr_pa_request_extra_info.rei_information19%type --Bug#4753117
539: ,date_appr_ends ghr_pa_request_extra_info.rei_information6%type
540: ,unit ghr_pa_request_extra_info.rei_information7%type
533: type performance_appraisal_type is record
534: (perf_appr_flag varchar2(1)
535: ,rating_rec ghr_pa_request_extra_info.rei_information3%type
536: ,rating_rec_pattern ghr_pa_request_extra_info.rei_information4%type
537: ,rating_rec_level ghr_pa_request_extra_info.rei_information5%type
538: ,date_appr_starts ghr_pa_request_extra_info.rei_information19%type --Bug#4753117
539: ,date_appr_ends ghr_pa_request_extra_info.rei_information6%type
540: ,unit ghr_pa_request_extra_info.rei_information7%type
541: ,org_structure_id ghr_pa_request_extra_info.rei_information8%type
534: (perf_appr_flag varchar2(1)
535: ,rating_rec ghr_pa_request_extra_info.rei_information3%type
536: ,rating_rec_pattern ghr_pa_request_extra_info.rei_information4%type
537: ,rating_rec_level ghr_pa_request_extra_info.rei_information5%type
538: ,date_appr_starts ghr_pa_request_extra_info.rei_information19%type --Bug#4753117
539: ,date_appr_ends ghr_pa_request_extra_info.rei_information6%type
540: ,unit ghr_pa_request_extra_info.rei_information7%type
541: ,org_structure_id ghr_pa_request_extra_info.rei_information8%type
542: ,office_symbol ghr_pa_request_extra_info.rei_information9%type
535: ,rating_rec ghr_pa_request_extra_info.rei_information3%type
536: ,rating_rec_pattern ghr_pa_request_extra_info.rei_information4%type
537: ,rating_rec_level ghr_pa_request_extra_info.rei_information5%type
538: ,date_appr_starts ghr_pa_request_extra_info.rei_information19%type --Bug#4753117
539: ,date_appr_ends ghr_pa_request_extra_info.rei_information6%type
540: ,unit ghr_pa_request_extra_info.rei_information7%type
541: ,org_structure_id ghr_pa_request_extra_info.rei_information8%type
542: ,office_symbol ghr_pa_request_extra_info.rei_information9%type
543: ,pay_plan ghr_pa_request_extra_info.rei_information10%type
536: ,rating_rec_pattern ghr_pa_request_extra_info.rei_information4%type
537: ,rating_rec_level ghr_pa_request_extra_info.rei_information5%type
538: ,date_appr_starts ghr_pa_request_extra_info.rei_information19%type --Bug#4753117
539: ,date_appr_ends ghr_pa_request_extra_info.rei_information6%type
540: ,unit ghr_pa_request_extra_info.rei_information7%type
541: ,org_structure_id ghr_pa_request_extra_info.rei_information8%type
542: ,office_symbol ghr_pa_request_extra_info.rei_information9%type
543: ,pay_plan ghr_pa_request_extra_info.rei_information10%type
544: ,grade ghr_pa_request_extra_info.rei_information11%type
537: ,rating_rec_level ghr_pa_request_extra_info.rei_information5%type
538: ,date_appr_starts ghr_pa_request_extra_info.rei_information19%type --Bug#4753117
539: ,date_appr_ends ghr_pa_request_extra_info.rei_information6%type
540: ,unit ghr_pa_request_extra_info.rei_information7%type
541: ,org_structure_id ghr_pa_request_extra_info.rei_information8%type
542: ,office_symbol ghr_pa_request_extra_info.rei_information9%type
543: ,pay_plan ghr_pa_request_extra_info.rei_information10%type
544: ,grade ghr_pa_request_extra_info.rei_information11%type
545: ,date_due ghr_pa_request_extra_info.rei_information12%type
538: ,date_appr_starts ghr_pa_request_extra_info.rei_information19%type --Bug#4753117
539: ,date_appr_ends ghr_pa_request_extra_info.rei_information6%type
540: ,unit ghr_pa_request_extra_info.rei_information7%type
541: ,org_structure_id ghr_pa_request_extra_info.rei_information8%type
542: ,office_symbol ghr_pa_request_extra_info.rei_information9%type
543: ,pay_plan ghr_pa_request_extra_info.rei_information10%type
544: ,grade ghr_pa_request_extra_info.rei_information11%type
545: ,date_due ghr_pa_request_extra_info.rei_information12%type
546: ,appraisal_system_identifier ghr_pa_request_extra_info.rei_information13%type
539: ,date_appr_ends ghr_pa_request_extra_info.rei_information6%type
540: ,unit ghr_pa_request_extra_info.rei_information7%type
541: ,org_structure_id ghr_pa_request_extra_info.rei_information8%type
542: ,office_symbol ghr_pa_request_extra_info.rei_information9%type
543: ,pay_plan ghr_pa_request_extra_info.rei_information10%type
544: ,grade ghr_pa_request_extra_info.rei_information11%type
545: ,date_due ghr_pa_request_extra_info.rei_information12%type
546: ,appraisal_system_identifier ghr_pa_request_extra_info.rei_information13%type
547: ,appraisal_type ghr_pa_request_extra_info.rei_information14%type
540: ,unit ghr_pa_request_extra_info.rei_information7%type
541: ,org_structure_id ghr_pa_request_extra_info.rei_information8%type
542: ,office_symbol ghr_pa_request_extra_info.rei_information9%type
543: ,pay_plan ghr_pa_request_extra_info.rei_information10%type
544: ,grade ghr_pa_request_extra_info.rei_information11%type
545: ,date_due ghr_pa_request_extra_info.rei_information12%type
546: ,appraisal_system_identifier ghr_pa_request_extra_info.rei_information13%type
547: ,appraisal_type ghr_pa_request_extra_info.rei_information14%type
548: ,date_effective ghr_pa_request_extra_info.rei_information15%type
541: ,org_structure_id ghr_pa_request_extra_info.rei_information8%type
542: ,office_symbol ghr_pa_request_extra_info.rei_information9%type
543: ,pay_plan ghr_pa_request_extra_info.rei_information10%type
544: ,grade ghr_pa_request_extra_info.rei_information11%type
545: ,date_due ghr_pa_request_extra_info.rei_information12%type
546: ,appraisal_system_identifier ghr_pa_request_extra_info.rei_information13%type
547: ,appraisal_type ghr_pa_request_extra_info.rei_information14%type
548: ,date_effective ghr_pa_request_extra_info.rei_information15%type
549: ,date_init_appr_due ghr_pa_request_extra_info.rei_information16%type
542: ,office_symbol ghr_pa_request_extra_info.rei_information9%type
543: ,pay_plan ghr_pa_request_extra_info.rei_information10%type
544: ,grade ghr_pa_request_extra_info.rei_information11%type
545: ,date_due ghr_pa_request_extra_info.rei_information12%type
546: ,appraisal_system_identifier ghr_pa_request_extra_info.rei_information13%type
547: ,appraisal_type ghr_pa_request_extra_info.rei_information14%type
548: ,date_effective ghr_pa_request_extra_info.rei_information15%type
549: ,date_init_appr_due ghr_pa_request_extra_info.rei_information16%type
550: ,optional_information ghr_pa_request_extra_info.rei_information17%type
543: ,pay_plan ghr_pa_request_extra_info.rei_information10%type
544: ,grade ghr_pa_request_extra_info.rei_information11%type
545: ,date_due ghr_pa_request_extra_info.rei_information12%type
546: ,appraisal_system_identifier ghr_pa_request_extra_info.rei_information13%type
547: ,appraisal_type ghr_pa_request_extra_info.rei_information14%type
548: ,date_effective ghr_pa_request_extra_info.rei_information15%type
549: ,date_init_appr_due ghr_pa_request_extra_info.rei_information16%type
550: ,optional_information ghr_pa_request_extra_info.rei_information17%type
551: ,person_analysis_id per_person_analyses.person_analysis_id%type
544: ,grade ghr_pa_request_extra_info.rei_information11%type
545: ,date_due ghr_pa_request_extra_info.rei_information12%type
546: ,appraisal_system_identifier ghr_pa_request_extra_info.rei_information13%type
547: ,appraisal_type ghr_pa_request_extra_info.rei_information14%type
548: ,date_effective ghr_pa_request_extra_info.rei_information15%type
549: ,date_init_appr_due ghr_pa_request_extra_info.rei_information16%type
550: ,optional_information ghr_pa_request_extra_info.rei_information17%type
551: ,person_analysis_id per_person_analyses.person_analysis_id%type
552: ,object_version_number per_person_analyses.object_version_number%type
545: ,date_due ghr_pa_request_extra_info.rei_information12%type
546: ,appraisal_system_identifier ghr_pa_request_extra_info.rei_information13%type
547: ,appraisal_type ghr_pa_request_extra_info.rei_information14%type
548: ,date_effective ghr_pa_request_extra_info.rei_information15%type
549: ,date_init_appr_due ghr_pa_request_extra_info.rei_information16%type
550: ,optional_information ghr_pa_request_extra_info.rei_information17%type
551: ,person_analysis_id per_person_analyses.person_analysis_id%type
552: ,object_version_number per_person_analyses.object_version_number%type
553: --Added for Bug 3636398
546: ,appraisal_system_identifier ghr_pa_request_extra_info.rei_information13%type
547: ,appraisal_type ghr_pa_request_extra_info.rei_information14%type
548: ,date_effective ghr_pa_request_extra_info.rei_information15%type
549: ,date_init_appr_due ghr_pa_request_extra_info.rei_information16%type
550: ,optional_information ghr_pa_request_extra_info.rei_information17%type
551: ,person_analysis_id per_person_analyses.person_analysis_id%type
552: ,object_version_number per_person_analyses.object_version_number%type
553: --Added for Bug 3636398
554: ,performance_rating_points ghr_pa_request_extra_info.rei_information18%type);
550: ,optional_information ghr_pa_request_extra_info.rei_information17%type
551: ,person_analysis_id per_person_analyses.person_analysis_id%type
552: ,object_version_number per_person_analyses.object_version_number%type
553: --Added for Bug 3636398
554: ,performance_rating_points ghr_pa_request_extra_info.rei_information18%type);
555:
556: -- Added 10/24/97
557: type conduct_performance_type is record
558: ( cond_perf_flag varchar2(1)
555:
556: -- Added 10/24/97
557: type conduct_performance_type is record
558: ( cond_perf_flag varchar2(1)
559: ,type_of_employment ghr_pa_request_extra_info.rei_information3%type
560: ,adverse_action_noac ghr_pa_request_extra_info.rei_information4%type
561: ,cause_of_disc_action ghr_pa_request_extra_info.rei_information5%type
562: ,date_of_adverse_action ghr_pa_request_extra_info.rei_information6%type
563: ,days_suspended ghr_pa_request_extra_info.rei_information7%type
556: -- Added 10/24/97
557: type conduct_performance_type is record
558: ( cond_perf_flag varchar2(1)
559: ,type_of_employment ghr_pa_request_extra_info.rei_information3%type
560: ,adverse_action_noac ghr_pa_request_extra_info.rei_information4%type
561: ,cause_of_disc_action ghr_pa_request_extra_info.rei_information5%type
562: ,date_of_adverse_action ghr_pa_request_extra_info.rei_information6%type
563: ,days_suspended ghr_pa_request_extra_info.rei_information7%type
564: ,date_suspension_over_30 ghr_pa_request_extra_info.rei_information8%type
557: type conduct_performance_type is record
558: ( cond_perf_flag varchar2(1)
559: ,type_of_employment ghr_pa_request_extra_info.rei_information3%type
560: ,adverse_action_noac ghr_pa_request_extra_info.rei_information4%type
561: ,cause_of_disc_action ghr_pa_request_extra_info.rei_information5%type
562: ,date_of_adverse_action ghr_pa_request_extra_info.rei_information6%type
563: ,days_suspended ghr_pa_request_extra_info.rei_information7%type
564: ,date_suspension_over_30 ghr_pa_request_extra_info.rei_information8%type
565: ,date_suspension_under_30 ghr_pa_request_extra_info.rei_information9%type
558: ( cond_perf_flag varchar2(1)
559: ,type_of_employment ghr_pa_request_extra_info.rei_information3%type
560: ,adverse_action_noac ghr_pa_request_extra_info.rei_information4%type
561: ,cause_of_disc_action ghr_pa_request_extra_info.rei_information5%type
562: ,date_of_adverse_action ghr_pa_request_extra_info.rei_information6%type
563: ,days_suspended ghr_pa_request_extra_info.rei_information7%type
564: ,date_suspension_over_30 ghr_pa_request_extra_info.rei_information8%type
565: ,date_suspension_under_30 ghr_pa_request_extra_info.rei_information9%type
566: ,pip_action_taken ghr_pa_request_extra_info.rei_information10%type
559: ,type_of_employment ghr_pa_request_extra_info.rei_information3%type
560: ,adverse_action_noac ghr_pa_request_extra_info.rei_information4%type
561: ,cause_of_disc_action ghr_pa_request_extra_info.rei_information5%type
562: ,date_of_adverse_action ghr_pa_request_extra_info.rei_information6%type
563: ,days_suspended ghr_pa_request_extra_info.rei_information7%type
564: ,date_suspension_over_30 ghr_pa_request_extra_info.rei_information8%type
565: ,date_suspension_under_30 ghr_pa_request_extra_info.rei_information9%type
566: ,pip_action_taken ghr_pa_request_extra_info.rei_information10%type
567: ,pip_begin_date ghr_pa_request_extra_info.rei_information11%type
560: ,adverse_action_noac ghr_pa_request_extra_info.rei_information4%type
561: ,cause_of_disc_action ghr_pa_request_extra_info.rei_information5%type
562: ,date_of_adverse_action ghr_pa_request_extra_info.rei_information6%type
563: ,days_suspended ghr_pa_request_extra_info.rei_information7%type
564: ,date_suspension_over_30 ghr_pa_request_extra_info.rei_information8%type
565: ,date_suspension_under_30 ghr_pa_request_extra_info.rei_information9%type
566: ,pip_action_taken ghr_pa_request_extra_info.rei_information10%type
567: ,pip_begin_date ghr_pa_request_extra_info.rei_information11%type
568: ,pip_end_date ghr_pa_request_extra_info.rei_information12%type
561: ,cause_of_disc_action ghr_pa_request_extra_info.rei_information5%type
562: ,date_of_adverse_action ghr_pa_request_extra_info.rei_information6%type
563: ,days_suspended ghr_pa_request_extra_info.rei_information7%type
564: ,date_suspension_over_30 ghr_pa_request_extra_info.rei_information8%type
565: ,date_suspension_under_30 ghr_pa_request_extra_info.rei_information9%type
566: ,pip_action_taken ghr_pa_request_extra_info.rei_information10%type
567: ,pip_begin_date ghr_pa_request_extra_info.rei_information11%type
568: ,pip_end_date ghr_pa_request_extra_info.rei_information12%type
569: ,pip_extensions ghr_pa_request_extra_info.rei_information13%type
562: ,date_of_adverse_action ghr_pa_request_extra_info.rei_information6%type
563: ,days_suspended ghr_pa_request_extra_info.rei_information7%type
564: ,date_suspension_over_30 ghr_pa_request_extra_info.rei_information8%type
565: ,date_suspension_under_30 ghr_pa_request_extra_info.rei_information9%type
566: ,pip_action_taken ghr_pa_request_extra_info.rei_information10%type
567: ,pip_begin_date ghr_pa_request_extra_info.rei_information11%type
568: ,pip_end_date ghr_pa_request_extra_info.rei_information12%type
569: ,pip_extensions ghr_pa_request_extra_info.rei_information13%type
570: ,pip_length ghr_pa_request_extra_info.rei_information14%type
563: ,days_suspended ghr_pa_request_extra_info.rei_information7%type
564: ,date_suspension_over_30 ghr_pa_request_extra_info.rei_information8%type
565: ,date_suspension_under_30 ghr_pa_request_extra_info.rei_information9%type
566: ,pip_action_taken ghr_pa_request_extra_info.rei_information10%type
567: ,pip_begin_date ghr_pa_request_extra_info.rei_information11%type
568: ,pip_end_date ghr_pa_request_extra_info.rei_information12%type
569: ,pip_extensions ghr_pa_request_extra_info.rei_information13%type
570: ,pip_length ghr_pa_request_extra_info.rei_information14%type
571: ,date_reprimand_expires ghr_pa_request_extra_info.rei_information15%type
564: ,date_suspension_over_30 ghr_pa_request_extra_info.rei_information8%type
565: ,date_suspension_under_30 ghr_pa_request_extra_info.rei_information9%type
566: ,pip_action_taken ghr_pa_request_extra_info.rei_information10%type
567: ,pip_begin_date ghr_pa_request_extra_info.rei_information11%type
568: ,pip_end_date ghr_pa_request_extra_info.rei_information12%type
569: ,pip_extensions ghr_pa_request_extra_info.rei_information13%type
570: ,pip_length ghr_pa_request_extra_info.rei_information14%type
571: ,date_reprimand_expires ghr_pa_request_extra_info.rei_information15%type
572: ,person_analysis_id per_person_analyses.person_analysis_id%type
565: ,date_suspension_under_30 ghr_pa_request_extra_info.rei_information9%type
566: ,pip_action_taken ghr_pa_request_extra_info.rei_information10%type
567: ,pip_begin_date ghr_pa_request_extra_info.rei_information11%type
568: ,pip_end_date ghr_pa_request_extra_info.rei_information12%type
569: ,pip_extensions ghr_pa_request_extra_info.rei_information13%type
570: ,pip_length ghr_pa_request_extra_info.rei_information14%type
571: ,date_reprimand_expires ghr_pa_request_extra_info.rei_information15%type
572: ,person_analysis_id per_person_analyses.person_analysis_id%type
573: ,object_version_number per_person_analyses.object_version_number%type);
566: ,pip_action_taken ghr_pa_request_extra_info.rei_information10%type
567: ,pip_begin_date ghr_pa_request_extra_info.rei_information11%type
568: ,pip_end_date ghr_pa_request_extra_info.rei_information12%type
569: ,pip_extensions ghr_pa_request_extra_info.rei_information13%type
570: ,pip_length ghr_pa_request_extra_info.rei_information14%type
571: ,date_reprimand_expires ghr_pa_request_extra_info.rei_information15%type
572: ,person_analysis_id per_person_analyses.person_analysis_id%type
573: ,object_version_number per_person_analyses.object_version_number%type);
574:
567: ,pip_begin_date ghr_pa_request_extra_info.rei_information11%type
568: ,pip_end_date ghr_pa_request_extra_info.rei_information12%type
569: ,pip_extensions ghr_pa_request_extra_info.rei_information13%type
570: ,pip_length ghr_pa_request_extra_info.rei_information14%type
571: ,date_reprimand_expires ghr_pa_request_extra_info.rei_information15%type
572: ,person_analysis_id per_person_analyses.person_analysis_id%type
573: ,object_version_number per_person_analyses.object_version_number%type);
574:
575:
642: );
643: --
644: type entitlement_type is record
645: (entitlement_flag varchar2(1)
646: ,entitlement_code ghr_pa_request_extra_info.rei_information3%type
647: ,entitlement_amt_percent ghr_pa_request_extra_info.rei_information4%type
648: );
649: -- Bug#2759379 Created FEGLI Record type
650: type fegli_type is record
643: --
644: type entitlement_type is record
645: (entitlement_flag varchar2(1)
646: ,entitlement_code ghr_pa_request_extra_info.rei_information3%type
647: ,entitlement_amt_percent ghr_pa_request_extra_info.rei_information4%type
648: );
649: -- Bug#2759379 Created FEGLI Record type
650: type fegli_type is record
651: (fegli_flag varchar2(1)
648: );
649: -- Bug#2759379 Created FEGLI Record type
650: type fegli_type is record
651: (fegli_flag varchar2(1)
652: ,eligibility_expiration ghr_pa_request_extra_info.rei_information1%type
653: );
654: --
655: type foreign_lang_prof_pay_type is record
656: (for_lang_flag varchar2(1)
653: );
654: --
655: type foreign_lang_prof_pay_type is record
656: (for_lang_flag varchar2(1)
657: ,certification_date ghr_pa_request_extra_info.rei_information3%type
658: ,pay_level_or_rate ghr_pa_request_extra_info.rei_information4%type
659: );
660: --
661: -- Bug#3385386 Added record type FTA
654: --
655: type foreign_lang_prof_pay_type is record
656: (for_lang_flag varchar2(1)
657: ,certification_date ghr_pa_request_extra_info.rei_information3%type
658: ,pay_level_or_rate ghr_pa_request_extra_info.rei_information4%type
659: );
660: --
661: -- Bug#3385386 Added record type FTA
662: type fta_type is record
660: --
661: -- Bug#3385386 Added record type FTA
662: type fta_type is record
663: (fta_flag varchar2(1)
664: ,last_action_code ghr_pa_request_extra_info.rei_information3%type
665: ,Number_family_members ghr_pa_request_extra_info.rei_information4%type
666: ,Miscellaneous_Expense ghr_pa_request_extra_info.rei_information5%type
667: ,Wardrobe_Expense ghr_pa_request_extra_info.rei_information6%type
668: ,Pre_Departure_Subs_Expense ghr_pa_request_extra_info.rei_information7%type
661: -- Bug#3385386 Added record type FTA
662: type fta_type is record
663: (fta_flag varchar2(1)
664: ,last_action_code ghr_pa_request_extra_info.rei_information3%type
665: ,Number_family_members ghr_pa_request_extra_info.rei_information4%type
666: ,Miscellaneous_Expense ghr_pa_request_extra_info.rei_information5%type
667: ,Wardrobe_Expense ghr_pa_request_extra_info.rei_information6%type
668: ,Pre_Departure_Subs_Expense ghr_pa_request_extra_info.rei_information7%type
669: ,Lease_Penalty_Expense ghr_pa_request_extra_info.rei_information8%type
662: type fta_type is record
663: (fta_flag varchar2(1)
664: ,last_action_code ghr_pa_request_extra_info.rei_information3%type
665: ,Number_family_members ghr_pa_request_extra_info.rei_information4%type
666: ,Miscellaneous_Expense ghr_pa_request_extra_info.rei_information5%type
667: ,Wardrobe_Expense ghr_pa_request_extra_info.rei_information6%type
668: ,Pre_Departure_Subs_Expense ghr_pa_request_extra_info.rei_information7%type
669: ,Lease_Penalty_Expense ghr_pa_request_extra_info.rei_information8%type
670: ,Amount ghr_pa_request_extra_info.rei_information9%type
663: (fta_flag varchar2(1)
664: ,last_action_code ghr_pa_request_extra_info.rei_information3%type
665: ,Number_family_members ghr_pa_request_extra_info.rei_information4%type
666: ,Miscellaneous_Expense ghr_pa_request_extra_info.rei_information5%type
667: ,Wardrobe_Expense ghr_pa_request_extra_info.rei_information6%type
668: ,Pre_Departure_Subs_Expense ghr_pa_request_extra_info.rei_information7%type
669: ,Lease_Penalty_Expense ghr_pa_request_extra_info.rei_information8%type
670: ,Amount ghr_pa_request_extra_info.rei_information9%type
671: );
664: ,last_action_code ghr_pa_request_extra_info.rei_information3%type
665: ,Number_family_members ghr_pa_request_extra_info.rei_information4%type
666: ,Miscellaneous_Expense ghr_pa_request_extra_info.rei_information5%type
667: ,Wardrobe_Expense ghr_pa_request_extra_info.rei_information6%type
668: ,Pre_Departure_Subs_Expense ghr_pa_request_extra_info.rei_information7%type
669: ,Lease_Penalty_Expense ghr_pa_request_extra_info.rei_information8%type
670: ,Amount ghr_pa_request_extra_info.rei_information9%type
671: );
672: --
665: ,Number_family_members ghr_pa_request_extra_info.rei_information4%type
666: ,Miscellaneous_Expense ghr_pa_request_extra_info.rei_information5%type
667: ,Wardrobe_Expense ghr_pa_request_extra_info.rei_information6%type
668: ,Pre_Departure_Subs_Expense ghr_pa_request_extra_info.rei_information7%type
669: ,Lease_Penalty_Expense ghr_pa_request_extra_info.rei_information8%type
670: ,Amount ghr_pa_request_extra_info.rei_information9%type
671: );
672: --
673: type edp_pay_type is record
666: ,Miscellaneous_Expense ghr_pa_request_extra_info.rei_information5%type
667: ,Wardrobe_Expense ghr_pa_request_extra_info.rei_information6%type
668: ,Pre_Departure_Subs_Expense ghr_pa_request_extra_info.rei_information7%type
669: ,Lease_Penalty_Expense ghr_pa_request_extra_info.rei_information8%type
670: ,Amount ghr_pa_request_extra_info.rei_information9%type
671: );
672: --
673: type edp_pay_type is record
674: (edp_flag varchar2(1)
671: );
672: --
673: type edp_pay_type is record
674: (edp_flag varchar2(1)
675: ,premium_pay_indicator ghr_pa_request_extra_info.rei_information3%type
676: ,edp_type ghr_pa_request_extra_info.rei_information4%type
677: );
678: --
679: type hazard_pay_type is record
672: --
673: type edp_pay_type is record
674: (edp_flag varchar2(1)
675: ,premium_pay_indicator ghr_pa_request_extra_info.rei_information3%type
676: ,edp_type ghr_pa_request_extra_info.rei_information4%type
677: );
678: --
679: type hazard_pay_type is record
680: (hazard_flag varchar2(1)
677: );
678: --
679: type hazard_pay_type is record
680: (hazard_flag varchar2(1)
681: ,premium_pay_indicator ghr_pa_request_extra_info.rei_information3%type
682: ,hazard_type ghr_pa_request_extra_info.rei_information4%type
683: );
684: --
685: type health_benefits_type is record
678: --
679: type hazard_pay_type is record
680: (hazard_flag varchar2(1)
681: ,premium_pay_indicator ghr_pa_request_extra_info.rei_information3%type
682: ,hazard_type ghr_pa_request_extra_info.rei_information4%type
683: );
684: --
685: type health_benefits_type is record
686: (health_benefits_flag varchar2(1)
683: );
684: --
685: type health_benefits_type is record
686: (health_benefits_flag varchar2(1)
687: ,enrollment ghr_pa_request_extra_info.rei_information3%type
688: ,health_plan ghr_pa_request_extra_info.rei_information4%type
689: ,temps_total_cost ghr_pa_request_extra_info.rei_information5%type
690: ,pre_tax_waiver ghr_pa_request_extra_info.rei_information6%type
691: );
684: --
685: type health_benefits_type is record
686: (health_benefits_flag varchar2(1)
687: ,enrollment ghr_pa_request_extra_info.rei_information3%type
688: ,health_plan ghr_pa_request_extra_info.rei_information4%type
689: ,temps_total_cost ghr_pa_request_extra_info.rei_information5%type
690: ,pre_tax_waiver ghr_pa_request_extra_info.rei_information6%type
691: );
692: --
685: type health_benefits_type is record
686: (health_benefits_flag varchar2(1)
687: ,enrollment ghr_pa_request_extra_info.rei_information3%type
688: ,health_plan ghr_pa_request_extra_info.rei_information4%type
689: ,temps_total_cost ghr_pa_request_extra_info.rei_information5%type
690: ,pre_tax_waiver ghr_pa_request_extra_info.rei_information6%type
691: );
692: --
693: --
686: (health_benefits_flag varchar2(1)
687: ,enrollment ghr_pa_request_extra_info.rei_information3%type
688: ,health_plan ghr_pa_request_extra_info.rei_information4%type
689: ,temps_total_cost ghr_pa_request_extra_info.rei_information5%type
690: ,pre_tax_waiver ghr_pa_request_extra_info.rei_information6%type
691: );
692: --
693: --
694: type health_ben_pre_tax_type is record
692: --
693: --
694: type health_ben_pre_tax_type is record
695: (health_ben_pre_tax_flag varchar2(1)
696: ,enrollment ghr_pa_request_extra_info.rei_information3%type
697: ,health_plan ghr_pa_request_extra_info.rei_information4%type
698: ,temps_total_cost ghr_pa_request_extra_info.rei_information5%type
699: );
700: --
693: --
694: type health_ben_pre_tax_type is record
695: (health_ben_pre_tax_flag varchar2(1)
696: ,enrollment ghr_pa_request_extra_info.rei_information3%type
697: ,health_plan ghr_pa_request_extra_info.rei_information4%type
698: ,temps_total_cost ghr_pa_request_extra_info.rei_information5%type
699: );
700: --
701: type danger_pay_type is record
694: type health_ben_pre_tax_type is record
695: (health_ben_pre_tax_flag varchar2(1)
696: ,enrollment ghr_pa_request_extra_info.rei_information3%type
697: ,health_plan ghr_pa_request_extra_info.rei_information4%type
698: ,temps_total_cost ghr_pa_request_extra_info.rei_information5%type
699: );
700: --
701: type danger_pay_type is record
702: (danger_flag varchar2(1)
699: );
700: --
701: type danger_pay_type is record
702: (danger_flag varchar2(1)
703: ,last_action_code ghr_pa_request_extra_info.rei_information3%type
704: ,location ghr_pa_request_extra_info.rei_information4%type
705: );
706: --
707: type imminent_danger_pay_type is record
700: --
701: type danger_pay_type is record
702: (danger_flag varchar2(1)
703: ,last_action_code ghr_pa_request_extra_info.rei_information3%type
704: ,location ghr_pa_request_extra_info.rei_information4%type
705: );
706: --
707: type imminent_danger_pay_type is record
708: (imminent_danger_flag varchar2(1)
705: );
706: --
707: type imminent_danger_pay_type is record
708: (imminent_danger_flag varchar2(1)
709: ,amount ghr_pa_request_extra_info.rei_information3%type
710: ,location ghr_pa_request_extra_info.rei_information4%type
711: ,last_action_code ghr_pa_request_extra_info.rei_information5%type
712: );
713: --
706: --
707: type imminent_danger_pay_type is record
708: (imminent_danger_flag varchar2(1)
709: ,amount ghr_pa_request_extra_info.rei_information3%type
710: ,location ghr_pa_request_extra_info.rei_information4%type
711: ,last_action_code ghr_pa_request_extra_info.rei_information5%type
712: );
713: --
714: type living_quarters_allow_type is record
707: type imminent_danger_pay_type is record
708: (imminent_danger_flag varchar2(1)
709: ,amount ghr_pa_request_extra_info.rei_information3%type
710: ,location ghr_pa_request_extra_info.rei_information4%type
711: ,last_action_code ghr_pa_request_extra_info.rei_information5%type
712: );
713: --
714: type living_quarters_allow_type is record
715: (living_quarters_allow_flag varchar2(1)
712: );
713: --
714: type living_quarters_allow_type is record
715: (living_quarters_allow_flag varchar2(1)
716: ,purchase_amount ghr_pa_request_extra_info.rei_information3%type
717: ,purchase_date ghr_pa_request_extra_info.rei_information4%type
718: ,rent_amount ghr_pa_request_extra_info.rei_information5%type
719: ,utility_amount ghr_pa_request_extra_info.rei_information6%type
720: ,last_action_code ghr_pa_request_extra_info.rei_information7%type
713: --
714: type living_quarters_allow_type is record
715: (living_quarters_allow_flag varchar2(1)
716: ,purchase_amount ghr_pa_request_extra_info.rei_information3%type
717: ,purchase_date ghr_pa_request_extra_info.rei_information4%type
718: ,rent_amount ghr_pa_request_extra_info.rei_information5%type
719: ,utility_amount ghr_pa_request_extra_info.rei_information6%type
720: ,last_action_code ghr_pa_request_extra_info.rei_information7%type
721: ,location ghr_pa_request_extra_info.rei_information8%type
714: type living_quarters_allow_type is record
715: (living_quarters_allow_flag varchar2(1)
716: ,purchase_amount ghr_pa_request_extra_info.rei_information3%type
717: ,purchase_date ghr_pa_request_extra_info.rei_information4%type
718: ,rent_amount ghr_pa_request_extra_info.rei_information5%type
719: ,utility_amount ghr_pa_request_extra_info.rei_information6%type
720: ,last_action_code ghr_pa_request_extra_info.rei_information7%type
721: ,location ghr_pa_request_extra_info.rei_information8%type
722: ,quarters_type ghr_pa_request_extra_info.rei_information9%type
715: (living_quarters_allow_flag varchar2(1)
716: ,purchase_amount ghr_pa_request_extra_info.rei_information3%type
717: ,purchase_date ghr_pa_request_extra_info.rei_information4%type
718: ,rent_amount ghr_pa_request_extra_info.rei_information5%type
719: ,utility_amount ghr_pa_request_extra_info.rei_information6%type
720: ,last_action_code ghr_pa_request_extra_info.rei_information7%type
721: ,location ghr_pa_request_extra_info.rei_information8%type
722: ,quarters_type ghr_pa_request_extra_info.rei_information9%type
723: ,shared_percent ghr_pa_request_extra_info.rei_information10%type
716: ,purchase_amount ghr_pa_request_extra_info.rei_information3%type
717: ,purchase_date ghr_pa_request_extra_info.rei_information4%type
718: ,rent_amount ghr_pa_request_extra_info.rei_information5%type
719: ,utility_amount ghr_pa_request_extra_info.rei_information6%type
720: ,last_action_code ghr_pa_request_extra_info.rei_information7%type
721: ,location ghr_pa_request_extra_info.rei_information8%type
722: ,quarters_type ghr_pa_request_extra_info.rei_information9%type
723: ,shared_percent ghr_pa_request_extra_info.rei_information10%type
724: ,no_of_family_members ghr_pa_request_extra_info.rei_information11%type
717: ,purchase_date ghr_pa_request_extra_info.rei_information4%type
718: ,rent_amount ghr_pa_request_extra_info.rei_information5%type
719: ,utility_amount ghr_pa_request_extra_info.rei_information6%type
720: ,last_action_code ghr_pa_request_extra_info.rei_information7%type
721: ,location ghr_pa_request_extra_info.rei_information8%type
722: ,quarters_type ghr_pa_request_extra_info.rei_information9%type
723: ,shared_percent ghr_pa_request_extra_info.rei_information10%type
724: ,no_of_family_members ghr_pa_request_extra_info.rei_information11%type
725: ,summer_record_ind ghr_pa_request_extra_info.rei_information12%type
718: ,rent_amount ghr_pa_request_extra_info.rei_information5%type
719: ,utility_amount ghr_pa_request_extra_info.rei_information6%type
720: ,last_action_code ghr_pa_request_extra_info.rei_information7%type
721: ,location ghr_pa_request_extra_info.rei_information8%type
722: ,quarters_type ghr_pa_request_extra_info.rei_information9%type
723: ,shared_percent ghr_pa_request_extra_info.rei_information10%type
724: ,no_of_family_members ghr_pa_request_extra_info.rei_information11%type
725: ,summer_record_ind ghr_pa_request_extra_info.rei_information12%type
726: ,quarters_group ghr_pa_request_extra_info.rei_information13%type
719: ,utility_amount ghr_pa_request_extra_info.rei_information6%type
720: ,last_action_code ghr_pa_request_extra_info.rei_information7%type
721: ,location ghr_pa_request_extra_info.rei_information8%type
722: ,quarters_type ghr_pa_request_extra_info.rei_information9%type
723: ,shared_percent ghr_pa_request_extra_info.rei_information10%type
724: ,no_of_family_members ghr_pa_request_extra_info.rei_information11%type
725: ,summer_record_ind ghr_pa_request_extra_info.rei_information12%type
726: ,quarters_group ghr_pa_request_extra_info.rei_information13%type
727: ,currency ghr_pa_request_extra_info.rei_information14%type
720: ,last_action_code ghr_pa_request_extra_info.rei_information7%type
721: ,location ghr_pa_request_extra_info.rei_information8%type
722: ,quarters_type ghr_pa_request_extra_info.rei_information9%type
723: ,shared_percent ghr_pa_request_extra_info.rei_information10%type
724: ,no_of_family_members ghr_pa_request_extra_info.rei_information11%type
725: ,summer_record_ind ghr_pa_request_extra_info.rei_information12%type
726: ,quarters_group ghr_pa_request_extra_info.rei_information13%type
727: ,currency ghr_pa_request_extra_info.rei_information14%type
728: );
721: ,location ghr_pa_request_extra_info.rei_information8%type
722: ,quarters_type ghr_pa_request_extra_info.rei_information9%type
723: ,shared_percent ghr_pa_request_extra_info.rei_information10%type
724: ,no_of_family_members ghr_pa_request_extra_info.rei_information11%type
725: ,summer_record_ind ghr_pa_request_extra_info.rei_information12%type
726: ,quarters_group ghr_pa_request_extra_info.rei_information13%type
727: ,currency ghr_pa_request_extra_info.rei_information14%type
728: );
729: --
722: ,quarters_type ghr_pa_request_extra_info.rei_information9%type
723: ,shared_percent ghr_pa_request_extra_info.rei_information10%type
724: ,no_of_family_members ghr_pa_request_extra_info.rei_information11%type
725: ,summer_record_ind ghr_pa_request_extra_info.rei_information12%type
726: ,quarters_group ghr_pa_request_extra_info.rei_information13%type
727: ,currency ghr_pa_request_extra_info.rei_information14%type
728: );
729: --
730: type post_diff_amt_type is record
723: ,shared_percent ghr_pa_request_extra_info.rei_information10%type
724: ,no_of_family_members ghr_pa_request_extra_info.rei_information11%type
725: ,summer_record_ind ghr_pa_request_extra_info.rei_information12%type
726: ,quarters_group ghr_pa_request_extra_info.rei_information13%type
727: ,currency ghr_pa_request_extra_info.rei_information14%type
728: );
729: --
730: type post_diff_amt_type is record
731: (post_diff_amt_flag varchar2(1)
728: );
729: --
730: type post_diff_amt_type is record
731: (post_diff_amt_flag varchar2(1)
732: ,amount ghr_pa_request_extra_info.rei_information3%type
733: ,last_action_code ghr_pa_request_extra_info.rei_information4%type
734: ,location ghr_pa_request_extra_info.rei_information5%type
735: ,no_of_family_members ghr_pa_request_extra_info.rei_information6%type
736: );
729: --
730: type post_diff_amt_type is record
731: (post_diff_amt_flag varchar2(1)
732: ,amount ghr_pa_request_extra_info.rei_information3%type
733: ,last_action_code ghr_pa_request_extra_info.rei_information4%type
734: ,location ghr_pa_request_extra_info.rei_information5%type
735: ,no_of_family_members ghr_pa_request_extra_info.rei_information6%type
736: );
737: --
730: type post_diff_amt_type is record
731: (post_diff_amt_flag varchar2(1)
732: ,amount ghr_pa_request_extra_info.rei_information3%type
733: ,last_action_code ghr_pa_request_extra_info.rei_information4%type
734: ,location ghr_pa_request_extra_info.rei_information5%type
735: ,no_of_family_members ghr_pa_request_extra_info.rei_information6%type
736: );
737: --
738: type post_diff_percent_type is record
731: (post_diff_amt_flag varchar2(1)
732: ,amount ghr_pa_request_extra_info.rei_information3%type
733: ,last_action_code ghr_pa_request_extra_info.rei_information4%type
734: ,location ghr_pa_request_extra_info.rei_information5%type
735: ,no_of_family_members ghr_pa_request_extra_info.rei_information6%type
736: );
737: --
738: type post_diff_percent_type is record
739: (post_diff_percent_flag varchar2(1)
736: );
737: --
738: type post_diff_percent_type is record
739: (post_diff_percent_flag varchar2(1)
740: ,percent ghr_pa_request_extra_info.rei_information3%type
741: ,last_action_code ghr_pa_request_extra_info.rei_information4%type
742: ,location ghr_pa_request_extra_info.rei_information5%type
743: );
744: --
737: --
738: type post_diff_percent_type is record
739: (post_diff_percent_flag varchar2(1)
740: ,percent ghr_pa_request_extra_info.rei_information3%type
741: ,last_action_code ghr_pa_request_extra_info.rei_information4%type
742: ,location ghr_pa_request_extra_info.rei_information5%type
743: );
744: --
745: type sep_maintenance_allow_type is record
738: type post_diff_percent_type is record
739: (post_diff_percent_flag varchar2(1)
740: ,percent ghr_pa_request_extra_info.rei_information3%type
741: ,last_action_code ghr_pa_request_extra_info.rei_information4%type
742: ,location ghr_pa_request_extra_info.rei_information5%type
743: );
744: --
745: type sep_maintenance_allow_type is record
746: (sep_maint_allow_flag varchar2(1)
743: );
744: --
745: type sep_maintenance_allow_type is record
746: (sep_maint_allow_flag varchar2(1)
747: ,amount ghr_pa_request_extra_info.rei_information3%type
748: ,last_action_code ghr_pa_request_extra_info.rei_information4%type
749: ,category ghr_pa_request_extra_info.rei_information5%type
750: );
751: --
744: --
745: type sep_maintenance_allow_type is record
746: (sep_maint_allow_flag varchar2(1)
747: ,amount ghr_pa_request_extra_info.rei_information3%type
748: ,last_action_code ghr_pa_request_extra_info.rei_information4%type
749: ,category ghr_pa_request_extra_info.rei_information5%type
750: );
751: --
752: type supplemental_post_allow_type is record
745: type sep_maintenance_allow_type is record
746: (sep_maint_allow_flag varchar2(1)
747: ,amount ghr_pa_request_extra_info.rei_information3%type
748: ,last_action_code ghr_pa_request_extra_info.rei_information4%type
749: ,category ghr_pa_request_extra_info.rei_information5%type
750: );
751: --
752: type supplemental_post_allow_type is record
753: (sup_post_allow_flag varchar2(1)
750: );
751: --
752: type supplemental_post_allow_type is record
753: (sup_post_allow_flag varchar2(1)
754: ,amount ghr_pa_request_extra_info.rei_information3%type
755: );
756: --
757: type temp_lodge_allow_type is record
758: (temp_lodge_allow_flag varchar2(1)
755: );
756: --
757: type temp_lodge_allow_type is record
758: (temp_lodge_allow_flag varchar2(1)
759: ,allowance_type ghr_pa_request_extra_info.rei_information3%type
760: ,daily_rate ghr_pa_request_extra_info.rei_information4%type
761: );
762: --
763: type premium_pay_type is record
756: --
757: type temp_lodge_allow_type is record
758: (temp_lodge_allow_flag varchar2(1)
759: ,allowance_type ghr_pa_request_extra_info.rei_information3%type
760: ,daily_rate ghr_pa_request_extra_info.rei_information4%type
761: );
762: --
763: type premium_pay_type is record
764: (premium_pay_flag varchar2(1)
761: );
762: --
763: type premium_pay_type is record
764: (premium_pay_flag varchar2(1)
765: ,premium_pay_ind ghr_pa_request_extra_info.rei_information3%type
766: ,amount ghr_pa_request_extra_info.rei_information4%type
767: );
768: --
769: type retirement_annuity_type is record
762: --
763: type premium_pay_type is record
764: (premium_pay_flag varchar2(1)
765: ,premium_pay_ind ghr_pa_request_extra_info.rei_information3%type
766: ,amount ghr_pa_request_extra_info.rei_information4%type
767: );
768: --
769: type retirement_annuity_type is record
770: (retirement_annuity_flag varchar2(1)
767: );
768: --
769: type retirement_annuity_type is record
770: (retirement_annuity_flag varchar2(1)
771: ,annuity_sum ghr_pa_request_extra_info.rei_information3%type
772: ,eligibility_expires ghr_pa_request_extra_info.rei_information4%type
773: );
774: --
775: type severance_pay_type is record
768: --
769: type retirement_annuity_type is record
770: (retirement_annuity_flag varchar2(1)
771: ,annuity_sum ghr_pa_request_extra_info.rei_information3%type
772: ,eligibility_expires ghr_pa_request_extra_info.rei_information4%type
773: );
774: --
775: type severance_pay_type is record
776: (severance_pay_flag varchar2(1)
773: );
774: --
775: type severance_pay_type is record
776: (severance_pay_flag varchar2(1)
777: ,amount ghr_pa_request_extra_info.rei_information3%type
778: ,total_entitlement_weeks ghr_pa_request_extra_info.rei_information4%type
779: ,number_weeks_paid ghr_pa_request_extra_info.rei_information5%type
780: ,weekly_amount ghr_pa_request_extra_info.rei_information6%type
781: );
774: --
775: type severance_pay_type is record
776: (severance_pay_flag varchar2(1)
777: ,amount ghr_pa_request_extra_info.rei_information3%type
778: ,total_entitlement_weeks ghr_pa_request_extra_info.rei_information4%type
779: ,number_weeks_paid ghr_pa_request_extra_info.rei_information5%type
780: ,weekly_amount ghr_pa_request_extra_info.rei_information6%type
781: );
782: --
775: type severance_pay_type is record
776: (severance_pay_flag varchar2(1)
777: ,amount ghr_pa_request_extra_info.rei_information3%type
778: ,total_entitlement_weeks ghr_pa_request_extra_info.rei_information4%type
779: ,number_weeks_paid ghr_pa_request_extra_info.rei_information5%type
780: ,weekly_amount ghr_pa_request_extra_info.rei_information6%type
781: );
782: --
783: type thrift_saving_plan is record
776: (severance_pay_flag varchar2(1)
777: ,amount ghr_pa_request_extra_info.rei_information3%type
778: ,total_entitlement_weeks ghr_pa_request_extra_info.rei_information4%type
779: ,number_weeks_paid ghr_pa_request_extra_info.rei_information5%type
780: ,weekly_amount ghr_pa_request_extra_info.rei_information6%type
781: );
782: --
783: type thrift_saving_plan is record
784: (tsp_flag varchar2(1)
781: );
782: --
783: type thrift_saving_plan is record
784: (tsp_flag varchar2(1)
785: ,amount ghr_pa_request_extra_info.rei_information3%type
786: ,rate ghr_pa_request_extra_info.rei_information4%type
787: ,g_fund ghr_pa_request_extra_info.rei_information5%type
788: ,f_fund ghr_pa_request_extra_info.rei_information6%type
789: ,c_fund ghr_pa_request_extra_info.rei_information7%type
782: --
783: type thrift_saving_plan is record
784: (tsp_flag varchar2(1)
785: ,amount ghr_pa_request_extra_info.rei_information3%type
786: ,rate ghr_pa_request_extra_info.rei_information4%type
787: ,g_fund ghr_pa_request_extra_info.rei_information5%type
788: ,f_fund ghr_pa_request_extra_info.rei_information6%type
789: ,c_fund ghr_pa_request_extra_info.rei_information7%type
790: ,status ghr_pa_request_extra_info.rei_information8%type
783: type thrift_saving_plan is record
784: (tsp_flag varchar2(1)
785: ,amount ghr_pa_request_extra_info.rei_information3%type
786: ,rate ghr_pa_request_extra_info.rei_information4%type
787: ,g_fund ghr_pa_request_extra_info.rei_information5%type
788: ,f_fund ghr_pa_request_extra_info.rei_information6%type
789: ,c_fund ghr_pa_request_extra_info.rei_information7%type
790: ,status ghr_pa_request_extra_info.rei_information8%type
791: ,status_date ghr_pa_request_extra_info.rei_information9%type
784: (tsp_flag varchar2(1)
785: ,amount ghr_pa_request_extra_info.rei_information3%type
786: ,rate ghr_pa_request_extra_info.rei_information4%type
787: ,g_fund ghr_pa_request_extra_info.rei_information5%type
788: ,f_fund ghr_pa_request_extra_info.rei_information6%type
789: ,c_fund ghr_pa_request_extra_info.rei_information7%type
790: ,status ghr_pa_request_extra_info.rei_information8%type
791: ,status_date ghr_pa_request_extra_info.rei_information9%type
792: ,agncy_contrib_elig_date ghr_pa_request_extra_info.rei_information10%type
785: ,amount ghr_pa_request_extra_info.rei_information3%type
786: ,rate ghr_pa_request_extra_info.rei_information4%type
787: ,g_fund ghr_pa_request_extra_info.rei_information5%type
788: ,f_fund ghr_pa_request_extra_info.rei_information6%type
789: ,c_fund ghr_pa_request_extra_info.rei_information7%type
790: ,status ghr_pa_request_extra_info.rei_information8%type
791: ,status_date ghr_pa_request_extra_info.rei_information9%type
792: ,agncy_contrib_elig_date ghr_pa_request_extra_info.rei_information10%type
793: ,emp_contrib_elig_date ghr_pa_request_extra_info.rei_information11%type
786: ,rate ghr_pa_request_extra_info.rei_information4%type
787: ,g_fund ghr_pa_request_extra_info.rei_information5%type
788: ,f_fund ghr_pa_request_extra_info.rei_information6%type
789: ,c_fund ghr_pa_request_extra_info.rei_information7%type
790: ,status ghr_pa_request_extra_info.rei_information8%type
791: ,status_date ghr_pa_request_extra_info.rei_information9%type
792: ,agncy_contrib_elig_date ghr_pa_request_extra_info.rei_information10%type
793: ,emp_contrib_elig_date ghr_pa_request_extra_info.rei_information11%type
794: );
787: ,g_fund ghr_pa_request_extra_info.rei_information5%type
788: ,f_fund ghr_pa_request_extra_info.rei_information6%type
789: ,c_fund ghr_pa_request_extra_info.rei_information7%type
790: ,status ghr_pa_request_extra_info.rei_information8%type
791: ,status_date ghr_pa_request_extra_info.rei_information9%type
792: ,agncy_contrib_elig_date ghr_pa_request_extra_info.rei_information10%type
793: ,emp_contrib_elig_date ghr_pa_request_extra_info.rei_information11%type
794: );
795:
788: ,f_fund ghr_pa_request_extra_info.rei_information6%type
789: ,c_fund ghr_pa_request_extra_info.rei_information7%type
790: ,status ghr_pa_request_extra_info.rei_information8%type
791: ,status_date ghr_pa_request_extra_info.rei_information9%type
792: ,agncy_contrib_elig_date ghr_pa_request_extra_info.rei_information10%type
793: ,emp_contrib_elig_date ghr_pa_request_extra_info.rei_information11%type
794: );
795:
796: --BUG # 13571004 Added for TSP Roth Elements
789: ,c_fund ghr_pa_request_extra_info.rei_information7%type
790: ,status ghr_pa_request_extra_info.rei_information8%type
791: ,status_date ghr_pa_request_extra_info.rei_information9%type
792: ,agncy_contrib_elig_date ghr_pa_request_extra_info.rei_information10%type
793: ,emp_contrib_elig_date ghr_pa_request_extra_info.rei_information11%type
794: );
795:
796: --BUG # 13571004 Added for TSP Roth Elements
797: type tsp_roth_type is record
795:
796: --BUG # 13571004 Added for TSP Roth Elements
797: type tsp_roth_type is record
798: (tsp_roth_flag varchar2(1)
799: ,tsp_roth_401k_amount ghr_pa_request_extra_info.rei_information19%type
800: ,tsp_roth_401k_rate ghr_pa_request_extra_info.rei_information20%type
801: );
802: --
803: --Pradeep.
796: --BUG # 13571004 Added for TSP Roth Elements
797: type tsp_roth_type is record
798: (tsp_roth_flag varchar2(1)
799: ,tsp_roth_401k_amount ghr_pa_request_extra_info.rei_information19%type
800: ,tsp_roth_401k_rate ghr_pa_request_extra_info.rei_information20%type
801: );
802: --
803: --Pradeep.
804: type mddds_special_pay_type is record
802: --
803: --Pradeep.
804: type mddds_special_pay_type is record
805: ( mddds_special_pay_flag varchar2(1)
806: ,Full_Time_Status ghr_pa_request_extra_info.rei_information9%type
807: ,Length_of_Service ghr_pa_request_extra_info.rei_information10%type
808: ,Scarce_Specialty ghr_pa_request_extra_info.rei_information3%type
809: ,Specialty_or_Board_Cert ghr_pa_request_extra_info.rei_information4%type
810: ,Geographic_Location ghr_pa_request_extra_info.rei_information5%type
803: --Pradeep.
804: type mddds_special_pay_type is record
805: ( mddds_special_pay_flag varchar2(1)
806: ,Full_Time_Status ghr_pa_request_extra_info.rei_information9%type
807: ,Length_of_Service ghr_pa_request_extra_info.rei_information10%type
808: ,Scarce_Specialty ghr_pa_request_extra_info.rei_information3%type
809: ,Specialty_or_Board_Cert ghr_pa_request_extra_info.rei_information4%type
810: ,Geographic_Location ghr_pa_request_extra_info.rei_information5%type
811: ,Exceptional_Qualifications ghr_pa_request_extra_info.rei_information6%type
804: type mddds_special_pay_type is record
805: ( mddds_special_pay_flag varchar2(1)
806: ,Full_Time_Status ghr_pa_request_extra_info.rei_information9%type
807: ,Length_of_Service ghr_pa_request_extra_info.rei_information10%type
808: ,Scarce_Specialty ghr_pa_request_extra_info.rei_information3%type
809: ,Specialty_or_Board_Cert ghr_pa_request_extra_info.rei_information4%type
810: ,Geographic_Location ghr_pa_request_extra_info.rei_information5%type
811: ,Exceptional_Qualifications ghr_pa_request_extra_info.rei_information6%type
812: ,Executive_Position ghr_pa_request_extra_info.rei_information7%type
805: ( mddds_special_pay_flag varchar2(1)
806: ,Full_Time_Status ghr_pa_request_extra_info.rei_information9%type
807: ,Length_of_Service ghr_pa_request_extra_info.rei_information10%type
808: ,Scarce_Specialty ghr_pa_request_extra_info.rei_information3%type
809: ,Specialty_or_Board_Cert ghr_pa_request_extra_info.rei_information4%type
810: ,Geographic_Location ghr_pa_request_extra_info.rei_information5%type
811: ,Exceptional_Qualifications ghr_pa_request_extra_info.rei_information6%type
812: ,Executive_Position ghr_pa_request_extra_info.rei_information7%type
813: ,Dentist_Post_Graduate_Training ghr_pa_request_extra_info.rei_information8%type
806: ,Full_Time_Status ghr_pa_request_extra_info.rei_information9%type
807: ,Length_of_Service ghr_pa_request_extra_info.rei_information10%type
808: ,Scarce_Specialty ghr_pa_request_extra_info.rei_information3%type
809: ,Specialty_or_Board_Cert ghr_pa_request_extra_info.rei_information4%type
810: ,Geographic_Location ghr_pa_request_extra_info.rei_information5%type
811: ,Exceptional_Qualifications ghr_pa_request_extra_info.rei_information6%type
812: ,Executive_Position ghr_pa_request_extra_info.rei_information7%type
813: ,Dentist_Post_Graduate_Training ghr_pa_request_extra_info.rei_information8%type
814: ,Amount ghr_pa_request_extra_info.rei_information11%type
807: ,Length_of_Service ghr_pa_request_extra_info.rei_information10%type
808: ,Scarce_Specialty ghr_pa_request_extra_info.rei_information3%type
809: ,Specialty_or_Board_Cert ghr_pa_request_extra_info.rei_information4%type
810: ,Geographic_Location ghr_pa_request_extra_info.rei_information5%type
811: ,Exceptional_Qualifications ghr_pa_request_extra_info.rei_information6%type
812: ,Executive_Position ghr_pa_request_extra_info.rei_information7%type
813: ,Dentist_Post_Graduate_Training ghr_pa_request_extra_info.rei_information8%type
814: ,Amount ghr_pa_request_extra_info.rei_information11%type
815: ,mddds_special_pay_date ghr_pa_request_extra_info.rei_information12%type
808: ,Scarce_Specialty ghr_pa_request_extra_info.rei_information3%type
809: ,Specialty_or_Board_Cert ghr_pa_request_extra_info.rei_information4%type
810: ,Geographic_Location ghr_pa_request_extra_info.rei_information5%type
811: ,Exceptional_Qualifications ghr_pa_request_extra_info.rei_information6%type
812: ,Executive_Position ghr_pa_request_extra_info.rei_information7%type
813: ,Dentist_Post_Graduate_Training ghr_pa_request_extra_info.rei_information8%type
814: ,Amount ghr_pa_request_extra_info.rei_information11%type
815: ,mddds_special_pay_date ghr_pa_request_extra_info.rei_information12%type
816: ,premium_pay_ind ghr_pa_request_extra_info.rei_information13%type
809: ,Specialty_or_Board_Cert ghr_pa_request_extra_info.rei_information4%type
810: ,Geographic_Location ghr_pa_request_extra_info.rei_information5%type
811: ,Exceptional_Qualifications ghr_pa_request_extra_info.rei_information6%type
812: ,Executive_Position ghr_pa_request_extra_info.rei_information7%type
813: ,Dentist_Post_Graduate_Training ghr_pa_request_extra_info.rei_information8%type
814: ,Amount ghr_pa_request_extra_info.rei_information11%type
815: ,mddds_special_pay_date ghr_pa_request_extra_info.rei_information12%type
816: ,premium_pay_ind ghr_pa_request_extra_info.rei_information13%type
817: );
810: ,Geographic_Location ghr_pa_request_extra_info.rei_information5%type
811: ,Exceptional_Qualifications ghr_pa_request_extra_info.rei_information6%type
812: ,Executive_Position ghr_pa_request_extra_info.rei_information7%type
813: ,Dentist_Post_Graduate_Training ghr_pa_request_extra_info.rei_information8%type
814: ,Amount ghr_pa_request_extra_info.rei_information11%type
815: ,mddds_special_pay_date ghr_pa_request_extra_info.rei_information12%type
816: ,premium_pay_ind ghr_pa_request_extra_info.rei_information13%type
817: );
818: --
811: ,Exceptional_Qualifications ghr_pa_request_extra_info.rei_information6%type
812: ,Executive_Position ghr_pa_request_extra_info.rei_information7%type
813: ,Dentist_Post_Graduate_Training ghr_pa_request_extra_info.rei_information8%type
814: ,Amount ghr_pa_request_extra_info.rei_information11%type
815: ,mddds_special_pay_date ghr_pa_request_extra_info.rei_information12%type
816: ,premium_pay_ind ghr_pa_request_extra_info.rei_information13%type
817: );
818: --
819: --Bug#3585473
812: ,Executive_Position ghr_pa_request_extra_info.rei_information7%type
813: ,Dentist_Post_Graduate_Training ghr_pa_request_extra_info.rei_information8%type
814: ,Amount ghr_pa_request_extra_info.rei_information11%type
815: ,mddds_special_pay_date ghr_pa_request_extra_info.rei_information12%type
816: ,premium_pay_ind ghr_pa_request_extra_info.rei_information13%type
817: );
818: --
819: --Bug#3585473
820: type premium_pay_ind_type is record
819: --Bug#3585473
820: type premium_pay_ind_type is record
821: (
822: premium_pay_ind_flag varchar2(1)
823: ,premium_pay_ind ghr_pa_request_extra_info.rei_information3%type
824: );
825:
826: -- Student Loan Repayment changes bug 3494728
827: type student_loan_repay_type is record
826: -- Student Loan Repayment changes bug 3494728
827: type student_loan_repay_type is record
828: (p_student_loan_flag varchar2(1)
829: ,p_repay_schedule varchar2(2)
830: ,p_amount ghr_pa_request_extra_info.rei_information1%type
831: ,p_review_date ghr_pa_request_extra_info.rei_information2%type);
832:
833: -- Student Loan Repayment changes
834:
827: type student_loan_repay_type is record
828: (p_student_loan_flag varchar2(1)
829: ,p_repay_schedule varchar2(2)
830: ,p_amount ghr_pa_request_extra_info.rei_information1%type
831: ,p_review_date ghr_pa_request_extra_info.rei_information2%type);
832:
833: -- Student Loan Repayment changes
834:
835: -- Bug 4724337 Race or National Origin changes