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.PAY_NL_WAGE_REPORT_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 4988: ,per_assignment_extra_info aei

4984: ,hoi.org_information6 risk_group
4985: ,fnd_date.canonical_to_date(aei.AEI_INFORMATION1) start_date
4986: ,fnd_date.canonical_to_date(aei.AEI_INFORMATION2) end_date
4987: FROM hr_organization_information hoi
4988: ,per_assignment_extra_info aei
4989: WHERE hoi.organization_id = nvl( aei.aei_information8,HR_NL_ORG_INFO.Get_SI_Provider_Info(aei.assignment_id,aei.AEI_INFORMATION3))
4990: AND aei.assignment_id = c_assignment_id
4991: AND aei.information_type = 'NL_SII'
4992: AND aei.aei_information3 IN ('WW','AMI','ZW','WAO')

Line 5002: FROM per_assignment_extra_info

4998: ,org_information5 sector
4999: ,org_information6 risk_group
5000: FROM hr_organization_information
5001: WHERE organization_id IN (SELECT HR_NL_ORG_INFO.Get_SI_Provider_Info(assignment_id,AEI_INFORMATION3)
5002: FROM per_assignment_extra_info
5003: WHERE assignment_id = c_assignment_id
5004: AND information_type = 'NL_SII'
5005: AND aei_information3 IN ('WW','AMI'))
5006: AND org_information5 IS NOT NULL

Line 5440: ,p_labour_rel_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

5436: ,p_surrogate_key IN NUMBER
5437: ,p_eff_date IN DATE
5438: ,p_start_date IN DATE
5439: ,p_end_date IN DATE
5440: ,p_labour_rel_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5441: ,p_ins_duty_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5442: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5443: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5444: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

Line 5441: ,p_ins_duty_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

5437: ,p_eff_date IN DATE
5438: ,p_start_date IN DATE
5439: ,p_end_date IN DATE
5440: ,p_labour_rel_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5441: ,p_ins_duty_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5442: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5443: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5444: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5445: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

Line 5442: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

5438: ,p_start_date IN DATE
5439: ,p_end_date IN DATE
5440: ,p_labour_rel_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5441: ,p_ins_duty_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5442: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5443: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5444: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5445: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5446: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

Line 5443: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

5439: ,p_end_date IN DATE
5440: ,p_labour_rel_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5441: ,p_ins_duty_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5442: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5443: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5444: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5445: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5446: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5447: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

Line 5444: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

5440: ,p_labour_rel_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5441: ,p_ins_duty_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5442: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5443: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5444: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5445: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5446: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5447: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5448: ,p_chk IN OUT NOCOPY VARCHAR2) IS

Line 5445: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

5441: ,p_ins_duty_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5442: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5443: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5444: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5445: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5446: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5447: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5448: ,p_chk IN OUT NOCOPY VARCHAR2) IS
5449: --

Line 5446: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

5442: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5443: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5444: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5445: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5446: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5447: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5448: ,p_chk IN OUT NOCOPY VARCHAR2) IS
5449: --
5450: CURSOR csr_get_ass_extra_info(c_a_extra_info_id NUMBER) IS

Line 5447: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

5443: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5444: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5445: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5446: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5447: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
5448: ,p_chk IN OUT NOCOPY VARCHAR2) IS
5449: --
5450: CURSOR csr_get_ass_extra_info(c_a_extra_info_id NUMBER) IS
5451: SELECT fnd_date.canonical_to_date(aei_information1) start_date

Line 5456: FROM per_assignment_extra_info

5452: ,fnd_date.canonical_to_date(aei_information2) end_date
5453: ,aei_information3 info1
5454: ,aei_information15 info2
5455: ,aei_information_category
5456: FROM per_assignment_extra_info
5457: WHERE assignment_extra_info_id = c_a_extra_info_id
5458: AND aei_information_category IN ('NL_LBR','NL_INF','NL_TML','NL_LHI','NL_SII');
5459: --
5460: CURSOR csr_get_all_ass_extra_info(c_assignment_id NUMBER) IS

Line 5466: FROM per_assignment_extra_info

5462: ,fnd_date.canonical_to_date(aei_information2) end_date
5463: ,aei_information3 info1
5464: ,aei_information15 info2
5465: ,aei_information_category
5466: FROM per_assignment_extra_info
5467: WHERE assignment_id = c_assignment_id
5468: AND aei_information_category IN ('NL_LBR','NL_INF','NL_TML','NL_LHI','NL_SII')
5469: ORDER BY 1 DESC;
5470: --

Line 5471: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5467: WHERE assignment_id = c_assignment_id
5468: AND aei_information_category IN ('NL_LBR','NL_INF','NL_TML','NL_LHI','NL_SII')
5469: ORDER BY 1 DESC;
5470: --
5471: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5472: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5473: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5474: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5475: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 5472: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5468: AND aei_information_category IN ('NL_LBR','NL_INF','NL_TML','NL_LHI','NL_SII')
5469: ORDER BY 1 DESC;
5470: --
5471: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5472: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5473: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5474: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5475: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5476: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 5473: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5469: ORDER BY 1 DESC;
5470: --
5471: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5472: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5473: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5474: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5475: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5476: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5477: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 5474: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5470: --
5471: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5472: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5473: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5474: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5475: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5476: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5477: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5478: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 5475: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5471: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5472: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5473: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5474: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5475: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5476: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5477: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5478: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5479: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 5476: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5472: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5473: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5474: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5475: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5476: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5477: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5478: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5479: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5480: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 5477: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5473: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5474: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5475: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5476: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5477: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5478: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5479: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5480: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5481: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 5478: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5474: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5475: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5476: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5477: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5478: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5479: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5480: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5481: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5482: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 5479: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5475: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5476: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5477: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5478: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5479: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5480: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5481: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5482: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5483: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 5480: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5476: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5477: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5478: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5479: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5480: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5481: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5482: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5483: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5484: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 5481: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5477: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5478: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5479: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5480: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5481: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5482: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5483: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5484: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5485: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 5482: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5478: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5479: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5480: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5481: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5482: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5483: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5484: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5485: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5486: l_zvw_situation1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 5483: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5479: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5480: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5481: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5482: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5483: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5484: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5485: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5486: l_zvw_situation1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5487: --

Line 5484: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5480: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5481: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5482: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5483: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5484: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5485: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5486: l_zvw_situation1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5487: --
5488: BEGIN

Line 5485: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5481: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5482: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5483: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5484: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5485: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5486: l_zvw_situation1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5487: --
5488: BEGIN
5489: --

Line 5486: l_zvw_situation1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

5482: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5483: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5484: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5485: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5486: l_zvw_situation1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
5487: --
5488: BEGIN
5489: --
5490: l_labour_rel_code1 := p_labour_rel_code ;

Line 5699: FROM per_assignment_extra_info

5695: WHERE TABLE_NAME = c_table_name;
5696: --
5697: CURSOR csr_get_eit_effective_date(c_a_extra_info_id NUMBER) IS
5698: SELECT fnd_date.canonical_to_date(aei_information1) start_date
5699: FROM per_assignment_extra_info
5700: WHERE assignment_extra_info_id = c_a_extra_info_id
5701: AND aei_information_category IN ('NL_LBR','NL_INF','NL_TML','NL_LHI','NL_SII');
5702: --
5703: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

Line 5725: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');

5721: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');
5722: FETCH csr_get_table_id INTO l_table2;
5723: CLOSE csr_get_table_id;
5724: --
5725: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');
5726: FETCH csr_get_table_id INTO l_table3;
5727: CLOSE csr_get_table_id;
5728: --
5729: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRIES_F : '||l_table1);

Line 5731: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PER_ASSIGNMENT_EXTRA_INFO : '||l_table1);

5727: CLOSE csr_get_table_id;
5728: --
5729: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRIES_F : '||l_table1);
5730: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRY_VALUES_F : '||l_table1);
5731: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PER_ASSIGNMENT_EXTRA_INFO : '||l_table1);
5732: l_cnt := 1;
5733: FOR c_rec IN csr_get_element_entries(p_assignment_id,p_end_date) LOOP
5734: --##--Fnd_file.put_line(FND_FILE.LOG,'####### Calling interpretor for element_entry_id : '||c_rec.element_entry_id);
5735: BEGIN

Line 6249: FROM per_assignment_extra_info

6245: AND peef.effective_end_date; /*assuming one input value*/
6246: --
6247: CURSOR csr_get_eit_cao(c_assignment_id NUMBER) IS
6248: SELECT aei_information5
6249: FROM per_assignment_extra_info
6250: WHERE assignment_id = c_assignment_id
6251: AND aei_information_category IN ('NL_CADANS_INFO');
6252: --
6253: CURSOR csr_ass_start_date(c_assignment_id NUMBER) IS

Line 6301: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

6297: l_wage_wajong hr_soft_coding_keyflex.segment1%type;
6298: l_emp_loan hr_soft_coding_keyflex.segment1%type;
6299: l_transportation hr_soft_coding_keyflex.segment1%type;
6300: --
6301: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6302: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6303: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6304: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6305: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 6302: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

6298: l_emp_loan hr_soft_coding_keyflex.segment1%type;
6299: l_transportation hr_soft_coding_keyflex.segment1%type;
6300: --
6301: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6302: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6303: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6304: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6305: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6306: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 6303: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

6299: l_transportation hr_soft_coding_keyflex.segment1%type;
6300: --
6301: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6302: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6303: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6304: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6305: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6306: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6307: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 6304: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

6300: --
6301: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6302: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6303: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6304: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6305: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6306: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6307: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6308: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 6305: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

6301: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6302: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6303: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6304: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6305: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6306: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6307: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6308: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6309: l_zvw_defaulted VARCHAR2(1);

Line 6306: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

6302: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6303: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6304: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6305: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6306: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6307: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6308: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6309: l_zvw_defaulted VARCHAR2(1);
6310: --

Line 6307: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

6303: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6304: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6305: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6306: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6307: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6308: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6309: l_zvw_defaulted VARCHAR2(1);
6310: --
6311: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;

Line 6308: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

6304: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6305: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6306: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6307: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6308: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6309: l_zvw_defaulted VARCHAR2(1);
6310: --
6311: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
6312: l_event_group_id pay_event_groups.event_group_id%TYPE;

Line 6426: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');

6422: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');
6423: FETCH csr_get_table_id INTO l_table2;
6424: CLOSE csr_get_table_id;
6425: --
6426: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');
6427: FETCH csr_get_table_id INTO l_table3;
6428: CLOSE csr_get_table_id;
6429: --
6430: OPEN csr_get_emp_data(l_assignment_id,LEAST(p_chk_end_date,NVL(l_ass_end_date,p_chk_end_date)));

Line 8536: FROM per_assignment_extra_info

8532: AND peef.effective_end_date; /*assuming one input value*/
8533: --
8534: CURSOR csr_get_eit_cao(c_assignment_id NUMBER) IS
8535: SELECT aei_information5
8536: FROM per_assignment_extra_info
8537: WHERE assignment_id = c_assignment_id
8538: AND aei_information_category IN ('NL_CADANS_INFO');
8539: --
8540: CURSOR csr_ass_start_date(c_assignment_id NUMBER) IS

Line 8588: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

8584: l_wage_wajong hr_soft_coding_keyflex.segment1%type;
8585: l_emp_loan hr_soft_coding_keyflex.segment1%type;
8586: l_transportation hr_soft_coding_keyflex.segment1%type;
8587: --
8588: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8589: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8590: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8591: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8592: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 8589: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

8585: l_emp_loan hr_soft_coding_keyflex.segment1%type;
8586: l_transportation hr_soft_coding_keyflex.segment1%type;
8587: --
8588: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8589: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8590: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8591: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8592: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8593: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 8590: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

8586: l_transportation hr_soft_coding_keyflex.segment1%type;
8587: --
8588: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8589: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8590: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8591: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8592: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8593: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8594: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 8591: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

8587: --
8588: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8589: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8590: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8591: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8592: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8593: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8594: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8595: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 8592: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

8588: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8589: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8590: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8591: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8592: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8593: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8594: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8595: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8596: l_zvw_defaulted VARCHAR2(1);

Line 8593: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

8589: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8590: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8591: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8592: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8593: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8594: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8595: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8596: l_zvw_defaulted VARCHAR2(1);
8597: --

Line 8594: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

8590: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8591: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8592: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8593: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8594: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8595: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8596: l_zvw_defaulted VARCHAR2(1);
8597: --
8598: l_assignment_id NUMBER;

Line 8595: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

8591: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8592: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8593: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8594: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8595: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
8596: l_zvw_defaulted VARCHAR2(1);
8597: --
8598: l_assignment_id NUMBER;
8599: l_chk VARCHAR2(2);