29: g_tax_start_dd_mm constant varchar2(11) := '01-04-';
30: --
31: -- Dimension Name constants
32: --
33: g_asg_td constant pay_balance_dimensions.dimension_name%type := upper('_asg_td');
34: g_asg_ptd constant pay_balance_dimensions.dimension_name%type := upper('_asg_ptd');
35: g_asg_ytd constant pay_balance_dimensions.dimension_name%type := upper('_asg_ytd');
36: g_asg_fy_qtd constant pay_balance_dimensions.dimension_name%type := upper('_asg_fy_qtd');
37: g_asg_fy_ytd constant pay_balance_dimensions.dimension_name%type := upper('_asg_fy_ytd');
30: --
31: -- Dimension Name constants
32: --
33: g_asg_td constant pay_balance_dimensions.dimension_name%type := upper('_asg_td');
34: g_asg_ptd constant pay_balance_dimensions.dimension_name%type := upper('_asg_ptd');
35: g_asg_ytd constant pay_balance_dimensions.dimension_name%type := upper('_asg_ytd');
36: g_asg_fy_qtd constant pay_balance_dimensions.dimension_name%type := upper('_asg_fy_qtd');
37: g_asg_fy_ytd constant pay_balance_dimensions.dimension_name%type := upper('_asg_fy_ytd');
38: /*Bug 7037181 variable for dimension asg_hol_ytd is removed */
31: -- Dimension Name constants
32: --
33: g_asg_td constant pay_balance_dimensions.dimension_name%type := upper('_asg_td');
34: g_asg_ptd constant pay_balance_dimensions.dimension_name%type := upper('_asg_ptd');
35: g_asg_ytd constant pay_balance_dimensions.dimension_name%type := upper('_asg_ytd');
36: g_asg_fy_qtd constant pay_balance_dimensions.dimension_name%type := upper('_asg_fy_qtd');
37: g_asg_fy_ytd constant pay_balance_dimensions.dimension_name%type := upper('_asg_fy_ytd');
38: /*Bug 7037181 variable for dimension asg_hol_ytd is removed */
39: g_asg_4week constant pay_balance_dimensions.dimension_name%type := upper('_asg_4week');
32: --
33: g_asg_td constant pay_balance_dimensions.dimension_name%type := upper('_asg_td');
34: g_asg_ptd constant pay_balance_dimensions.dimension_name%type := upper('_asg_ptd');
35: g_asg_ytd constant pay_balance_dimensions.dimension_name%type := upper('_asg_ytd');
36: g_asg_fy_qtd constant pay_balance_dimensions.dimension_name%type := upper('_asg_fy_qtd');
37: g_asg_fy_ytd constant pay_balance_dimensions.dimension_name%type := upper('_asg_fy_ytd');
38: /*Bug 7037181 variable for dimension asg_hol_ytd is removed */
39: g_asg_4week constant pay_balance_dimensions.dimension_name%type := upper('_asg_4week');
40: --
33: g_asg_td constant pay_balance_dimensions.dimension_name%type := upper('_asg_td');
34: g_asg_ptd constant pay_balance_dimensions.dimension_name%type := upper('_asg_ptd');
35: g_asg_ytd constant pay_balance_dimensions.dimension_name%type := upper('_asg_ytd');
36: g_asg_fy_qtd constant pay_balance_dimensions.dimension_name%type := upper('_asg_fy_qtd');
37: g_asg_fy_ytd constant pay_balance_dimensions.dimension_name%type := upper('_asg_fy_ytd');
38: /*Bug 7037181 variable for dimension asg_hol_ytd is removed */
39: g_asg_4week constant pay_balance_dimensions.dimension_name%type := upper('_asg_4week');
40: --
41: -----------------------------------------------------------------------------
35: g_asg_ytd constant pay_balance_dimensions.dimension_name%type := upper('_asg_ytd');
36: g_asg_fy_qtd constant pay_balance_dimensions.dimension_name%type := upper('_asg_fy_qtd');
37: g_asg_fy_ytd constant pay_balance_dimensions.dimension_name%type := upper('_asg_fy_ytd');
38: /*Bug 7037181 variable for dimension asg_hol_ytd is removed */
39: g_asg_4week constant pay_balance_dimensions.dimension_name%type := upper('_asg_4week');
40: --
41: -----------------------------------------------------------------------------
42: -- name
43: -- expiry_date