DBA Data[Home] [Help]

APPS.PAY_JP_ENTRIES_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 6: c_si_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_SI_INFO';

2: /* $Header: pyjpetr.pkb 120.1.12010000.2 2010/01/26 07:28:57 keyazawa ship $ */
3: --
4: -- Constant values used to remove Japanese characters(Temporary solution).
5: --
6: c_si_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_SI_INFO';
7: c_li_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LI_INFO';
8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';

Line 7: c_li_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LI_INFO';

3: --
4: -- Constant values used to remove Japanese characters(Temporary solution).
5: --
6: c_si_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_SI_INFO';
7: c_li_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LI_INFO';
8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';

Line 8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';

4: -- Constant values used to remove Japanese characters(Temporary solution).
5: --
6: c_si_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_SI_INFO';
7: c_li_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LI_INFO';
8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';

Line 9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';

5: --
6: c_si_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_SI_INFO';
7: c_li_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LI_INFO';
8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';

Line 10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';

6: c_si_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_SI_INFO';
7: c_li_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LI_INFO';
8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';

Line 11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';

7: c_li_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LI_INFO';
8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';

Line 12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';

8: c_ci_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_CI_EXCLUDE_INFO';
9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';

Line 13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';

9: c_hi_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_QUALIFY_INFO';
10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';

Line 14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';

10: c_wp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_QUALIFY_INFO';
11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';

Line 15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';

11: c_wpf_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WPF_QUALIFY_INFO';
12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';

Line 16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';

12: c_ui_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_EI_QUALIFY_INFO';
13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';

Line 17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';

13: c_hi_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_HI_PREM_PROC';
14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';

Line 18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';

14: c_wp_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_WP_PREM_PROC';
15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';

Line 19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';

15: c_ui_sal_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_EI_PREM_PROC';
16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';

Line 20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';

16: c_hi_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';

Line 21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';

17: c_hi_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_HI_PREM_PROC';
18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';

Line 22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';

18: c_wp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';

Line 23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';

19: c_wp_bon2_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_WP_PREM_PROC';
20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';

Line 24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';

20: c_ui_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'BON_EI_PREM_PROC';
21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';

Line 25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';

21: c_ui_sp_bon_elm_name constant pay_element_types_f.element_name%TYPE := 'SPB_EI_PREM_PROC';
22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';

Line 26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';

22: c_hi_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_HI_SMR_INFO';
23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';

Line 27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';

23: c_wp_comp_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_WP_SMR_INFO';
24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';

Line 28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';

24: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';

Line 29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';

25: c_depends_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';

Line 30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';

26: c_insprems_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_INS_PREM_SPOUSE_SP_EXM_INFO';
27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';

Line 31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';

27: c_adj_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_ADJ_INFO';
28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
35: --- Used by PAYJPCMA.fmx ---------------

Line 32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';

28: c_housing_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_TAX_CREDIT';
29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
35: --- Used by PAYJPCMA.fmx ---------------
36: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';

Line 33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';

29: c_hld_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_HOUSING_LOAN_INFO';
30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
35: --- Used by PAYJPCMA.fmx ---------------
36: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
37: c_cma_car_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';

Line 34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';

30: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
31: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
35: --- Used by PAYJPCMA.fmx ---------------
36: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
37: c_cma_car_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';
38: --

Line 36: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';

32: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
35: --- Used by PAYJPCMA.fmx ---------------
36: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
37: c_cma_car_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';
38: --
39: -- Current Element Entry Row Hander "pay_ele_shd" does not comply with API
40: -- strategy. "pay_ele_shd" is like API, but not API. So this package

Line 37: c_cma_car_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';

33: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
34: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
35: --- Used by PAYJPCMA.fmx ---------------
36: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
37: c_cma_car_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';
38: --
39: -- Current Element Entry Row Hander "pay_ele_shd" does not comply with API
40: -- strategy. "pay_ele_shd" is like API, but not API. So this package
41: -- used in PAYJPTAX form implement part of real API to use DTCSAPI library.

Line 56: l_element_name pay_element_types_f.element_name%TYPE;

52: --
53: Function element_name(
54: p_element_code in varchar2) return varchar2
55: Is
56: l_element_name pay_element_types_f.element_name%TYPE;
57: Begin
58: --- Used by PAYJPTAX.fmx ---------------
59: if p_element_code = 'SI' then
60: l_element_name := c_si_elm_name;

Line 149: l_elm_rec pay_element_types_f%ROWTYPE;

145: p_elm_rec_tbl out nocopy elm_rec_tbl,
146: p_iv_rec_tbl out nocopy iv_rec_tbl)
147: Is
148: l_index number;
149: l_elm_rec pay_element_types_f%ROWTYPE;
150: l_effective_date date;
151: Cursor csr_iv(
152: p_element_type_id number,
153: p_eff_date date) is

Line 507: from pay_element_types_f pet,

503: decode(piv.hot_default_flag,
504: 'Y',nvl(pliv.warning_or_error,piv.warning_or_error),
505: pliv.warning_or_error) WARNING_OR_ERROR,
506: pet.input_currency_code
507: from pay_element_types_f pet,
508: pay_input_values_f_tl pivtl,
509: pay_input_values_f piv,
510: pay_link_input_values_f pliv
511: where pliv.element_link_id = p_element_link_id

Line 724: l_processing_type pay_element_types_f.processing_type%TYPE;

720: --
721: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
722: --
723: l_entry_type pay_element_entries_f.entry_type%TYPE;
724: l_processing_type pay_element_types_f.processing_type%TYPE;
725: --
726: Cursor C_Sel1 Is
727: select pee.entry_type,
728: pet.processing_type

Line 729: from pay_element_types_f pet,

725: --
726: Cursor C_Sel1 Is
727: select pee.entry_type,
728: pet.processing_type
729: from pay_element_types_f pet,
730: pay_element_links_f pel,
731: pay_element_entries_f pee
732: where pee.element_entry_id = p_base_key_value
733: and p_effective_date

Line 801: l_processing_type pay_element_types_f.processing_type%TYPE;

797: --
798: l_parent_key_value1 number;
799: l_parent_key_value2 number;
800: l_entry_type pay_element_entries_f.entry_type%TYPE;
801: l_processing_type pay_element_types_f.processing_type%TYPE;
802: --
803: Cursor C_Sel1 Is
804: select pee.assignment_id,
805: pee.element_link_id,

Line 808: from pay_element_types_f pet,

804: select pee.assignment_id,
805: pee.element_link_id,
806: pee.entry_type,
807: pet.processing_type
808: from pay_element_types_f pet,
809: pay_element_links_f pel,
810: pay_element_entries_f pee
811: where pee.element_entry_id = p_base_key_value
812: and p_effective_date