7682: ,decode(INSTR(NVL(segment10,'00'),'71'),0,'N','J') wage_aow
7683: ,decode(INSTR(NVL(segment10,'00'),'72'),0,'N','J') wage_wajong
7684: ,decode(INSTR(NVL(segment10,'00'),'43'),0,'N','J') emp_loan
7685: ,decode(INSTR(NVL(segment10,'00'),'03'),0,'N','J') transportation
7686: FROM hr_soft_coding_keyflex
7687: WHERE soft_coding_keyflex_id = c_scl_id;
7688: --
7689: l_wage_tax_discount hr_soft_coding_keyflex.segment13%type;
7690: l_work_pattern hr_soft_coding_keyflex.segment13%type;
7685: ,decode(INSTR(NVL(segment10,'00'),'03'),0,'N','J') transportation
7686: FROM hr_soft_coding_keyflex
7687: WHERE soft_coding_keyflex_id = c_scl_id;
7688: --
7689: l_wage_tax_discount hr_soft_coding_keyflex.segment13%type;
7690: l_work_pattern hr_soft_coding_keyflex.segment13%type;
7691: l_income_code hr_soft_coding_keyflex.segment13%type;
7692: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
7693: l_wage_aow hr_soft_coding_keyflex.segment13%type;
7686: FROM hr_soft_coding_keyflex
7687: WHERE soft_coding_keyflex_id = c_scl_id;
7688: --
7689: l_wage_tax_discount hr_soft_coding_keyflex.segment13%type;
7690: l_work_pattern hr_soft_coding_keyflex.segment13%type;
7691: l_income_code hr_soft_coding_keyflex.segment13%type;
7692: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
7693: l_wage_aow hr_soft_coding_keyflex.segment13%type;
7694: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
7687: WHERE soft_coding_keyflex_id = c_scl_id;
7688: --
7689: l_wage_tax_discount hr_soft_coding_keyflex.segment13%type;
7690: l_work_pattern hr_soft_coding_keyflex.segment13%type;
7691: l_income_code hr_soft_coding_keyflex.segment13%type;
7692: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
7693: l_wage_aow hr_soft_coding_keyflex.segment13%type;
7694: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
7695: l_emp_loan hr_soft_coding_keyflex.segment13%type;
7688: --
7689: l_wage_tax_discount hr_soft_coding_keyflex.segment13%type;
7690: l_work_pattern hr_soft_coding_keyflex.segment13%type;
7691: l_income_code hr_soft_coding_keyflex.segment13%type;
7692: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
7693: l_wage_aow hr_soft_coding_keyflex.segment13%type;
7694: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
7695: l_emp_loan hr_soft_coding_keyflex.segment13%type;
7696: l_transportation hr_soft_coding_keyflex.segment13%type;
7689: l_wage_tax_discount hr_soft_coding_keyflex.segment13%type;
7690: l_work_pattern hr_soft_coding_keyflex.segment13%type;
7691: l_income_code hr_soft_coding_keyflex.segment13%type;
7692: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
7693: l_wage_aow hr_soft_coding_keyflex.segment13%type;
7694: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
7695: l_emp_loan hr_soft_coding_keyflex.segment13%type;
7696: l_transportation hr_soft_coding_keyflex.segment13%type;
7697: --
7690: l_work_pattern hr_soft_coding_keyflex.segment13%type;
7691: l_income_code hr_soft_coding_keyflex.segment13%type;
7692: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
7693: l_wage_aow hr_soft_coding_keyflex.segment13%type;
7694: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
7695: l_emp_loan hr_soft_coding_keyflex.segment13%type;
7696: l_transportation hr_soft_coding_keyflex.segment13%type;
7697: --
7698: BEGIN
7691: l_income_code hr_soft_coding_keyflex.segment13%type;
7692: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
7693: l_wage_aow hr_soft_coding_keyflex.segment13%type;
7694: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
7695: l_emp_loan hr_soft_coding_keyflex.segment13%type;
7696: l_transportation hr_soft_coding_keyflex.segment13%type;
7697: --
7698: BEGIN
7699: --
7692: l_wage_tax_table hr_soft_coding_keyflex.segment13%type;
7693: l_wage_aow hr_soft_coding_keyflex.segment13%type;
7694: l_wage_wajong hr_soft_coding_keyflex.segment13%type;
7695: l_emp_loan hr_soft_coding_keyflex.segment13%type;
7696: l_transportation hr_soft_coding_keyflex.segment13%type;
7697: --
7698: BEGIN
7699: --
7700: OPEN csr_get_scl_seg(p_scl_id);
10025: l_period_end_date DATE;
10026: l_rec_start_date DATE;
10027: l_emp_end_date DATE;
10028: -- SCL Segment variables
10029: l_income_code hr_soft_coding_keyflex.segment1%type;
10030: l_work_pattern hr_soft_coding_keyflex.segment1%type;
10031: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
10032: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
10033: l_wage_aow hr_soft_coding_keyflex.segment1%type;
10026: l_rec_start_date DATE;
10027: l_emp_end_date DATE;
10028: -- SCL Segment variables
10029: l_income_code hr_soft_coding_keyflex.segment1%type;
10030: l_work_pattern hr_soft_coding_keyflex.segment1%type;
10031: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
10032: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
10033: l_wage_aow hr_soft_coding_keyflex.segment1%type;
10034: l_wage_wajong hr_soft_coding_keyflex.segment1%type;
10027: l_emp_end_date DATE;
10028: -- SCL Segment variables
10029: l_income_code hr_soft_coding_keyflex.segment1%type;
10030: l_work_pattern hr_soft_coding_keyflex.segment1%type;
10031: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
10032: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
10033: l_wage_aow hr_soft_coding_keyflex.segment1%type;
10034: l_wage_wajong hr_soft_coding_keyflex.segment1%type;
10035: l_emp_loan hr_soft_coding_keyflex.segment1%type;
10028: -- SCL Segment variables
10029: l_income_code hr_soft_coding_keyflex.segment1%type;
10030: l_work_pattern hr_soft_coding_keyflex.segment1%type;
10031: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
10032: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
10033: l_wage_aow hr_soft_coding_keyflex.segment1%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;
10029: l_income_code hr_soft_coding_keyflex.segment1%type;
10030: l_work_pattern hr_soft_coding_keyflex.segment1%type;
10031: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
10032: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
10033: l_wage_aow hr_soft_coding_keyflex.segment1%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: --
10030: l_work_pattern hr_soft_coding_keyflex.segment1%type;
10031: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
10032: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
10033: l_wage_aow hr_soft_coding_keyflex.segment1%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;
10031: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
10032: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
10033: l_wage_aow hr_soft_coding_keyflex.segment1%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;
10032: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
10033: l_wage_aow hr_soft_coding_keyflex.segment1%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;
14222: l_period_end_date DATE;
14223: l_rec_start_date DATE;
14224: l_emp_end_date DATE;
14225: -- SCL Segment variables
14226: l_income_code hr_soft_coding_keyflex.segment1%type;
14227: l_work_pattern hr_soft_coding_keyflex.segment1%type;
14228: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
14229: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
14230: l_wage_aow hr_soft_coding_keyflex.segment1%type;
14223: l_rec_start_date DATE;
14224: l_emp_end_date DATE;
14225: -- SCL Segment variables
14226: l_income_code hr_soft_coding_keyflex.segment1%type;
14227: l_work_pattern hr_soft_coding_keyflex.segment1%type;
14228: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
14229: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
14230: l_wage_aow hr_soft_coding_keyflex.segment1%type;
14231: l_wage_wajong hr_soft_coding_keyflex.segment1%type;
14224: l_emp_end_date DATE;
14225: -- SCL Segment variables
14226: l_income_code hr_soft_coding_keyflex.segment1%type;
14227: l_work_pattern hr_soft_coding_keyflex.segment1%type;
14228: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
14229: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
14230: l_wage_aow hr_soft_coding_keyflex.segment1%type;
14231: l_wage_wajong hr_soft_coding_keyflex.segment1%type;
14232: l_emp_loan hr_soft_coding_keyflex.segment1%type;
14225: -- SCL Segment variables
14226: l_income_code hr_soft_coding_keyflex.segment1%type;
14227: l_work_pattern hr_soft_coding_keyflex.segment1%type;
14228: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
14229: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
14230: l_wage_aow hr_soft_coding_keyflex.segment1%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;
14226: l_income_code hr_soft_coding_keyflex.segment1%type;
14227: l_work_pattern hr_soft_coding_keyflex.segment1%type;
14228: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
14229: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
14230: l_wage_aow hr_soft_coding_keyflex.segment1%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: --
14227: l_work_pattern hr_soft_coding_keyflex.segment1%type;
14228: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
14229: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
14230: l_wage_aow hr_soft_coding_keyflex.segment1%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;
14228: l_wage_tax_discount hr_soft_coding_keyflex.segment1%type;
14229: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
14230: l_wage_aow hr_soft_coding_keyflex.segment1%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;
14229: l_wage_tax_table hr_soft_coding_keyflex.segment1%type;
14230: l_wage_aow hr_soft_coding_keyflex.segment1%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;