DBA Data[Home] [Help]

APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 1486: ,hr_soft_coding_keyflex scl

1482: ,scl.segment7 labour_tax_reduction
1483: ,scl.segment9 add_senior_tax_reduction
1484: ,FND_NUMBER.Canonical_To_Number(scl.segment28) individual_working_hours
1485: FROM per_assignments_f paf
1486: ,hr_soft_coding_keyflex scl
1487: WHERE paf.assignment_id = p_assignment_id
1488: AND p_date_earned BETWEEN paf.effective_start_date
1489: AND paf.effective_end_date
1490: AND paf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;

Line 1645: l_tax_code hr_soft_coding_keyflex.segment1%TYPE;

1641: --
1642: csr_hr_org_address_rec csr_get_hr_org_address%ROWTYPE;
1643: l_value hr_lookups.lookup_code%TYPE;
1644: l_meaning hr_lookups.meaning%TYPE;
1645: l_tax_code hr_soft_coding_keyflex.segment1%TYPE;
1646: l_prev_year_sal hr_soft_coding_keyflex.segment1%TYPE;
1647: l_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1648: l_labour_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1649: l_add_senior_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;

Line 1646: l_prev_year_sal hr_soft_coding_keyflex.segment1%TYPE;

1642: csr_hr_org_address_rec csr_get_hr_org_address%ROWTYPE;
1643: l_value hr_lookups.lookup_code%TYPE;
1644: l_meaning hr_lookups.meaning%TYPE;
1645: l_tax_code hr_soft_coding_keyflex.segment1%TYPE;
1646: l_prev_year_sal hr_soft_coding_keyflex.segment1%TYPE;
1647: l_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1648: l_labour_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1649: l_add_senior_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1650: l_org_struct_id NUMBER;

Line 1647: l_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;

1643: l_value hr_lookups.lookup_code%TYPE;
1644: l_meaning hr_lookups.meaning%TYPE;
1645: l_tax_code hr_soft_coding_keyflex.segment1%TYPE;
1646: l_prev_year_sal hr_soft_coding_keyflex.segment1%TYPE;
1647: l_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1648: l_labour_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1649: l_add_senior_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1650: l_org_struct_id NUMBER;
1651: l_ni hr_lookups.meaning%TYPE;

Line 1648: l_labour_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;

1644: l_meaning hr_lookups.meaning%TYPE;
1645: l_tax_code hr_soft_coding_keyflex.segment1%TYPE;
1646: l_prev_year_sal hr_soft_coding_keyflex.segment1%TYPE;
1647: l_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1648: l_labour_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1649: l_add_senior_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1650: l_org_struct_id NUMBER;
1651: l_ni hr_lookups.meaning%TYPE;
1652: l_period hr_lookups.meaning%TYPE;

Line 1649: l_add_senior_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;

1645: l_tax_code hr_soft_coding_keyflex.segment1%TYPE;
1646: l_prev_year_sal hr_soft_coding_keyflex.segment1%TYPE;
1647: l_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1648: l_labour_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1649: l_add_senior_tax_reduction hr_soft_coding_keyflex.segment1%TYPE;
1650: l_org_struct_id NUMBER;
1651: l_ni hr_lookups.meaning%TYPE;
1652: l_period hr_lookups.meaning%TYPE;
1653: l_table hr_lookups.meaning%TYPE;