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_BALANCE_PKG dependencies on PAY_LEGISLATION_RULES

Line 275: g_si_needed_chr pay_legislation_rules.rule_mode%type;

271: g_rlb_grp_defbals t_balance_value_tab;
272: g_rlb_asg_defbals t_balance_value_tab;
273: g_grp_maintained_rb t_int_rb_cache;
274: g_grp_rb_ptr_list number_array;
275: g_si_needed_chr pay_legislation_rules.rule_mode%type;
276: g_st_needed_chr pay_legislation_rules.rule_mode%type;
277: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
278: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
279: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;

Line 276: g_st_needed_chr pay_legislation_rules.rule_mode%type;

272: g_rlb_asg_defbals t_balance_value_tab;
273: g_grp_maintained_rb t_int_rb_cache;
274: g_grp_rb_ptr_list number_array;
275: g_si_needed_chr pay_legislation_rules.rule_mode%type;
276: g_st_needed_chr pay_legislation_rules.rule_mode%type;
277: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
278: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
279: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;
280: g_org_needed_chr pay_legislation_rules.rule_mode%type;

Line 277: g_sn_needed_chr pay_legislation_rules.rule_mode%type;

273: g_grp_maintained_rb t_int_rb_cache;
274: g_grp_rb_ptr_list number_array;
275: g_si_needed_chr pay_legislation_rules.rule_mode%type;
276: g_st_needed_chr pay_legislation_rules.rule_mode%type;
277: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
278: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
279: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;
280: g_org_needed_chr pay_legislation_rules.rule_mode%type;
281: g_save_run_bals pay_legislation_rules.rule_mode%type;

Line 278: g_st2_needed_chr pay_legislation_rules.rule_mode%type;

274: g_grp_rb_ptr_list number_array;
275: g_si_needed_chr pay_legislation_rules.rule_mode%type;
276: g_st_needed_chr pay_legislation_rules.rule_mode%type;
277: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
278: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
279: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;
280: g_org_needed_chr pay_legislation_rules.rule_mode%type;
281: g_save_run_bals pay_legislation_rules.rule_mode%type;
282: --

Line 279: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;

275: g_si_needed_chr pay_legislation_rules.rule_mode%type;
276: g_st_needed_chr pay_legislation_rules.rule_mode%type;
277: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
278: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
279: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;
280: g_org_needed_chr pay_legislation_rules.rule_mode%type;
281: g_save_run_bals pay_legislation_rules.rule_mode%type;
282: --
283: -- The following globals are used in get_rb_status

Line 280: g_org_needed_chr pay_legislation_rules.rule_mode%type;

276: g_st_needed_chr pay_legislation_rules.rule_mode%type;
277: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
278: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
279: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;
280: g_org_needed_chr pay_legislation_rules.rule_mode%type;
281: g_save_run_bals pay_legislation_rules.rule_mode%type;
282: --
283: -- The following globals are used in get_rb_status
284: g_aa_id NUMBER := NULL;

Line 281: g_save_run_bals pay_legislation_rules.rule_mode%type;

277: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
278: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
279: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;
280: g_org_needed_chr pay_legislation_rules.rule_mode%type;
281: g_save_run_bals pay_legislation_rules.rule_mode%type;
282: --
283: -- The following globals are used in get_rb_status
284: g_aa_id NUMBER := NULL;
285: g_retrieval_date pay_payroll_actions.effective_date%type := NULL;

Line 6635: from pay_legislation_rules plr,

6631: /* First get the legislation rule */
6632: begin
6633: select plr.rule_mode
6634: into g_save_run_bals
6635: from pay_legislation_rules plr,
6636: per_business_groups_perf pbg,
6637: pay_payroll_actions ppa
6638: where ppa.payroll_action_id = p_payroll_action_id
6639: and ppa.business_group_id = pbg.business_group_id

Line 7816: l_tu_needed_chr pay_legislation_rules.rule_mode%type;

7812: order by 1, 2, 3, 4;
7813:
7814: --
7815: l_defbal_rec t_def_bal_rec;
7816: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
7817: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
7818: l_si_needed_chr pay_legislation_rules.rule_mode%type;
7819: l_st_needed_chr pay_legislation_rules.rule_mode%type;
7820: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

Line 7817: l_jc_needed_chr pay_legislation_rules.rule_mode%type;

7813:
7814: --
7815: l_defbal_rec t_def_bal_rec;
7816: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
7817: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
7818: l_si_needed_chr pay_legislation_rules.rule_mode%type;
7819: l_st_needed_chr pay_legislation_rules.rule_mode%type;
7820: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
7821: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

Line 7818: l_si_needed_chr pay_legislation_rules.rule_mode%type;

7814: --
7815: l_defbal_rec t_def_bal_rec;
7816: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
7817: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
7818: l_si_needed_chr pay_legislation_rules.rule_mode%type;
7819: l_st_needed_chr pay_legislation_rules.rule_mode%type;
7820: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
7821: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
7822: l_td_needed_chr pay_legislation_rules.rule_mode%type;

Line 7819: l_st_needed_chr pay_legislation_rules.rule_mode%type;

7815: l_defbal_rec t_def_bal_rec;
7816: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
7817: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
7818: l_si_needed_chr pay_legislation_rules.rule_mode%type;
7819: l_st_needed_chr pay_legislation_rules.rule_mode%type;
7820: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
7821: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
7822: l_td_needed_chr pay_legislation_rules.rule_mode%type;
7823: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

Line 7820: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

7816: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
7817: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
7818: l_si_needed_chr pay_legislation_rules.rule_mode%type;
7819: l_st_needed_chr pay_legislation_rules.rule_mode%type;
7820: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
7821: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
7822: l_td_needed_chr pay_legislation_rules.rule_mode%type;
7823: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
7824: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

Line 7821: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

7817: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
7818: l_si_needed_chr pay_legislation_rules.rule_mode%type;
7819: l_st_needed_chr pay_legislation_rules.rule_mode%type;
7820: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
7821: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
7822: l_td_needed_chr pay_legislation_rules.rule_mode%type;
7823: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
7824: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
7825: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

Line 7822: l_td_needed_chr pay_legislation_rules.rule_mode%type;

7818: l_si_needed_chr pay_legislation_rules.rule_mode%type;
7819: l_st_needed_chr pay_legislation_rules.rule_mode%type;
7820: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
7821: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
7822: l_td_needed_chr pay_legislation_rules.rule_mode%type;
7823: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
7824: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
7825: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
7826: l_org_needed_chr pay_legislation_rules.rule_mode%type;

Line 7823: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

7819: l_st_needed_chr pay_legislation_rules.rule_mode%type;
7820: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
7821: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
7822: l_td_needed_chr pay_legislation_rules.rule_mode%type;
7823: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
7824: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
7825: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
7826: l_org_needed_chr pay_legislation_rules.rule_mode%type;
7827: --

Line 7824: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

7820: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
7821: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
7822: l_td_needed_chr pay_legislation_rules.rule_mode%type;
7823: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
7824: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
7825: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
7826: l_org_needed_chr pay_legislation_rules.rule_mode%type;
7827: --
7828: begin

Line 7825: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

7821: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
7822: l_td_needed_chr pay_legislation_rules.rule_mode%type;
7823: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
7824: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
7825: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
7826: l_org_needed_chr pay_legislation_rules.rule_mode%type;
7827: --
7828: begin
7829: --

Line 7826: l_org_needed_chr pay_legislation_rules.rule_mode%type;

7822: l_td_needed_chr pay_legislation_rules.rule_mode%type;
7823: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
7824: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
7825: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
7826: l_org_needed_chr pay_legislation_rules.rule_mode%type;
7827: --
7828: begin
7829: --
7830: if g_debug then

Line 8243: l_tu_needed_chr pay_legislation_rules.rule_mode%type;

8239: where ppa.payroll_action_id = p_pact_id
8240: and pbg.business_group_id = ppa.business_group_id;
8241: --
8242: l_defbal_rec t_def_bal_rec;
8243: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8244: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8245: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8246: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8247: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

Line 8244: l_jc_needed_chr pay_legislation_rules.rule_mode%type;

8240: and pbg.business_group_id = ppa.business_group_id;
8241: --
8242: l_defbal_rec t_def_bal_rec;
8243: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8244: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8245: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8246: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8247: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8248: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

Line 8245: l_si_needed_chr pay_legislation_rules.rule_mode%type;

8241: --
8242: l_defbal_rec t_def_bal_rec;
8243: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8244: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8245: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8246: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8247: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8248: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8249: l_td_needed_chr pay_legislation_rules.rule_mode%type;

Line 8246: l_st_needed_chr pay_legislation_rules.rule_mode%type;

8242: l_defbal_rec t_def_bal_rec;
8243: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8244: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8245: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8246: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8247: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8248: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8249: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8250: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

Line 8247: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

8243: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8244: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8245: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8246: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8247: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8248: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8249: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8250: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8251: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

Line 8248: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

8244: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8245: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8246: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8247: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8248: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8249: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8250: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8251: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8252: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

Line 8249: l_td_needed_chr pay_legislation_rules.rule_mode%type;

8245: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8246: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8247: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8248: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8249: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8250: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8251: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8252: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8253: l_org_needed_chr pay_legislation_rules.rule_mode%type;

Line 8250: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

8246: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8247: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8248: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8249: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8250: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8251: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8252: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8253: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8254: l_context_lst t_context_tab;

Line 8251: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

8247: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8248: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8249: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8250: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8251: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8252: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8253: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8254: l_context_lst t_context_tab;
8255: l_cnt number;

Line 8252: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

8248: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8249: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8250: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8251: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8252: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8253: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8254: l_context_lst t_context_tab;
8255: l_cnt number;
8256: l_output_list t_detailed_bal_out_tab;

Line 8253: l_org_needed_chr pay_legislation_rules.rule_mode%type;

8249: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8250: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8251: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8252: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8253: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8254: l_context_lst t_context_tab;
8255: l_cnt number;
8256: l_output_list t_detailed_bal_out_tab;
8257: l_inp_val_name pay_input_values_f.name%type;

Line 8624: l_tu_needed_chr pay_legislation_rules.rule_mode%type;

8620: and ptp.end_date
8621: order by 1, 2, 3, 4;
8622: --
8623: l_defbal_rec t_def_bal_rec;
8624: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8625: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8626: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8627: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8628: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

Line 8625: l_jc_needed_chr pay_legislation_rules.rule_mode%type;

8621: order by 1, 2, 3, 4;
8622: --
8623: l_defbal_rec t_def_bal_rec;
8624: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8625: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8626: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8627: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8628: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8629: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

Line 8626: l_si_needed_chr pay_legislation_rules.rule_mode%type;

8622: --
8623: l_defbal_rec t_def_bal_rec;
8624: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8625: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8626: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8627: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8628: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8629: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8630: l_td_needed_chr pay_legislation_rules.rule_mode%type;

Line 8627: l_st_needed_chr pay_legislation_rules.rule_mode%type;

8623: l_defbal_rec t_def_bal_rec;
8624: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8625: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8626: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8627: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8628: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8629: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8630: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8631: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

Line 8628: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

8624: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8625: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8626: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8627: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8628: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8629: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8630: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8631: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8632: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

Line 8629: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

8625: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8626: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8627: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8628: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8629: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8630: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8631: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8632: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8633: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

Line 8630: l_td_needed_chr pay_legislation_rules.rule_mode%type;

8626: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8627: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8628: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8629: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8630: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8631: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8632: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8633: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8634: l_org_needed_chr pay_legislation_rules.rule_mode%type;

Line 8631: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

8627: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8628: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8629: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8630: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8631: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8632: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8633: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8634: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8635: --

Line 8632: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

8628: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8629: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8630: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8631: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8632: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8633: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8634: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8635: --
8636: begin

Line 8633: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

8629: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8630: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8631: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8632: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8633: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8634: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8635: --
8636: begin
8637: --

Line 8634: l_org_needed_chr pay_legislation_rules.rule_mode%type;

8630: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8631: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8632: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8633: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8634: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8635: --
8636: begin
8637: --
8638: if g_debug then

Line 9084: l_tu_needed_chr pay_legislation_rules.rule_mode%type;

9080: and paa.assignment_action_id = aaid
9081: and pbg.business_group_id = ppa.business_group_id;
9082: --
9083: l_defbal_rec t_def_bal_rec;
9084: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9085: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9086: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9087: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9088: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

Line 9085: l_jc_needed_chr pay_legislation_rules.rule_mode%type;

9081: and pbg.business_group_id = ppa.business_group_id;
9082: --
9083: l_defbal_rec t_def_bal_rec;
9084: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9085: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9086: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9087: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9088: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9089: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

Line 9086: l_si_needed_chr pay_legislation_rules.rule_mode%type;

9082: --
9083: l_defbal_rec t_def_bal_rec;
9084: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9085: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9086: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9087: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9088: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9089: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9090: l_td_needed_chr pay_legislation_rules.rule_mode%type;

Line 9087: l_st_needed_chr pay_legislation_rules.rule_mode%type;

9083: l_defbal_rec t_def_bal_rec;
9084: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9085: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9086: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9087: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9088: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9089: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9090: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9091: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

Line 9088: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

9084: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9085: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9086: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9087: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9088: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9089: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9090: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9091: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9092: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

Line 9089: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

9085: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9086: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9087: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9088: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9089: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9090: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9091: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9092: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9093: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

Line 9090: l_td_needed_chr pay_legislation_rules.rule_mode%type;

9086: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9087: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9088: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9089: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9090: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9091: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9092: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9093: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9094: l_org_needed_chr pay_legislation_rules.rule_mode%type;

Line 9091: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

9087: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9088: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9089: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9090: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9091: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9092: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9093: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9094: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9095: l_context_lst t_context_tab;

Line 9092: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

9088: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9089: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9090: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9091: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9092: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9093: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9094: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9095: l_context_lst t_context_tab;
9096: l_cnt number;

Line 9093: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

9089: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9090: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9091: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9092: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9093: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9094: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9095: l_context_lst t_context_tab;
9096: l_cnt number;
9097: l_output_list t_detailed_bal_out_tab;

Line 9094: l_org_needed_chr pay_legislation_rules.rule_mode%type;

9090: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9091: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9092: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9093: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9094: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9095: l_context_lst t_context_tab;
9096: l_cnt number;
9097: l_output_list t_detailed_bal_out_tab;
9098: l_inp_val_name pay_input_values_f.name%type;

Line 9460: save_run_bals pay_legislation_rules.rule_mode%type;

9456: (pdb.legislation_code is null
9457: and pdb.business_group_id is null)
9458: );
9459: --
9460: save_run_bals pay_legislation_rules.rule_mode%type;
9461: bal_ret_buffer_sz number;
9462: l_param_value pay_action_parameters.parameter_value%type;
9463: l_found boolean;
9464: l_balance_lst t_balance_value_tab;

Line 9494: from pay_legislation_rules plr,

9490: /* First get the legislation rule */
9491: begin
9492: select plr.rule_mode
9493: into save_run_bals
9494: from pay_legislation_rules plr,
9495: per_business_groups_perf pbg,
9496: pay_payroll_actions ppa,
9497: pay_assignment_actions paa
9498: where ppa.payroll_action_id = paa.payroll_action_id

Line 9907: save_run_bals pay_legislation_rules.rule_mode%type;

9903: (pdb.legislation_code is null
9904: and pdb.business_group_id is null)
9905: );
9906: --
9907: save_run_bals pay_legislation_rules.rule_mode%type;
9908: bal_ret_buffer_sz number;
9909: l_param_value pay_action_parameters.parameter_value%type;
9910: l_found boolean;
9911: l_balance_lst t_balance_value_tab;

Line 9940: from pay_legislation_rules plr,

9936: /* First get the legislation rule */
9937: begin
9938: select plr.rule_mode
9939: into save_run_bals
9940: from pay_legislation_rules plr,
9941: per_business_groups_perf pbg,
9942: pay_payroll_actions ppa
9943: where ppa.payroll_action_id = p_pact_id
9944: and ppa.business_group_id = pbg.business_group_id

Line 10057: , pay_legislation_rules plr

10053: ,p_dim_level in varchar2)
10054: is
10055: select pbg.business_group_id
10056: from per_business_groups_perf pbg
10057: , pay_legislation_rules plr
10058: where pbg.legislation_code = plr.legislation_code
10059: and plr.legislation_code = nvl(p_leg_code, plr.legislation_code)
10060: and pbg.business_group_id = nvl(p_bg_id, pbg.business_group_id)
10061: and plr.rule_type = decode(p_dim_level, 'ASG', 'SAVE_ASG_RUN_BAL'

Line 10323: l_rule_mode pay_legislation_rules.rule_mode%type;

10319: where paa.assignment_action_id = revassactid
10320: and ppa.payroll_action_id = paa.payroll_action_id
10321: and paa.assignment_action_id = prr.assignment_action_id;
10322: --
10323: l_rule_mode pay_legislation_rules.rule_mode%type;
10324: l_si_needed pay_legislation_rules.rule_mode%type;
10325: l_st_needed pay_legislation_rules.rule_mode%type;
10326: l_sn_needed pay_legislation_rules.rule_mode%type;
10327: l_sn2_needed pay_legislation_rules.rule_mode%type;

Line 10324: l_si_needed pay_legislation_rules.rule_mode%type;

10320: and ppa.payroll_action_id = paa.payroll_action_id
10321: and paa.assignment_action_id = prr.assignment_action_id;
10322: --
10323: l_rule_mode pay_legislation_rules.rule_mode%type;
10324: l_si_needed pay_legislation_rules.rule_mode%type;
10325: l_st_needed pay_legislation_rules.rule_mode%type;
10326: l_sn_needed pay_legislation_rules.rule_mode%type;
10327: l_sn2_needed pay_legislation_rules.rule_mode%type;
10328: l_org_needed pay_legislation_rules.rule_mode%type;

Line 10325: l_st_needed pay_legislation_rules.rule_mode%type;

10321: and paa.assignment_action_id = prr.assignment_action_id;
10322: --
10323: l_rule_mode pay_legislation_rules.rule_mode%type;
10324: l_si_needed pay_legislation_rules.rule_mode%type;
10325: l_st_needed pay_legislation_rules.rule_mode%type;
10326: l_sn_needed pay_legislation_rules.rule_mode%type;
10327: l_sn2_needed pay_legislation_rules.rule_mode%type;
10328: l_org_needed pay_legislation_rules.rule_mode%type;
10329: l_st2_needed pay_legislation_rules.rule_mode%type;

Line 10326: l_sn_needed pay_legislation_rules.rule_mode%type;

10322: --
10323: l_rule_mode pay_legislation_rules.rule_mode%type;
10324: l_si_needed pay_legislation_rules.rule_mode%type;
10325: l_st_needed pay_legislation_rules.rule_mode%type;
10326: l_sn_needed pay_legislation_rules.rule_mode%type;
10327: l_sn2_needed pay_legislation_rules.rule_mode%type;
10328: l_org_needed pay_legislation_rules.rule_mode%type;
10329: l_st2_needed pay_legislation_rules.rule_mode%type;
10330: l_inp_val_name pay_input_values_f.name%type;

Line 10327: l_sn2_needed pay_legislation_rules.rule_mode%type;

10323: l_rule_mode pay_legislation_rules.rule_mode%type;
10324: l_si_needed pay_legislation_rules.rule_mode%type;
10325: l_st_needed pay_legislation_rules.rule_mode%type;
10326: l_sn_needed pay_legislation_rules.rule_mode%type;
10327: l_sn2_needed pay_legislation_rules.rule_mode%type;
10328: l_org_needed pay_legislation_rules.rule_mode%type;
10329: l_st2_needed pay_legislation_rules.rule_mode%type;
10330: l_inp_val_name pay_input_values_f.name%type;
10331: l_asg_id number;

Line 10328: l_org_needed pay_legislation_rules.rule_mode%type;

10324: l_si_needed pay_legislation_rules.rule_mode%type;
10325: l_st_needed pay_legislation_rules.rule_mode%type;
10326: l_sn_needed pay_legislation_rules.rule_mode%type;
10327: l_sn2_needed pay_legislation_rules.rule_mode%type;
10328: l_org_needed pay_legislation_rules.rule_mode%type;
10329: l_st2_needed pay_legislation_rules.rule_mode%type;
10330: l_inp_val_name pay_input_values_f.name%type;
10331: l_asg_id number;
10332: l_pactid number;

Line 10329: l_st2_needed pay_legislation_rules.rule_mode%type;

10325: l_st_needed pay_legislation_rules.rule_mode%type;
10326: l_sn_needed pay_legislation_rules.rule_mode%type;
10327: l_sn2_needed pay_legislation_rules.rule_mode%type;
10328: l_org_needed pay_legislation_rules.rule_mode%type;
10329: l_st2_needed pay_legislation_rules.rule_mode%type;
10330: l_inp_val_name pay_input_values_f.name%type;
10331: l_asg_id number;
10332: l_pactid number;
10333: l_eff_date date;

Line 10427: from pay_legislation_rules plr,

10423: if lat_bal_maintenance = TRUE then
10424: begin
10425: select rule_mode, pbg.legislation_code
10426: into l_rule_mode, leg_code
10427: from pay_legislation_rules plr,
10428: per_business_groups_perf pbg
10429: where plr.legislation_code = pbg.legislation_code
10430: and rule_type = 'BAL_ADJ_LAT_BAL'
10431: and pbg.business_group_id = l_bus_grp;