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 2005/09/12 23:49:04 keyazawa noship $ */
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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
32: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';

Line 29: c_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
32: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
33: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';

Line 30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
32: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
33: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
34: --- Used by PAYJPCMA.fmx ---------------

Line 31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_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_pjob_elm_name constant pay_element_types_f.element_name%TYPE := 'YEA_PREV_EMP_INFO';
30: c_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_LTX_INFO';
31: c_term_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_TRM_INFO';
32: c_sp_ltax_elm_name constant pay_element_types_f.element_name%TYPE := 'TRM_LTX_SP_WITHHOLD_PROC';
33: c_nonresident_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
34: --- Used by PAYJPCMA.fmx ---------------
35: c_cma_train_elm_name constant pay_element_types_f.element_name%TYPE := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';

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

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

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

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

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

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

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

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

Line 55: l_element_name pay_element_types_f.element_name%TYPE;

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

Line 146: l_elm_rec pay_element_types_f%ROWTYPE;

142: p_elm_rec_tbl out nocopy elm_rec_tbl,
143: p_iv_rec_tbl out nocopy iv_rec_tbl)
144: Is
145: l_index number;
146: l_elm_rec pay_element_types_f%ROWTYPE;
147: Cursor csr_iv(p_element_type_id number) is
148: select piv.input_value_id,
149: piv.display_sequence,
150: piv.uom,

Line 491: from pay_element_types_f pet,

487: decode(piv.hot_default_flag,
488: 'Y',nvl(pliv.warning_or_error,piv.warning_or_error),
489: pliv.warning_or_error) WARNING_OR_ERROR,
490: pet.input_currency_code
491: from pay_element_types_f pet,
492: pay_input_values_f_tl pivtl,
493: pay_input_values_f piv,
494: pay_link_input_values_f pliv
495: where pliv.element_link_id = p_element_link_id

Line 708: l_processing_type pay_element_types_f.processing_type%TYPE;

704: --
705: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
706: --
707: l_entry_type pay_element_entries_f.entry_type%TYPE;
708: l_processing_type pay_element_types_f.processing_type%TYPE;
709: --
710: Cursor C_Sel1 Is
711: select pee.entry_type,
712: pet.processing_type

Line 713: from pay_element_types_f pet,

709: --
710: Cursor C_Sel1 Is
711: select pee.entry_type,
712: pet.processing_type
713: from pay_element_types_f pet,
714: pay_element_links_f pel,
715: pay_element_entries_f pee
716: where pee.element_entry_id = p_base_key_value
717: and p_effective_date

Line 785: l_processing_type pay_element_types_f.processing_type%TYPE;

781: --
782: l_parent_key_value1 number;
783: l_parent_key_value2 number;
784: l_entry_type pay_element_entries_f.entry_type%TYPE;
785: l_processing_type pay_element_types_f.processing_type%TYPE;
786: --
787: Cursor C_Sel1 Is
788: select pee.assignment_id,
789: pee.element_link_id,

Line 792: from pay_element_types_f pet,

788: select pee.assignment_id,
789: pee.element_link_id,
790: pee.entry_type,
791: pet.processing_type
792: from pay_element_types_f pet,
793: pay_element_links_f pel,
794: pay_element_entries_f pee
795: where pee.element_entry_id = p_base_key_value
796: and p_effective_date