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.PAY_CA_USER_INIT_DEDN dependencies on PAY_BALANCE_TYPES

Line 50: level on pay_balance_types for all

46: words as names.
47: 05-APR-00 RThirlby 115.6 Added call to new procedure
48: pay_ca_user_init_earn.update_jd_level-
49: _on_balance. This updates jurisdiction_
50: level on pay_balance_types for all
51: balances. Call added to create user-
52: _init_deduction. NB. THIS WILL NEED TO
53: BE ADDED TO CREATE_USER_INIT_GARNISH-
54: MENT WHEN GARNISHMENTS ARE ADDED TO

Line 208: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types

204: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
205: l_si_ele_obj_ver_number NUMBER(9); -- Object Version Number
206: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.
207:
208: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types
209: l_accr_bal_id NUMBER(9); -- Get from pay_balance_types
210: l_arr_bal_id NUMBER(9); -- Get from pay_balance_types
211: l_not_taken_bal_id NUMBER(9); -- Get from pay_balance_types
212: l_proc_run_type VARCHAR2(30); -- User-specified

Line 209: l_accr_bal_id NUMBER(9); -- Get from pay_balance_types

205: l_si_ele_obj_ver_number NUMBER(9); -- Object Version Number
206: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.
207:
208: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types
209: l_accr_bal_id NUMBER(9); -- Get from pay_balance_types
210: l_arr_bal_id NUMBER(9); -- Get from pay_balance_types
211: l_not_taken_bal_id NUMBER(9); -- Get from pay_balance_types
212: l_proc_run_type VARCHAR2(30); -- User-specified
213:

Line 210: l_arr_bal_id NUMBER(9); -- Get from pay_balance_types

206: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.
207:
208: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types
209: l_accr_bal_id NUMBER(9); -- Get from pay_balance_types
210: l_arr_bal_id NUMBER(9); -- Get from pay_balance_types
211: l_not_taken_bal_id NUMBER(9); -- Get from pay_balance_types
212: l_proc_run_type VARCHAR2(30); -- User-specified
213:
214: l_ele_repname VARCHAR2(30);

Line 211: l_not_taken_bal_id NUMBER(9); -- Get from pay_balance_types

207:
208: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types
209: l_accr_bal_id NUMBER(9); -- Get from pay_balance_types
210: l_arr_bal_id NUMBER(9); -- Get from pay_balance_types
211: l_not_taken_bal_id NUMBER(9); -- Get from pay_balance_types
212: l_proc_run_type VARCHAR2(30); -- User-specified
213:
214: l_ele_repname VARCHAR2(30);
215: l_ben_class_name VARCHAR2(80);

Line 280: from pay_balance_types

276: --
277: BEGIN
278: select 'Y'
279: into l_installed
280: from pay_balance_types
281: where upper(balance_name) = 'FED SUBJECT'
282: and legislation_code = 'CA';
283:
284: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 322: from pay_balance_types

318: --
319: BEGIN
320: select 'Y'
321: into l_reserved
322: from pay_balance_types
323: where upper(p_ele_name) = upper(balance_name)
324: and nvl(legislation_code, 'CA') = 'CA'
325: and nvl(business_group_id, p_bg_id) = p_bg_id;
326:

Line 729: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types

725: l_fee_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
726: l_fee_ele_obj_ver_number NUMBER(9); -- Object Version Number
727: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.
728:
729: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types
730: l_accr_bal_id NUMBER(9); -- Get from pay_balance_types
731: l_arr_bal_id NUMBER(9); -- Get from pay_balance_types
732: l_repl_bal_id NUMBER(9); -- Get from pay_balance_types
733: l_addl_bal_id NUMBER(9); -- Get from pay_balance_types

Line 730: l_accr_bal_id NUMBER(9); -- Get from pay_balance_types

726: l_fee_ele_obj_ver_number NUMBER(9); -- Object Version Number
727: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.
728:
729: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types
730: l_accr_bal_id NUMBER(9); -- Get from pay_balance_types
731: l_arr_bal_id NUMBER(9); -- Get from pay_balance_types
732: l_repl_bal_id NUMBER(9); -- Get from pay_balance_types
733: l_addl_bal_id NUMBER(9); -- Get from pay_balance_types
734: l_fees_bal_id NUMBER(9); -- Get from pay_balance_types

Line 731: l_arr_bal_id NUMBER(9); -- Get from pay_balance_types

727: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.
728:
729: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types
730: l_accr_bal_id NUMBER(9); -- Get from pay_balance_types
731: l_arr_bal_id NUMBER(9); -- Get from pay_balance_types
732: l_repl_bal_id NUMBER(9); -- Get from pay_balance_types
733: l_addl_bal_id NUMBER(9); -- Get from pay_balance_types
734: l_fees_bal_id NUMBER(9); -- Get from pay_balance_types
735: l_not_taken_bal_id NUMBER(9); -- Get from pay_balance_types

Line 732: l_repl_bal_id NUMBER(9); -- Get from pay_balance_types

728:
729: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types
730: l_accr_bal_id NUMBER(9); -- Get from pay_balance_types
731: l_arr_bal_id NUMBER(9); -- Get from pay_balance_types
732: l_repl_bal_id NUMBER(9); -- Get from pay_balance_types
733: l_addl_bal_id NUMBER(9); -- Get from pay_balance_types
734: l_fees_bal_id NUMBER(9); -- Get from pay_balance_types
735: l_not_taken_bal_id NUMBER(9); -- Get from pay_balance_types
736: l_proc_run_type VARCHAR2(30); -- User-specified

Line 733: l_addl_bal_id NUMBER(9); -- Get from pay_balance_types

729: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types
730: l_accr_bal_id NUMBER(9); -- Get from pay_balance_types
731: l_arr_bal_id NUMBER(9); -- Get from pay_balance_types
732: l_repl_bal_id NUMBER(9); -- Get from pay_balance_types
733: l_addl_bal_id NUMBER(9); -- Get from pay_balance_types
734: l_fees_bal_id NUMBER(9); -- Get from pay_balance_types
735: l_not_taken_bal_id NUMBER(9); -- Get from pay_balance_types
736: l_proc_run_type VARCHAR2(30); -- User-specified
737:

Line 734: l_fees_bal_id NUMBER(9); -- Get from pay_balance_types

730: l_accr_bal_id NUMBER(9); -- Get from pay_balance_types
731: l_arr_bal_id NUMBER(9); -- Get from pay_balance_types
732: l_repl_bal_id NUMBER(9); -- Get from pay_balance_types
733: l_addl_bal_id NUMBER(9); -- Get from pay_balance_types
734: l_fees_bal_id NUMBER(9); -- Get from pay_balance_types
735: l_not_taken_bal_id NUMBER(9); -- Get from pay_balance_types
736: l_proc_run_type VARCHAR2(30); -- User-specified
737:
738: l_ele_repname VARCHAR2(30);

Line 735: l_not_taken_bal_id NUMBER(9); -- Get from pay_balance_types

731: l_arr_bal_id NUMBER(9); -- Get from pay_balance_types
732: l_repl_bal_id NUMBER(9); -- Get from pay_balance_types
733: l_addl_bal_id NUMBER(9); -- Get from pay_balance_types
734: l_fees_bal_id NUMBER(9); -- Get from pay_balance_types
735: l_not_taken_bal_id NUMBER(9); -- Get from pay_balance_types
736: l_proc_run_type VARCHAR2(30); -- User-specified
737:
738: l_ele_repname VARCHAR2(30);
739: l_ben_class_name VARCHAR2(80);

Line 793: from pay_balance_types

789: --
790: BEGIN
791: select 'Y'
792: into l_installed
793: from pay_balance_types
794: where upper(balance_name) = 'FED SUBJECT'
795: and legislation_code = 'CA';
796:
797: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 835: from pay_balance_types

831: --
832: BEGIN
833: select 'Y'
834: into l_reserved
835: from pay_balance_types
836: where upper(p_ele_name) = upper(balance_name)
837: and nvl(legislation_code, 'CA') = 'CA'
838: and nvl(business_group_id, p_bg_id) = p_bg_id;
839: