DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 4659: FROM hr_soft_coding_keyflex

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;

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

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

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

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

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

Line 4667: l_wage_wajong 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: --
4671: BEGIN

Line 4668: l_emp_loan 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
4672: --

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

Line 6292: l_income_code hr_soft_coding_keyflex.segment1%type;

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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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