DBA Data[Home] [Help]

APPS.HR_JPRTS dependencies on PAY_BALANCE_DIMENSIONS

Line 8: g_asg_run PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RUN';

4: /* ------------------------------------------------------------------------------------
5: -- Define Global Value, which are parameter values in HR_JP_PARAMETERS.
6: -- HR_JPBAL, HR_JPDRB call them.
7: -- ------------------------------------------------------------------------------------ */
8: g_asg_run PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RUN';
9: g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';
10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';

Line 9: g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';

5: -- Define Global Value, which are parameter values in HR_JP_PARAMETERS.
6: -- HR_JPBAL, HR_JPDRB call them.
7: -- ------------------------------------------------------------------------------------ */
8: g_asg_run PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RUN';
9: g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';
10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';

Line 10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';

6: -- HR_JPBAL, HR_JPDRB call them.
7: -- ------------------------------------------------------------------------------------ */
8: g_asg_run PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RUN';
9: g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';
10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';

Line 11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';

7: -- ------------------------------------------------------------------------------------ */
8: g_asg_run PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RUN';
9: g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';
10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';

Line 12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';

8: g_asg_run PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RUN';
9: g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';
10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';

Line 13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';

9: g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';
10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';

Line 14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';

10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';

Line 15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';

11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
19: g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';

Line 16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';

12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
19: g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';
20: g_asg_fytd2_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_BYTD';

Line 17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';

13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
19: g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';
20: g_asg_fytd2_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_BYTD';
21: /* ------------------------------------------------------------------------------------ */

Line 18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';

14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
19: g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';
20: g_asg_fytd2_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_BYTD';
21: /* ------------------------------------------------------------------------------------ */
22: FUNCTION span_start(

Line 19: g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';

15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
19: g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';
20: g_asg_fytd2_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_BYTD';
21: /* ------------------------------------------------------------------------------------ */
22: FUNCTION span_start(
23: p_input_date IN DATE,

Line 20: g_asg_fytd2_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_BYTD';

16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
19: g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';
20: g_asg_fytd2_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_BYTD';
21: /* ------------------------------------------------------------------------------------ */
22: FUNCTION span_start(
23: p_input_date IN DATE,
24: p_frequency IN NUMBER,