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 2253: FROM per_assignment_extra_info paei

2249: ,SUM(fnd_number.canonical_to_number(paei.AEI_INFORMATION28)) PrLnWwAwf
2250: ,SUM(fnd_number.canonical_to_number(paei.AEI_INFORMATION29)) PrLnUfo
2251: ,SUM(fnd_number.canonical_to_number(paei.AEI_INFORMATION30)) PrLnPrSectFnds
2252: --10100628
2253: FROM per_assignment_extra_info paei
2254: WHERE
2255: paei.aei_information_category = 'NL_WR_PREV_CORR'
2256: AND p_date BETWEEN fnd_date.canonical_to_date(paei.aei_information1)
2257: AND nvl(fnd_date.canonical_to_date(paei.aei_information2),to_date('31-12-4712','dd-mm-yyyy'))

Line 4695: FROM per_assignment_extra_info paei

4691: IS
4692: SELECT
4693: SUM(fnd_number.canonical_to_number(paei.AEI_INFORMATION17)) PrWgf
4694: ,SUM(fnd_number.canonical_to_number(paei.AEI_INFORMATION30)) PrLnPrSectFnds
4695: FROM per_assignment_extra_info paei
4696: WHERE
4697: paei.aei_information_category = 'NL_WR_PREV_CORR'
4698: AND p_date BETWEEN fnd_date.canonical_to_date(paei.aei_information1)
4699: AND nvl(fnd_date.canonical_to_date(paei.aei_information2),to_date('31-12-4712','dd-mm-yyyy'))

Line 7423: FROM per_assignment_extra_info

7419: AND EXISTS
7420: --10100628
7421: (
7422: SELECT 1
7423: FROM per_assignment_extra_info
7424: WHERE assignment_id = asl.assignment_id
7425: AND aei_information_category = 'NL_WR_PREV_CORR'
7426: AND ptp.start_date BETWEEN fnd_date.canonical_to_date(aei_information1)
7427: AND nvl(fnd_date.canonical_to_date(aei_information2),to_date('31-12-4712','dd-mm-yyyy'))

Line 8141: ,per_assignment_extra_info aei

8137: ,hoi.org_information6 risk_group
8138: ,fnd_date.canonical_to_date(aei.AEI_INFORMATION1) start_date
8139: ,fnd_date.canonical_to_date(aei.AEI_INFORMATION2) end_date
8140: FROM hr_organization_information hoi
8141: ,per_assignment_extra_info aei
8142: WHERE hoi.organization_id = nvl( aei.aei_information8,HR_NL_ORG_INFO.Get_SI_Provider_Info(aei.assignment_id,aei.AEI_INFORMATION3))
8143: AND aei.assignment_id = c_assignment_id
8144: AND aei.information_type = 'NL_SII'
8145: AND aei.aei_information3 IN ('WW','AMI','ZW','WAO')

Line 8155: FROM per_assignment_extra_info

8151: ,org_information5 sector
8152: ,org_information6 risk_group
8153: FROM hr_organization_information
8154: WHERE organization_id IN (SELECT HR_NL_ORG_INFO.Get_SI_Provider_Info(assignment_id,AEI_INFORMATION3)
8155: FROM per_assignment_extra_info
8156: WHERE assignment_id = c_assignment_id
8157: AND information_type = 'NL_SII'
8158: AND aei_information3 IN ('WW','AMI'))
8159: AND org_information5 IS NOT NULL

Line 8535: FROM per_assignment_extra_info

8531: ,fnd_number.canonical_to_number(AEI_INFORMATION28) PrLnWwAwf
8532: ,fnd_number.canonical_to_number(AEI_INFORMATION29) PrLnUfo
8533: ,fnd_number.canonical_to_number(AEI_INFORMATION30) PrLnPrSectFnds
8534: --10100628
8535: FROM per_assignment_extra_info
8536: WHERE assignment_id = p_asg_id
8537: AND aei_information_category = 'NL_WR_PREV_CORR'
8538: AND p_date BETWEEN fnd_date.canonical_to_date(aei_information1)
8539: AND nvl(fnd_date.canonical_to_date(aei_information2),to_date('31-12-4712','dd-mm-yyyy'))

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

8974: ,p_surrogate_key IN NUMBER
8975: ,p_eff_date IN DATE
8976: ,p_start_date IN DATE
8977: ,p_end_date IN DATE
8978: ,p_labour_rel_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8979: ,p_ins_duty_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8980: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8981: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8982: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

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

8975: ,p_eff_date IN DATE
8976: ,p_start_date IN DATE
8977: ,p_end_date IN DATE
8978: ,p_labour_rel_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8979: ,p_ins_duty_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8980: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8981: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8982: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8983: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

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

8976: ,p_start_date IN DATE
8977: ,p_end_date IN DATE
8978: ,p_labour_rel_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8979: ,p_ins_duty_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8980: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8981: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8982: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8983: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8984: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

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

8977: ,p_end_date IN DATE
8978: ,p_labour_rel_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8979: ,p_ins_duty_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8980: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8981: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8982: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8983: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8984: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8985: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

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

8978: ,p_labour_rel_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8979: ,p_ins_duty_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8980: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8981: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8982: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8983: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8984: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8985: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8986: /*LC 2010*/ ,p_marginal_empl IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

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

8979: ,p_ins_duty_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8980: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8981: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8982: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8983: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8984: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8985: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8986: /*LC 2010*/ ,p_marginal_empl IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8987: /*LC 2010*/ ,p_wm_old_rule IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

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

8980: ,p_FZ_Code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8981: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8982: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8983: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8984: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8985: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8986: /*LC 2010*/ ,p_marginal_empl IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8987: /*LC 2010*/ ,p_wm_old_rule IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8988: /*LC 2013*/ ,p_temp_tax_discount IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

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

8981: ,p_handicapped_code IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8982: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8983: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8984: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8985: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8986: /*LC 2010*/ ,p_marginal_empl IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8987: /*LC 2010*/ ,p_wm_old_rule IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8988: /*LC 2013*/ ,p_temp_tax_discount IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8989: ,p_chk IN OUT NOCOPY VARCHAR2) IS

Line 8986: /LC 2010/ ,p_marginal_empl IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

8982: ,p_wao_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8983: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8984: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8985: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8986: /*LC 2010*/ ,p_marginal_empl IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8987: /*LC 2010*/ ,p_wm_old_rule IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8988: /*LC 2013*/ ,p_temp_tax_discount IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8989: ,p_chk IN OUT NOCOPY VARCHAR2) IS
8990: --

Line 8987: /LC 2010/ ,p_wm_old_rule IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

8983: ,p_ww_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8984: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8985: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8986: /*LC 2010*/ ,p_marginal_empl IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8987: /*LC 2010*/ ,p_wm_old_rule IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8988: /*LC 2013*/ ,p_temp_tax_discount IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8989: ,p_chk IN OUT NOCOPY VARCHAR2) IS
8990: --
8991: CURSOR csr_get_ass_extra_info(c_a_extra_info_id NUMBER) IS

Line 8988: /LC 2013/ ,p_temp_tax_discount IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type

8984: ,p_zw_insured IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8985: ,p_zvw_situation IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8986: /*LC 2010*/ ,p_marginal_empl IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8987: /*LC 2010*/ ,p_wm_old_rule IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8988: /*LC 2013*/ ,p_temp_tax_discount IN OUT NOCOPY PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type
8989: ,p_chk IN OUT NOCOPY VARCHAR2) IS
8990: --
8991: CURSOR csr_get_ass_extra_info(c_a_extra_info_id NUMBER) IS
8992: SELECT fnd_date.canonical_to_date(aei_information1) start_date

Line 8997: FROM per_assignment_extra_info

8993: ,fnd_date.canonical_to_date(aei_information2) end_date
8994: ,aei_information3 info1
8995: ,aei_information15 info2
8996: ,aei_information_category
8997: FROM per_assignment_extra_info
8998: WHERE assignment_extra_info_id = c_a_extra_info_id
8999: AND aei_information_category IN ('NL_LBR','NL_INF','NL_TML','NL_LHI','NL_SII',
9000: 'NL_MEI','NL_WMR','NL_TTD'); /*LC 2010 and LC 2013*/
9001: --

Line 9008: FROM per_assignment_extra_info

9004: ,fnd_date.canonical_to_date(aei_information2) end_date
9005: ,aei_information3 info1
9006: ,aei_information15 info2
9007: ,aei_information_category
9008: FROM per_assignment_extra_info
9009: WHERE assignment_id = c_assignment_id
9010: AND aei_information_category IN ('NL_LBR','NL_INF','NL_TML','NL_LHI','NL_SII',
9011: 'NL_MEI','NL_WMR','NL_TTD') /*LC 2010 and LC 2013*/
9012: --9257875

Line 9026: FROM per_assignment_extra_info

9022: --
9023: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - START
9024: CURSOR csr_all_ass_extra_info_code6_9(c_assignment_id NUMBER) IS
9025: SELECT aei_information3 info1
9026: FROM per_assignment_extra_info
9027: WHERE assignment_id = c_assignment_id
9028: AND aei_information_category = 'NL_LHI'
9029: AND p_end_date BETWEEN fnd_date.canonical_to_date(aei_information1)
9030: AND nvl(fnd_date.canonical_to_date(aei_information2),to_date('31-12-4712','dd-mm-yyyy'))

Line 9045: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9041: AND p_end_date between papf.effective_start_date and papf.effective_end_date
9042: AND papf.date_of_birth is not null;
9043: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - End
9044: --
9045: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9046: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9047: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9048: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9049: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9046: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9042: AND papf.date_of_birth is not null;
9043: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - End
9044: --
9045: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9046: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9047: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9048: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9049: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9050: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9047: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9043: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - End
9044: --
9045: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9046: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9047: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9048: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9049: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9050: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9051: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9048: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9044: --
9045: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9046: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9047: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9048: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9049: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9050: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9051: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9052: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9049: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9045: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9046: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9047: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9048: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9049: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9050: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9051: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9052: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9053: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9050: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9046: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9047: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9048: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9049: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9050: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9051: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9052: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9053: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9054: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9051: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9047: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9048: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9049: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9050: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9051: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9052: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9053: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9054: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9055: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9052: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9048: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9049: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9050: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9051: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9052: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9053: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9054: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9055: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9056: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9053: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9049: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9050: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9051: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9052: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9053: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9054: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9055: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9056: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9057: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9054: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9050: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9051: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9052: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9053: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9054: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9055: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9056: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9057: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9058: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9055: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9051: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9052: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9053: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9054: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9055: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9056: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9057: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9058: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9059: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9056: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9052: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9053: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9054: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9055: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9056: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9057: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9058: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9059: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9060: l_zvw_situation1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9057: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9053: l_labour_rel_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9054: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9055: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9056: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9057: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9058: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9059: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9060: l_zvw_situation1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9061: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - START

Line 9058: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9054: l_ins_duty_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9055: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9056: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9057: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9058: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9059: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9060: l_zvw_situation1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9061: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - START
9062: l_handicapped_code_new PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9059: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9055: l_FZ_Code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9056: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9057: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9058: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9059: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9060: l_zvw_situation1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9061: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - START
9062: l_handicapped_code_new PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9063: l_bdate date;

Line 9060: l_zvw_situation1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9056: l_handicapped_code1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9057: l_wao_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9058: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9059: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9060: l_zvw_situation1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9061: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - START
9062: l_handicapped_code_new PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9063: l_bdate date;
9064: l_age number;

Line 9062: l_handicapped_code_new PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9058: l_ww_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9059: l_zw_insured1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9060: l_zvw_situation1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9061: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - START
9062: l_handicapped_code_new PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9063: l_bdate date;
9064: l_age number;
9065: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - END
9066: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 9066: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9062: l_handicapped_code_new PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9063: l_bdate date;
9064: l_age number;
9065: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - END
9066: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9067: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9068: l_marginal_empl1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9069: l_wm_old_rule1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9070:

Line 9067: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9063: l_bdate date;
9064: l_age number;
9065: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - END
9066: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9067: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9068: l_marginal_empl1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9069: l_wm_old_rule1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9070:
9071: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type; /*LC 2013*/

Line 9068: l_marginal_empl1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9064: l_age number;
9065: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - END
9066: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9067: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9068: l_marginal_empl1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9069: l_wm_old_rule1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9070:
9071: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type; /*LC 2013*/
9072:

Line 9069: l_wm_old_rule1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

9065: --rsahai--Labour Handicapped discount - New Code 7 Changes : 2009 changes - END
9066: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9067: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9068: l_marginal_empl1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9069: l_wm_old_rule1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9070:
9071: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type; /*LC 2013*/
9072:
9073: --

Line 9071: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type; /LC 2013/

9067: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9068: l_marginal_empl1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9069: l_wm_old_rule1 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
9070:
9071: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type; /*LC 2013*/
9072:
9073: --
9074: BEGIN
9075: --

Line 9364: FROM per_assignment_extra_info

9360: WHERE TABLE_NAME = c_table_name;
9361: --
9362: CURSOR csr_get_eit_effective_date(c_a_extra_info_id NUMBER) IS
9363: SELECT fnd_date.canonical_to_date(aei_information1) start_date
9364: FROM per_assignment_extra_info
9365: WHERE assignment_extra_info_id = c_a_extra_info_id
9366: AND aei_information_category IN ('NL_LBR','NL_INF','NL_TML','NL_LHI','NL_SII'--);
9367: ,'NL_MEI','NL_WMR'); /*LC 2010*/
9368: --

Line 9391: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');

9387: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');
9388: FETCH csr_get_table_id INTO l_table2;
9389: CLOSE csr_get_table_id;
9390: --
9391: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');
9392: FETCH csr_get_table_id INTO l_table3;
9393: CLOSE csr_get_table_id;
9394: --
9395: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRIES_F : '||l_table1);

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

9393: CLOSE csr_get_table_id;
9394: --
9395: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRIES_F : '||l_table1);
9396: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRY_VALUES_F : '||l_table1);
9397: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PER_ASSIGNMENT_EXTRA_INFO : '||l_table1);
9398: l_cnt := 1;
9399: FOR c_rec IN csr_get_element_entries(p_assignment_id,p_end_date) LOOP
9400: --##--Fnd_file.put_line(FND_FILE.LOG,'####### Calling interpretor for element_entry_id : '||c_rec.element_entry_id);
9401: BEGIN

Line 9918: FROM per_assignment_extra_info

9914: AND peef.effective_end_date; /*assuming one input value*/
9915: --
9916: CURSOR csr_get_eit_cao(c_assignment_id NUMBER) IS
9917: SELECT aei_information5
9918: FROM per_assignment_extra_info
9919: WHERE assignment_id = c_assignment_id
9920: AND aei_information_category IN ('NL_CADANS_INFO');
9921: --
9922: CURSOR csr_ass_start_date(c_assignment_id NUMBER) IS

Line 9950: from per_assignment_extra_info

9946:
9947: /* 8328995 */
9948: cursor csr_numiv_override(p_asg_id number) is
9949: select aei_information1 NUMIV_OVERRIDE
9950: from per_assignment_extra_info
9951: where assignment_id = p_asg_id
9952: and aei_information_category = 'NL_NUMIV_OVERRIDE';
9953: l_numiv_override NUMBER;
9954:

Line 10038: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

10034: l_wage_wajong hr_soft_coding_keyflex.segment1%type;
10035: l_emp_loan hr_soft_coding_keyflex.segment1%type;
10036: l_transportation hr_soft_coding_keyflex.segment1%type;
10037: --
10038: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10039: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10040: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10041: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10042: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 10039: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

10035: l_emp_loan hr_soft_coding_keyflex.segment1%type;
10036: l_transportation hr_soft_coding_keyflex.segment1%type;
10037: --
10038: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10039: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10040: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10041: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10042: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10043: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 10040: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

10036: l_transportation hr_soft_coding_keyflex.segment1%type;
10037: --
10038: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10039: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10040: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10041: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10042: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10043: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10044: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 10041: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

10037: --
10038: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10039: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10040: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10041: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10042: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10043: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10044: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10045: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 10042: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

10038: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10039: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10040: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10041: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10042: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10043: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10044: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10045: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10046: l_zvw_defaulted VARCHAR2(1);

Line 10043: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

10039: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10040: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10041: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10042: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10043: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10044: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10045: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10046: l_zvw_defaulted VARCHAR2(1);
10047: l_zvw_small_jobs VARCHAR2(1);/* LC 2010*/

Line 10044: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

10040: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10041: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10042: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10043: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10044: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10045: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10046: l_zvw_defaulted VARCHAR2(1);
10047: l_zvw_small_jobs VARCHAR2(1);/* LC 2010*/
10048: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/

Line 10045: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

10041: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10042: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10043: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10044: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10045: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10046: l_zvw_defaulted VARCHAR2(1);
10047: l_zvw_small_jobs VARCHAR2(1);/* LC 2010*/
10048: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
10049: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/

Line 10048: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/

10044: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10045: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10046: l_zvw_defaulted VARCHAR2(1);
10047: l_zvw_small_jobs VARCHAR2(1);/* LC 2010*/
10048: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
10049: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
10050: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2013*/
10051: --
10052: l_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/

Line 10049: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/

10045: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
10046: l_zvw_defaulted VARCHAR2(1);
10047: l_zvw_small_jobs VARCHAR2(1);/* LC 2010*/
10048: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
10049: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
10050: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2013*/
10051: --
10052: l_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
10053: l_assg_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/

Line 10050: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2013*/

10046: l_zvw_defaulted VARCHAR2(1);
10047: l_zvw_small_jobs VARCHAR2(1);/* LC 2010*/
10048: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
10049: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
10050: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2013*/
10051: --
10052: l_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
10053: l_assg_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
10054: --

Line 10147: FROM per_assignment_extra_info

10143: AND paa.source_action_id IS NOT NULL
10144: AND EXISTS
10145: (
10146: SELECT 1
10147: FROM per_assignment_extra_info
10148: WHERE assignment_id = paa.assignment_id
10149: AND aei_information_category = 'NL_WR_PREV_CORR'
10150: AND ptp.start_date BETWEEN fnd_date.canonical_to_date(aei_information1)
10151: AND nvl(fnd_date.canonical_to_date(aei_information2),to_date('31-12-4712','dd-mm-yyyy'))

Line 10208: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');

10204: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');
10205: FETCH csr_get_table_id INTO l_table2;
10206: CLOSE csr_get_table_id;
10207: --
10208: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');
10209: FETCH csr_get_table_id INTO l_table3;
10210: CLOSE csr_get_table_id;
10211: --
10212: OPEN csr_get_emp_data(l_assignment_id,LEAST(p_chk_end_date,NVL(l_ass_end_date,p_chk_end_date)));

Line 14126: FROM per_assignment_extra_info

14122: AND peef.effective_end_date; /*assuming one input value*/
14123: --
14124: CURSOR csr_get_eit_cao(c_assignment_id NUMBER) IS
14125: SELECT aei_information5
14126: FROM per_assignment_extra_info
14127: WHERE assignment_id = c_assignment_id
14128: AND aei_information_category IN ('NL_CADANS_INFO');
14129: --
14130: CURSOR csr_ass_start_date(c_assignment_id NUMBER) IS

Line 14207: from per_assignment_extra_info

14203: -- /*LC 2010 */ end
14204: /* 8328995 */
14205: cursor csr_numiv_override(p_asg_id number) is
14206: select aei_information1 NUMIV_OVERRIDE
14207: from per_assignment_extra_info
14208: where assignment_id = p_asg_id
14209: and aei_information_category = 'NL_NUMIV_OVERRIDE';
14210: l_numiv_override NUMBER;
14211:

Line 14235: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

14231: l_wage_wajong hr_soft_coding_keyflex.segment1%type;
14232: l_emp_loan hr_soft_coding_keyflex.segment1%type;
14233: l_transportation hr_soft_coding_keyflex.segment1%type;
14234: --
14235: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14236: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14237: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14238: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14239: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 14236: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

14232: l_emp_loan hr_soft_coding_keyflex.segment1%type;
14233: l_transportation hr_soft_coding_keyflex.segment1%type;
14234: --
14235: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14236: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14237: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14238: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14239: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14240: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 14237: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

14233: l_transportation hr_soft_coding_keyflex.segment1%type;
14234: --
14235: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14236: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14237: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14238: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14239: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14240: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14241: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 14238: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

14234: --
14235: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14236: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14237: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14238: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14239: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14240: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14241: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14242: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 14239: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

14235: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14236: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14237: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14238: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14239: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14240: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14241: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14242: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14243: l_zvw_defaulted VARCHAR2(1);

Line 14240: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

14236: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14237: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14238: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14239: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14240: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14241: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14242: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14243: l_zvw_defaulted VARCHAR2(1);
14244: l_zvw_small_jobs VARCHAR2(1);/* LC 2010*/

Line 14241: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

14237: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14238: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14239: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14240: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14241: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14242: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14243: l_zvw_defaulted VARCHAR2(1);
14244: l_zvw_small_jobs VARCHAR2(1);/* LC 2010*/
14245: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/

Line 14242: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

14238: l_handicapped_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14239: l_wao_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14240: l_ww_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14241: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14242: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14243: l_zvw_defaulted VARCHAR2(1);
14244: l_zvw_small_jobs VARCHAR2(1);/* LC 2010*/
14245: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
14246: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/

Line 14245: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/

14241: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14242: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14243: l_zvw_defaulted VARCHAR2(1);
14244: l_zvw_small_jobs VARCHAR2(1);/* LC 2010*/
14245: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
14246: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
14247: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2013*/
14248: --
14249: l_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/

Line 14246: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/

14242: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
14243: l_zvw_defaulted VARCHAR2(1);
14244: l_zvw_small_jobs VARCHAR2(1);/* LC 2010*/
14245: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
14246: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
14247: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2013*/
14248: --
14249: l_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
14250: l_assg_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/

Line 14247: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2013*/

14243: l_zvw_defaulted VARCHAR2(1);
14244: l_zvw_small_jobs VARCHAR2(1);/* LC 2010*/
14245: l_marginal_empl PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
14246: l_wm_old_rule PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2010*/
14247: l_temp_tax_discount PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;/* LC 2013*/
14248: --
14249: l_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
14250: l_assg_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
14251: --

Line 14701: FROM per_assignment_extra_info

14697: AND EXISTS
14698: --10100628
14699: (
14700: SELECT 1
14701: FROM per_assignment_extra_info
14702: WHERE assignment_id = paa.assignment_id
14703: AND aei_information_category = 'NL_WR_PREV_CORR'
14704: AND ptp.start_date BETWEEN fnd_date.canonical_to_date(aei_information1)
14705: AND nvl(fnd_date.canonical_to_date(aei_information2),to_date('31-12-4712','dd-mm-yyyy'))