4655: ,decode(INSTR(NVL(segment10,'00'),'71'),0,'N','J') wage_aow
4656: ,decode(INSTR(NVL(segment10,'00'),'72'),0,'N','J') wage_wajong
4657: ,decode(INSTR(NVL(segment10,'00'),'43'),0,'N','J') emp_loan
4658: ,decode(INSTR(NVL(segment10,'00'),'03'),0,'N','J') transportation
4659: FROM hr_soft_coding_keyflex
4660: WHERE soft_coding_keyflex_id = c_scl_id;
4661: --
4662: l_wage_tax_discount hr_soft_coding_keyflex.segment13%type;
4663: l_work_pattern hr_soft_coding_keyflex.segment13%type;
4658: ,decode(INSTR(NVL(segment10,'00'),'03'),0,'N','J') transportation
4659: FROM hr_soft_coding_keyflex
4660: WHERE soft_coding_keyflex_id = c_scl_id;
4661: --
4662: l_wage_tax_discount hr_soft_coding_keyflex.segment13%type;
4663: l_work_pattern hr_soft_coding_keyflex.segment13%type;
4664: l_income_code hr_soft_coding_keyflex.segment13%type;
4665: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
4666: l_wage_aow hr_soft_coding_keyflex.segment13%type;
4659: FROM hr_soft_coding_keyflex
4660: WHERE soft_coding_keyflex_id = c_scl_id;
4661: --
4662: l_wage_tax_discount hr_soft_coding_keyflex.segment13%type;
4663: l_work_pattern hr_soft_coding_keyflex.segment13%type;
4664: l_income_code hr_soft_coding_keyflex.segment13%type;
4665: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
4666: l_wage_aow hr_soft_coding_keyflex.segment13%type;
4667: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
4660: WHERE soft_coding_keyflex_id = c_scl_id;
4661: --
4662: l_wage_tax_discount hr_soft_coding_keyflex.segment13%type;
4663: l_work_pattern hr_soft_coding_keyflex.segment13%type;
4664: l_income_code hr_soft_coding_keyflex.segment13%type;
4665: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
4666: l_wage_aow hr_soft_coding_keyflex.segment13%type;
4667: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
4668: l_emp_loan hr_soft_coding_keyflex.segment13%type;
4661: --
4662: l_wage_tax_discount hr_soft_coding_keyflex.segment13%type;
4663: l_work_pattern hr_soft_coding_keyflex.segment13%type;
4664: l_income_code hr_soft_coding_keyflex.segment13%type;
4665: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
4666: l_wage_aow hr_soft_coding_keyflex.segment13%type;
4667: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
4668: l_emp_loan hr_soft_coding_keyflex.segment13%type;
4669: l_transportation hr_soft_coding_keyflex.segment13%type;
4662: l_wage_tax_discount hr_soft_coding_keyflex.segment13%type;
4663: l_work_pattern hr_soft_coding_keyflex.segment13%type;
4664: l_income_code hr_soft_coding_keyflex.segment13%type;
4665: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
4666: l_wage_aow hr_soft_coding_keyflex.segment13%type;
4667: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
4668: l_emp_loan hr_soft_coding_keyflex.segment13%type;
4669: l_transportation hr_soft_coding_keyflex.segment13%type;
4670: --
4663: l_work_pattern hr_soft_coding_keyflex.segment13%type;
4664: l_income_code hr_soft_coding_keyflex.segment13%type;
4665: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
4666: l_wage_aow hr_soft_coding_keyflex.segment13%type;
4667: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
4668: l_emp_loan hr_soft_coding_keyflex.segment13%type;
4669: l_transportation hr_soft_coding_keyflex.segment13%type;
4670: --
4671: BEGIN
4664: l_income_code hr_soft_coding_keyflex.segment13%type;
4665: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
4666: l_wage_aow hr_soft_coding_keyflex.segment13%type;
4667: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
4668: l_emp_loan hr_soft_coding_keyflex.segment13%type;
4669: l_transportation hr_soft_coding_keyflex.segment13%type;
4670: --
4671: BEGIN
4672: --
4665: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
4666: l_wage_aow hr_soft_coding_keyflex.segment13%type;
4667: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
4668: l_emp_loan hr_soft_coding_keyflex.segment13%type;
4669: l_transportation hr_soft_coding_keyflex.segment13%type;
4670: --
4671: BEGIN
4672: --
4673: OPEN csr_get_scl_seg(p_scl_id);
6288: l_period_end_date DATE;
6289: l_rec_start_date DATE;
6290: l_emp_end_date DATE;
6291: -- SCL Segment variables
6292: l_income_code hr_soft_coding_keyflex.segment1%type;
6293: l_work_pattern hr_soft_coding_keyflex.segment1%type;
6294: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
6295: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
6296: l_wage_aow hr_soft_coding_keyflex.segment1%type;
6289: l_rec_start_date DATE;
6290: l_emp_end_date DATE;
6291: -- SCL Segment variables
6292: l_income_code hr_soft_coding_keyflex.segment1%type;
6293: l_work_pattern hr_soft_coding_keyflex.segment1%type;
6294: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
6295: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
6296: l_wage_aow hr_soft_coding_keyflex.segment1%type;
6297: l_wage_wajong hr_soft_coding_keyflex.segment1%type;
6290: l_emp_end_date DATE;
6291: -- SCL Segment variables
6292: l_income_code hr_soft_coding_keyflex.segment1%type;
6293: l_work_pattern hr_soft_coding_keyflex.segment1%type;
6294: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
6295: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
6296: l_wage_aow hr_soft_coding_keyflex.segment1%type;
6297: l_wage_wajong hr_soft_coding_keyflex.segment1%type;
6298: l_emp_loan hr_soft_coding_keyflex.segment1%type;
6291: -- SCL Segment variables
6292: l_income_code hr_soft_coding_keyflex.segment1%type;
6293: l_work_pattern hr_soft_coding_keyflex.segment1%type;
6294: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
6295: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
6296: l_wage_aow hr_soft_coding_keyflex.segment1%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;
6292: l_income_code hr_soft_coding_keyflex.segment1%type;
6293: l_work_pattern hr_soft_coding_keyflex.segment1%type;
6294: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
6295: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
6296: l_wage_aow hr_soft_coding_keyflex.segment1%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: --
6293: l_work_pattern hr_soft_coding_keyflex.segment1%type;
6294: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
6295: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
6296: l_wage_aow hr_soft_coding_keyflex.segment1%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;
6294: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
6295: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
6296: l_wage_aow hr_soft_coding_keyflex.segment1%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;
6295: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
6296: l_wage_aow hr_soft_coding_keyflex.segment1%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;
8575: l_period_end_date DATE;
8576: l_rec_start_date DATE;
8577: l_emp_end_date DATE;
8578: -- SCL Segment variables
8579: l_income_code hr_soft_coding_keyflex.segment1%type;
8580: l_work_pattern hr_soft_coding_keyflex.segment1%type;
8581: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
8582: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
8583: l_wage_aow hr_soft_coding_keyflex.segment1%type;
8576: l_rec_start_date DATE;
8577: l_emp_end_date DATE;
8578: -- SCL Segment variables
8579: l_income_code hr_soft_coding_keyflex.segment1%type;
8580: l_work_pattern hr_soft_coding_keyflex.segment1%type;
8581: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
8582: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
8583: l_wage_aow hr_soft_coding_keyflex.segment1%type;
8584: l_wage_wajong hr_soft_coding_keyflex.segment1%type;
8577: l_emp_end_date DATE;
8578: -- SCL Segment variables
8579: l_income_code hr_soft_coding_keyflex.segment1%type;
8580: l_work_pattern hr_soft_coding_keyflex.segment1%type;
8581: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
8582: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
8583: l_wage_aow hr_soft_coding_keyflex.segment1%type;
8584: l_wage_wajong hr_soft_coding_keyflex.segment1%type;
8585: l_emp_loan hr_soft_coding_keyflex.segment1%type;
8578: -- SCL Segment variables
8579: l_income_code hr_soft_coding_keyflex.segment1%type;
8580: l_work_pattern hr_soft_coding_keyflex.segment1%type;
8581: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
8582: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
8583: l_wage_aow hr_soft_coding_keyflex.segment1%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;
8579: l_income_code hr_soft_coding_keyflex.segment1%type;
8580: l_work_pattern hr_soft_coding_keyflex.segment1%type;
8581: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
8582: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
8583: l_wage_aow hr_soft_coding_keyflex.segment1%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: --
8580: l_work_pattern hr_soft_coding_keyflex.segment1%type;
8581: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
8582: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
8583: l_wage_aow hr_soft_coding_keyflex.segment1%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;
8581: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
8582: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
8583: l_wage_aow hr_soft_coding_keyflex.segment1%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;
8582: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
8583: l_wage_aow hr_soft_coding_keyflex.segment1%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;