DBA Data[Home] [Help]

APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on HR_LOOKUPS

Line 17: si_type hr_lookups.meaning%TYPE,

13: defined_balance_id NUMBER,
14: balance_narrative VARCHAR2(30),
15: balance_name pay_balance_types.balance_name%TYPE,
16: database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE,
17: si_type hr_lookups.meaning%TYPE,
18: legislation_code pay_balance_dimensions.legislation_code%TYPE);
19:
20: TYPE element_rec IS RECORD (
21: element_type_id NUMBER,

Line 24: si_type hr_lookups.meaning%TYPE,

20: TYPE element_rec IS RECORD (
21: element_type_id NUMBER,
22: input_value_id NUMBER,
23: formula_id NUMBER,
24: si_type hr_lookups.meaning%TYPE,
25: element_narrative VARCHAR2(30));
26:
27: TYPE statutory_element_rec IS RECORD (
28: classification_name pay_element_classifications.classification_name%TYPE

Line 1643: l_value hr_lookups.lookup_code%TYPE;

1639:
1640: --
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;

Line 1644: l_meaning hr_lookups.meaning%TYPE;

1640: --
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;

Line 1651: l_ni hr_lookups.meaning%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;
1654: l_age NUMBER;
1655: l_period_type pay_all_payrolls_f.period_type%TYPE;

Line 1652: l_period hr_lookups.meaning%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;
1654: l_age NUMBER;
1655: l_period_type pay_all_payrolls_f.period_type%TYPE;
1656: l_ret pay_user_column_instances_f.value%TYPE;

Line 1653: l_table hr_lookups.meaning%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;
1654: l_age NUMBER;
1655: l_period_type pay_all_payrolls_f.period_type%TYPE;
1656: l_ret pay_user_column_instances_f.value%TYPE;
1657: l_struct_id NUMBER;

Line 1689: l_province hr_lookups.meaning%TYPE;

1685: l_ovn NUMBER;
1686: l_organization_Id NUMBER;
1687: l_individual_working_hours NUMBER;
1688: l_not_defined VARCHAR2(255);
1689: l_province hr_lookups.meaning%TYPE;
1690: l_city hr_lookups.meaning%TYPE;
1691: l_street_name hr_lookups.meaning%TYPE;
1692: l_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
1693: l_dummy NUMBER;

Line 1690: l_city hr_lookups.meaning%TYPE;

1686: l_organization_Id NUMBER;
1687: l_individual_working_hours NUMBER;
1688: l_not_defined VARCHAR2(255);
1689: l_province hr_lookups.meaning%TYPE;
1690: l_city hr_lookups.meaning%TYPE;
1691: l_street_name hr_lookups.meaning%TYPE;
1692: l_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
1693: l_dummy NUMBER;
1694: --

Line 1691: l_street_name hr_lookups.meaning%TYPE;

1687: l_individual_working_hours NUMBER;
1688: l_not_defined VARCHAR2(255);
1689: l_province hr_lookups.meaning%TYPE;
1690: l_city hr_lookups.meaning%TYPE;
1691: l_street_name hr_lookups.meaning%TYPE;
1692: l_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
1693: l_dummy NUMBER;
1694: --
1695: BEGIN