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 211: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types

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

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

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

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

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

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

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

Line 283: from pay_balance_types

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

Line 325: from pay_balance_types

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 796: from pay_balance_types

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

Line 838: from pay_balance_types

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