APPS.PAY_CA_USER_INIT_DEDN dependencies on PAY_BALANCE_DIMENSIONS

Line 171: FROM pay_balance_dimensions

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

Line 177: FROM pay_balance_dimensions

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

Line 181: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

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

Line 182: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

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

Line 689: FROM pay_balance_dimensions

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

Line 695: FROM pay_balance_dimensions

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

Line 699: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

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

Line 700: l_asg_jd_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

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