eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PYJPEXC dependencies on PAY_BALANCE_DIMENSIONS

Line 6: c_asg_run constant pay_balance_dimensions.dimension_name%type := '_ASG_RUN';

2: /* $Header: pyjpexc.pkh 120.1.12000000.2 2007/03/05 08:54:30 keyazawa noship $ */
3: --
4: -- Constants
5: --
6: c_asg_run constant pay_balance_dimensions.dimension_name%type := '_ASG_RUN';
7: c_asg_ptd constant pay_balance_dimensions.dimension_name%type := '_ASG_PTD';
8: c_asg_mtd constant pay_balance_dimensions.dimension_name%type := '_ASG_MTD_RUN EFFECTIVE_DATE 01-01 RESET 12';
9: c_asg_ytd constant pay_balance_dimensions.dimension_name%type := '_ASG_YTD_RUN EFFECTIVE_DATE 01-01 RESET 01';
10: c_asg_aprtd constant pay_balance_dimensions.dimension_name%type := '_ASG_APRTD EFFECTIVE_DATE 01-04 RESET 01';

Line 7: c_asg_ptd constant pay_balance_dimensions.dimension_name%type := '_ASG_PTD';

3: --
4: -- Constants
5: --
6: c_asg_run constant pay_balance_dimensions.dimension_name%type := '_ASG_RUN';
7: c_asg_ptd constant pay_balance_dimensions.dimension_name%type := '_ASG_PTD';
8: c_asg_mtd constant pay_balance_dimensions.dimension_name%type := '_ASG_MTD_RUN EFFECTIVE_DATE 01-01 RESET 12';
9: c_asg_ytd constant pay_balance_dimensions.dimension_name%type := '_ASG_YTD_RUN EFFECTIVE_DATE 01-01 RESET 01';
10: c_asg_aprtd constant pay_balance_dimensions.dimension_name%type := '_ASG_APRTD EFFECTIVE_DATE 01-04 RESET 01';
11: c_asg_jultd constant pay_balance_dimensions.dimension_name%type := '_ASG_JULTD_RUN EFFECTIVE_DATE 01-07 RESET 01';

Line 8: c_asg_mtd constant pay_balance_dimensions.dimension_name%type := '_ASG_MTD_RUN EFFECTIVE_DATE 01-01 RESET 12';

4: -- Constants
5: --
6: c_asg_run constant pay_balance_dimensions.dimension_name%type := '_ASG_RUN';
7: c_asg_ptd constant pay_balance_dimensions.dimension_name%type := '_ASG_PTD';
8: c_asg_mtd constant pay_balance_dimensions.dimension_name%type := '_ASG_MTD_RUN EFFECTIVE_DATE 01-01 RESET 12';
9: c_asg_ytd constant pay_balance_dimensions.dimension_name%type := '_ASG_YTD_RUN EFFECTIVE_DATE 01-01 RESET 01';
10: c_asg_aprtd constant pay_balance_dimensions.dimension_name%type := '_ASG_APRTD EFFECTIVE_DATE 01-04 RESET 01';
11: c_asg_jultd constant pay_balance_dimensions.dimension_name%type := '_ASG_JULTD_RUN EFFECTIVE_DATE 01-07 RESET 01';
12: c_asg_augtd constant pay_balance_dimensions.dimension_name%type := '_ASG_AUGTD_RUN EFFECTIVE_DATE 01-08 RESET 01';

Line 9: c_asg_ytd constant pay_balance_dimensions.dimension_name%type := '_ASG_YTD_RUN EFFECTIVE_DATE 01-01 RESET 01';

5: --
6: c_asg_run constant pay_balance_dimensions.dimension_name%type := '_ASG_RUN';
7: c_asg_ptd constant pay_balance_dimensions.dimension_name%type := '_ASG_PTD';
8: c_asg_mtd constant pay_balance_dimensions.dimension_name%type := '_ASG_MTD_RUN EFFECTIVE_DATE 01-01 RESET 12';
9: c_asg_ytd constant pay_balance_dimensions.dimension_name%type := '_ASG_YTD_RUN EFFECTIVE_DATE 01-01 RESET 01';
10: c_asg_aprtd constant pay_balance_dimensions.dimension_name%type := '_ASG_APRTD EFFECTIVE_DATE 01-04 RESET 01';
11: c_asg_jultd constant pay_balance_dimensions.dimension_name%type := '_ASG_JULTD_RUN EFFECTIVE_DATE 01-07 RESET 01';
12: c_asg_augtd constant pay_balance_dimensions.dimension_name%type := '_ASG_AUGTD_RUN EFFECTIVE_DATE 01-08 RESET 01';
13: c_asg_fytd constant pay_balance_dimensions.dimension_name%type := '_ASG_BYTD_RUN';

Line 10: c_asg_aprtd constant pay_balance_dimensions.dimension_name%type := '_ASG_APRTD EFFECTIVE_DATE 01-04 RESET 01';

6: c_asg_run constant pay_balance_dimensions.dimension_name%type := '_ASG_RUN';
7: c_asg_ptd constant pay_balance_dimensions.dimension_name%type := '_ASG_PTD';
8: c_asg_mtd constant pay_balance_dimensions.dimension_name%type := '_ASG_MTD_RUN EFFECTIVE_DATE 01-01 RESET 12';
9: c_asg_ytd constant pay_balance_dimensions.dimension_name%type := '_ASG_YTD_RUN EFFECTIVE_DATE 01-01 RESET 01';
10: c_asg_aprtd constant pay_balance_dimensions.dimension_name%type := '_ASG_APRTD EFFECTIVE_DATE 01-04 RESET 01';
11: c_asg_jultd constant pay_balance_dimensions.dimension_name%type := '_ASG_JULTD_RUN EFFECTIVE_DATE 01-07 RESET 01';
12: c_asg_augtd constant pay_balance_dimensions.dimension_name%type := '_ASG_AUGTD_RUN EFFECTIVE_DATE 01-08 RESET 01';
13: c_asg_fytd constant pay_balance_dimensions.dimension_name%type := '_ASG_BYTD_RUN';
14: c_asg_fytd_de constant pay_balance_dimensions.dimension_name%type := '_ASG_FYTD_RUN DATE_EARNED RESET 01';

Line 11: c_asg_jultd constant pay_balance_dimensions.dimension_name%type := '_ASG_JULTD_RUN EFFECTIVE_DATE 01-07 RESET 01';

7: c_asg_ptd constant pay_balance_dimensions.dimension_name%type := '_ASG_PTD';
8: c_asg_mtd constant pay_balance_dimensions.dimension_name%type := '_ASG_MTD_RUN EFFECTIVE_DATE 01-01 RESET 12';
9: c_asg_ytd constant pay_balance_dimensions.dimension_name%type := '_ASG_YTD_RUN EFFECTIVE_DATE 01-01 RESET 01';
10: c_asg_aprtd constant pay_balance_dimensions.dimension_name%type := '_ASG_APRTD EFFECTIVE_DATE 01-04 RESET 01';
11: c_asg_jultd constant pay_balance_dimensions.dimension_name%type := '_ASG_JULTD_RUN EFFECTIVE_DATE 01-07 RESET 01';
12: c_asg_augtd constant pay_balance_dimensions.dimension_name%type := '_ASG_AUGTD_RUN EFFECTIVE_DATE 01-08 RESET 01';
13: c_asg_fytd constant pay_balance_dimensions.dimension_name%type := '_ASG_BYTD_RUN';
14: c_asg_fytd_de constant pay_balance_dimensions.dimension_name%type := '_ASG_FYTD_RUN DATE_EARNED RESET 01';
15: c_asg_ltd constant pay_balance_dimensions.dimension_name%type := '_ASG_HTD_RUN';

Line 12: c_asg_augtd constant pay_balance_dimensions.dimension_name%type := '_ASG_AUGTD_RUN EFFECTIVE_DATE 01-08 RESET 01';

8: c_asg_mtd constant pay_balance_dimensions.dimension_name%type := '_ASG_MTD_RUN EFFECTIVE_DATE 01-01 RESET 12';
9: c_asg_ytd constant pay_balance_dimensions.dimension_name%type := '_ASG_YTD_RUN EFFECTIVE_DATE 01-01 RESET 01';
10: c_asg_aprtd constant pay_balance_dimensions.dimension_name%type := '_ASG_APRTD EFFECTIVE_DATE 01-04 RESET 01';
11: c_asg_jultd constant pay_balance_dimensions.dimension_name%type := '_ASG_JULTD_RUN EFFECTIVE_DATE 01-07 RESET 01';
12: c_asg_augtd constant pay_balance_dimensions.dimension_name%type := '_ASG_AUGTD_RUN EFFECTIVE_DATE 01-08 RESET 01';
13: c_asg_fytd constant pay_balance_dimensions.dimension_name%type := '_ASG_BYTD_RUN';
14: c_asg_fytd_de constant pay_balance_dimensions.dimension_name%type := '_ASG_FYTD_RUN DATE_EARNED RESET 01';
15: c_asg_ltd constant pay_balance_dimensions.dimension_name%type := '_ASG_HTD_RUN';
16: c_element_ptd constant pay_balance_dimensions.dimension_name%type := '_ELM_PTD_RUN';

Line 13: c_asg_fytd constant pay_balance_dimensions.dimension_name%type := '_ASG_BYTD_RUN';

9: c_asg_ytd constant pay_balance_dimensions.dimension_name%type := '_ASG_YTD_RUN EFFECTIVE_DATE 01-01 RESET 01';
10: c_asg_aprtd constant pay_balance_dimensions.dimension_name%type := '_ASG_APRTD EFFECTIVE_DATE 01-04 RESET 01';
11: c_asg_jultd constant pay_balance_dimensions.dimension_name%type := '_ASG_JULTD_RUN EFFECTIVE_DATE 01-07 RESET 01';
12: c_asg_augtd constant pay_balance_dimensions.dimension_name%type := '_ASG_AUGTD_RUN EFFECTIVE_DATE 01-08 RESET 01';
13: c_asg_fytd constant pay_balance_dimensions.dimension_name%type := '_ASG_BYTD_RUN';
14: c_asg_fytd_de constant pay_balance_dimensions.dimension_name%type := '_ASG_FYTD_RUN DATE_EARNED RESET 01';
15: c_asg_ltd constant pay_balance_dimensions.dimension_name%type := '_ASG_HTD_RUN';
16: c_element_ptd constant pay_balance_dimensions.dimension_name%type := '_ELM_PTD_RUN';
17: c_element_ltd constant pay_balance_dimensions.dimension_name%type := '_ELM_LTD_RUN';

Line 14: c_asg_fytd_de constant pay_balance_dimensions.dimension_name%type := '_ASG_FYTD_RUN DATE_EARNED RESET 01';

10: c_asg_aprtd constant pay_balance_dimensions.dimension_name%type := '_ASG_APRTD EFFECTIVE_DATE 01-04 RESET 01';
11: c_asg_jultd constant pay_balance_dimensions.dimension_name%type := '_ASG_JULTD_RUN EFFECTIVE_DATE 01-07 RESET 01';
12: c_asg_augtd constant pay_balance_dimensions.dimension_name%type := '_ASG_AUGTD_RUN EFFECTIVE_DATE 01-08 RESET 01';
13: c_asg_fytd constant pay_balance_dimensions.dimension_name%type := '_ASG_BYTD_RUN';
14: c_asg_fytd_de constant pay_balance_dimensions.dimension_name%type := '_ASG_FYTD_RUN DATE_EARNED RESET 01';
15: c_asg_ltd constant pay_balance_dimensions.dimension_name%type := '_ASG_HTD_RUN';
16: c_element_ptd constant pay_balance_dimensions.dimension_name%type := '_ELM_PTD_RUN';
17: c_element_ltd constant pay_balance_dimensions.dimension_name%type := '_ELM_LTD_RUN';
18: c_asg_retro constant pay_balance_dimensions.dimension_name%type := '_ASG_RETRO_PAY';

Line 15: c_asg_ltd constant pay_balance_dimensions.dimension_name%type := '_ASG_HTD_RUN';

11: c_asg_jultd constant pay_balance_dimensions.dimension_name%type := '_ASG_JULTD_RUN EFFECTIVE_DATE 01-07 RESET 01';
12: c_asg_augtd constant pay_balance_dimensions.dimension_name%type := '_ASG_AUGTD_RUN EFFECTIVE_DATE 01-08 RESET 01';
13: c_asg_fytd constant pay_balance_dimensions.dimension_name%type := '_ASG_BYTD_RUN';
14: c_asg_fytd_de constant pay_balance_dimensions.dimension_name%type := '_ASG_FYTD_RUN DATE_EARNED RESET 01';
15: c_asg_ltd constant pay_balance_dimensions.dimension_name%type := '_ASG_HTD_RUN';
16: c_element_ptd constant pay_balance_dimensions.dimension_name%type := '_ELM_PTD_RUN';
17: c_element_ltd constant pay_balance_dimensions.dimension_name%type := '_ELM_LTD_RUN';
18: c_asg_retro constant pay_balance_dimensions.dimension_name%type := '_ASG_RETRO_PAY';
19: c_payments constant pay_balance_dimensions.dimension_name%type := '_PAYMENTS';

Line 16: c_element_ptd constant pay_balance_dimensions.dimension_name%type := '_ELM_PTD_RUN';

12: c_asg_augtd constant pay_balance_dimensions.dimension_name%type := '_ASG_AUGTD_RUN EFFECTIVE_DATE 01-08 RESET 01';
13: c_asg_fytd constant pay_balance_dimensions.dimension_name%type := '_ASG_BYTD_RUN';
14: c_asg_fytd_de constant pay_balance_dimensions.dimension_name%type := '_ASG_FYTD_RUN DATE_EARNED RESET 01';
15: c_asg_ltd constant pay_balance_dimensions.dimension_name%type := '_ASG_HTD_RUN';
16: c_element_ptd constant pay_balance_dimensions.dimension_name%type := '_ELM_PTD_RUN';
17: c_element_ltd constant pay_balance_dimensions.dimension_name%type := '_ELM_LTD_RUN';
18: c_asg_retro constant pay_balance_dimensions.dimension_name%type := '_ASG_RETRO_PAY';
19: c_payments constant pay_balance_dimensions.dimension_name%type := '_PAYMENTS';
20: --

Line 17: c_element_ltd constant pay_balance_dimensions.dimension_name%type := '_ELM_LTD_RUN';

13: c_asg_fytd constant pay_balance_dimensions.dimension_name%type := '_ASG_BYTD_RUN';
14: c_asg_fytd_de constant pay_balance_dimensions.dimension_name%type := '_ASG_FYTD_RUN DATE_EARNED RESET 01';
15: c_asg_ltd constant pay_balance_dimensions.dimension_name%type := '_ASG_HTD_RUN';
16: c_element_ptd constant pay_balance_dimensions.dimension_name%type := '_ELM_PTD_RUN';
17: c_element_ltd constant pay_balance_dimensions.dimension_name%type := '_ELM_LTD_RUN';
18: c_asg_retro constant pay_balance_dimensions.dimension_name%type := '_ASG_RETRO_PAY';
19: c_payments constant pay_balance_dimensions.dimension_name%type := '_PAYMENTS';
20: --
21: function asg_run return varchar2;

Line 18: c_asg_retro constant pay_balance_dimensions.dimension_name%type := '_ASG_RETRO_PAY';

14: c_asg_fytd_de constant pay_balance_dimensions.dimension_name%type := '_ASG_FYTD_RUN DATE_EARNED RESET 01';
15: c_asg_ltd constant pay_balance_dimensions.dimension_name%type := '_ASG_HTD_RUN';
16: c_element_ptd constant pay_balance_dimensions.dimension_name%type := '_ELM_PTD_RUN';
17: c_element_ltd constant pay_balance_dimensions.dimension_name%type := '_ELM_LTD_RUN';
18: c_asg_retro constant pay_balance_dimensions.dimension_name%type := '_ASG_RETRO_PAY';
19: c_payments constant pay_balance_dimensions.dimension_name%type := '_PAYMENTS';
20: --
21: function asg_run return varchar2;
22: function asg_ptd return varchar2;

Line 19: c_payments constant pay_balance_dimensions.dimension_name%type := '_PAYMENTS';

15: c_asg_ltd constant pay_balance_dimensions.dimension_name%type := '_ASG_HTD_RUN';
16: c_element_ptd constant pay_balance_dimensions.dimension_name%type := '_ELM_PTD_RUN';
17: c_element_ltd constant pay_balance_dimensions.dimension_name%type := '_ELM_LTD_RUN';
18: c_asg_retro constant pay_balance_dimensions.dimension_name%type := '_ASG_RETRO_PAY';
19: c_payments constant pay_balance_dimensions.dimension_name%type := '_PAYMENTS';
20: --
21: function asg_run return varchar2;
22: function asg_ptd return varchar2;
23: function asg_mtd return varchar2;