DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 7686: FROM hr_soft_coding_keyflex

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;

Line 7689: l_wage_tax_discount 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;

Line 7690: l_work_pattern 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;

Line 7691: l_income_code 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;

Line 7692: l_wage_tax_table 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;

Line 7693: l_wage_aow 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: --

Line 7694: l_wage_wajong 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: --
7698: BEGIN

Line 7695: l_emp_loan 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
7699: --

Line 7696: l_transportation 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: --
7700: OPEN csr_get_scl_seg(p_scl_id);

Line 10029: l_income_code hr_soft_coding_keyflex.segment1%type;

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;

Line 10030: l_work_pattern 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;

Line 10031: l_wage_tax_discount 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;

Line 10032: l_wage_tax_table 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;

Line 10033: l_wage_aow 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: --

Line 10034: l_wage_wajong 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: --
10038: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 10035: l_emp_loan 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;
10039: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 10036: l_transportation 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;
10040: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 14226: l_income_code hr_soft_coding_keyflex.segment1%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;

Line 14227: l_work_pattern 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;

Line 14228: l_wage_tax_discount 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;

Line 14229: l_wage_tax_table 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;

Line 14230: l_wage_aow 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: --

Line 14231: l_wage_wajong 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: --
14235: l_labour_rel_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 14232: l_emp_loan 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;
14236: l_ins_duty_code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;

Line 14233: l_transportation 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;
14237: l_FZ_Code PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;