APPS.PAY_CA_USER_INIT_DEDN dependencies on PAY_BALANCE_DIMENSIONS

Line 168: FROM pay_balance_dimensions

164: --
165:
166: CURSOR get_asg_gre_run_dim_id IS
167: SELECT balance_dimension_id
168: FROM pay_balance_dimensions
169: WHERE dimension_name = 'Assignment within Government Reporting Entity Run'
170: AND legislation_code = 'CA';
171:
172: CURSOR get_asg_jd_gre_run_dim_id IS

Line 174: FROM pay_balance_dimensions

170: AND legislation_code = 'CA';
171:
172: CURSOR get_asg_jd_gre_run_dim_id IS
173: SELECT balance_dimension_id
174: FROM pay_balance_dimensions
175: WHERE dimension_name = 'Assignment in JD within GRE Run'
176: AND legislation_code = 'CA';
177:
178: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 178: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

174: FROM pay_balance_dimensions
175: WHERE dimension_name = 'Assignment in JD within GRE Run'
176: AND legislation_code = 'CA';
177:
178: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
179: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
180:
181:
182: -- global constants

Line 179: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

175: WHERE dimension_name = 'Assignment in JD within GRE Run'
176: AND legislation_code = 'CA';
177:
178: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
179: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
180:
181:
182: -- global constants
183: c_end_of_time CONSTANT DATE := TO_DATE('4712/12/31','YYYY/MM/DD');

Line 686: FROM pay_balance_dimensions

682: --
683:
684: CURSOR get_asg_gre_run_dim_id IS
685: SELECT balance_dimension_id
686: FROM pay_balance_dimensions
687: WHERE dimension_name = 'Assignment within Government Reporting Entity Run'
688: AND legislation_code = 'CA';
689:
690: CURSOR get_asg_jd_gre_run_dim_id IS

Line 692: FROM pay_balance_dimensions

688: AND legislation_code = 'CA';
689:
690: CURSOR get_asg_jd_gre_run_dim_id IS
691: SELECT balance_dimension_id
692: FROM pay_balance_dimensions
693: WHERE dimension_name = 'Assignment in JD within GRE Run'
694: AND legislation_code = 'CA';
695:
696: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 696: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

692: FROM pay_balance_dimensions
693: WHERE dimension_name = 'Assignment in JD within GRE Run'
694: AND legislation_code = 'CA';
695:
696: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
697: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
698:
699: -- global constants
700: c_end_of_time CONSTANT DATE := TO_DATE('4712/12/31','YYYY/MM/DD');

Line 697: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

693: WHERE dimension_name = 'Assignment in JD within GRE Run'
694: AND legislation_code = 'CA';
695:
696: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
697: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
698:
699: -- global constants
700: c_end_of_time CONSTANT DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
701: