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 323: g_si_needed_chr pay_legislation_rules.rule_mode%type;

319: g_rlb_grp_defbals t_balance_value_tab;
320: g_rlb_asg_defbals t_balance_value_tab;
321: g_grp_maintained_rb t_int_rb_cache;
322: g_grp_rb_ptr_list number_array;
323: g_si_needed_chr pay_legislation_rules.rule_mode%type;
324: g_st_needed_chr pay_legislation_rules.rule_mode%type;
325: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
326: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
327: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;

Line 324: g_st_needed_chr pay_legislation_rules.rule_mode%type;

320: g_rlb_asg_defbals t_balance_value_tab;
321: g_grp_maintained_rb t_int_rb_cache;
322: g_grp_rb_ptr_list number_array;
323: g_si_needed_chr pay_legislation_rules.rule_mode%type;
324: g_st_needed_chr pay_legislation_rules.rule_mode%type;
325: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
326: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
327: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;
328: g_org_needed_chr pay_legislation_rules.rule_mode%type;

Line 325: g_sn_needed_chr pay_legislation_rules.rule_mode%type;

321: g_grp_maintained_rb t_int_rb_cache;
322: g_grp_rb_ptr_list number_array;
323: g_si_needed_chr pay_legislation_rules.rule_mode%type;
324: g_st_needed_chr pay_legislation_rules.rule_mode%type;
325: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
326: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
327: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;
328: g_org_needed_chr pay_legislation_rules.rule_mode%type;
329: g_save_run_bals pay_legislation_rules.rule_mode%type;

Line 326: g_st2_needed_chr pay_legislation_rules.rule_mode%type;

322: g_grp_rb_ptr_list number_array;
323: g_si_needed_chr pay_legislation_rules.rule_mode%type;
324: g_st_needed_chr pay_legislation_rules.rule_mode%type;
325: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
326: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
327: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;
328: g_org_needed_chr pay_legislation_rules.rule_mode%type;
329: g_save_run_bals pay_legislation_rules.rule_mode%type;
330: --

Line 327: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;

323: g_si_needed_chr pay_legislation_rules.rule_mode%type;
324: g_st_needed_chr pay_legislation_rules.rule_mode%type;
325: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
326: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
327: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;
328: g_org_needed_chr pay_legislation_rules.rule_mode%type;
329: g_save_run_bals pay_legislation_rules.rule_mode%type;
330: --
331: -- The following globals are used in get_rb_status

Line 328: g_org_needed_chr pay_legislation_rules.rule_mode%type;

324: g_st_needed_chr pay_legislation_rules.rule_mode%type;
325: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
326: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
327: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;
328: g_org_needed_chr pay_legislation_rules.rule_mode%type;
329: g_save_run_bals pay_legislation_rules.rule_mode%type;
330: --
331: -- The following globals are used in get_rb_status
332: g_aa_id NUMBER := NULL;

Line 329: g_save_run_bals pay_legislation_rules.rule_mode%type;

325: g_sn_needed_chr pay_legislation_rules.rule_mode%type;
326: g_st2_needed_chr pay_legislation_rules.rule_mode%type;
327: g_sn2_needed_chr pay_legislation_rules.rule_mode%type;
328: g_org_needed_chr pay_legislation_rules.rule_mode%type;
329: g_save_run_bals pay_legislation_rules.rule_mode%type;
330: --
331: -- The following globals are used in get_rb_status
332: g_aa_id NUMBER := NULL;
333: g_retrieval_date pay_payroll_actions.effective_date%type := NULL;

Line 7129: from pay_legislation_rules plr,

7125: /* First get the legislation rule */
7126: begin
7127: select plr.rule_mode
7128: into g_save_run_bals
7129: from pay_legislation_rules plr,
7130: per_business_groups_perf pbg,
7131: pay_payroll_actions ppa
7132: where ppa.payroll_action_id = p_payroll_action_id
7133: and ppa.business_group_id = pbg.business_group_id

Line 8402: l_tu_needed_chr pay_legislation_rules.rule_mode%type;

8398: order by 1, 2, 3, 4;
8399:
8400: --
8401: l_defbal_rec t_def_bal_rec;
8402: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8403: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8404: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8405: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8406: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

Line 8403: l_jc_needed_chr pay_legislation_rules.rule_mode%type;

8399:
8400: --
8401: l_defbal_rec t_def_bal_rec;
8402: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8403: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8404: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8405: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8406: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8407: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

Line 8404: l_si_needed_chr pay_legislation_rules.rule_mode%type;

8400: --
8401: l_defbal_rec t_def_bal_rec;
8402: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8403: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8404: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8405: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8406: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8407: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8408: l_td_needed_chr pay_legislation_rules.rule_mode%type;

Line 8405: l_st_needed_chr pay_legislation_rules.rule_mode%type;

8401: l_defbal_rec t_def_bal_rec;
8402: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8403: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8404: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8405: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8406: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8407: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8408: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8409: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

Line 8406: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

8402: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8403: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8404: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8405: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8406: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8407: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8408: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8409: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8410: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

Line 8407: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

8403: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8404: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8405: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8406: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8407: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8408: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8409: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8410: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8411: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

Line 8408: l_td_needed_chr pay_legislation_rules.rule_mode%type;

8404: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8405: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8406: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8407: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8408: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8409: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8410: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8411: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8412: l_org_needed_chr pay_legislation_rules.rule_mode%type;

Line 8409: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

8405: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8406: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8407: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8408: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8409: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8410: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8411: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8412: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8413: l_earned_period_end_date per_time_periods.end_date%type;

Line 8410: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

8406: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8407: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8408: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8409: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8410: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8411: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8412: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8413: l_earned_period_end_date per_time_periods.end_date%type;
8414: --

Line 8411: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

8407: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8408: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8409: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8410: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8411: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8412: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8413: l_earned_period_end_date per_time_periods.end_date%type;
8414: --
8415: begin

Line 8412: l_org_needed_chr pay_legislation_rules.rule_mode%type;

8408: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8409: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8410: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8411: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8412: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8413: l_earned_period_end_date per_time_periods.end_date%type;
8414: --
8415: begin
8416: --

Line 8844: l_tu_needed_chr pay_legislation_rules.rule_mode%type;

8840: where ppa.payroll_action_id = p_pact_id
8841: and pbg.business_group_id = ppa.business_group_id;
8842: --
8843: l_defbal_rec t_def_bal_rec;
8844: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8845: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8846: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8847: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8848: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

Line 8845: l_jc_needed_chr pay_legislation_rules.rule_mode%type;

8841: and pbg.business_group_id = ppa.business_group_id;
8842: --
8843: l_defbal_rec t_def_bal_rec;
8844: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8845: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8846: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8847: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8848: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8849: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

Line 8846: l_si_needed_chr pay_legislation_rules.rule_mode%type;

8842: --
8843: l_defbal_rec t_def_bal_rec;
8844: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8845: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8846: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8847: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8848: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8849: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8850: l_td_needed_chr pay_legislation_rules.rule_mode%type;

Line 8847: l_st_needed_chr pay_legislation_rules.rule_mode%type;

8843: l_defbal_rec t_def_bal_rec;
8844: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8845: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8846: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8847: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8848: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8849: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8850: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8851: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

Line 8848: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

8844: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
8845: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8846: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8847: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8848: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8849: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8850: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8851: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8852: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

Line 8849: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

8845: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
8846: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8847: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8848: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8849: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8850: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8851: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8852: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8853: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

Line 8850: l_td_needed_chr pay_legislation_rules.rule_mode%type;

8846: l_si_needed_chr pay_legislation_rules.rule_mode%type;
8847: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8848: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8849: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8850: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8851: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8852: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8853: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8854: l_org_needed_chr pay_legislation_rules.rule_mode%type;

Line 8851: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

8847: l_st_needed_chr pay_legislation_rules.rule_mode%type;
8848: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8849: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8850: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8851: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8852: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8853: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8854: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8855: l_context_lst t_context_tab;

Line 8852: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

8848: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
8849: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8850: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8851: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8852: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8853: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8854: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8855: l_context_lst t_context_tab;
8856: l_cnt number;

Line 8853: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

8849: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
8850: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8851: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8852: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8853: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8854: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8855: l_context_lst t_context_tab;
8856: l_cnt number;
8857: l_output_list t_detailed_bal_out_tab;

Line 8854: l_org_needed_chr pay_legislation_rules.rule_mode%type;

8850: l_td_needed_chr pay_legislation_rules.rule_mode%type;
8851: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
8852: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
8853: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
8854: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8855: l_context_lst t_context_tab;
8856: l_cnt number;
8857: l_output_list t_detailed_bal_out_tab;
8858: l_inp_val_name pay_input_values_f.name%type;

Line 9276: l_tu_needed_chr pay_legislation_rules.rule_mode%type;

9272: and ppa.payroll_action_id = paa.payroll_action_id
9273: order by 1, 2, 3, 4;
9274: --
9275: l_defbal_rec t_def_bal_rec;
9276: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9277: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9278: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9279: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9280: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

Line 9277: l_jc_needed_chr pay_legislation_rules.rule_mode%type;

9273: order by 1, 2, 3, 4;
9274: --
9275: l_defbal_rec t_def_bal_rec;
9276: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9277: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9278: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9279: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9280: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9281: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

Line 9278: l_si_needed_chr pay_legislation_rules.rule_mode%type;

9274: --
9275: l_defbal_rec t_def_bal_rec;
9276: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9277: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9278: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9279: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9280: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9281: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9282: l_td_needed_chr pay_legislation_rules.rule_mode%type;

Line 9279: l_st_needed_chr pay_legislation_rules.rule_mode%type;

9275: l_defbal_rec t_def_bal_rec;
9276: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9277: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9278: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9279: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9280: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9281: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9282: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9283: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

Line 9280: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

9276: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9277: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9278: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9279: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9280: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9281: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9282: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9283: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9284: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

Line 9281: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

9277: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9278: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9279: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9280: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9281: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9282: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9283: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9284: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9285: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

Line 9282: l_td_needed_chr pay_legislation_rules.rule_mode%type;

9278: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9279: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9280: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9281: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9282: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9283: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9284: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9285: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9286: l_org_needed_chr pay_legislation_rules.rule_mode%type;

Line 9283: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

9279: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9280: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9281: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9282: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9283: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9284: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9285: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9286: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9287: l_earned_period_end_date per_time_periods.end_date%type;

Line 9284: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

9280: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9281: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9282: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9283: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9284: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9285: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9286: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9287: l_earned_period_end_date per_time_periods.end_date%type;
9288: --

Line 9285: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

9281: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9282: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9283: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9284: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9285: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9286: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9287: l_earned_period_end_date per_time_periods.end_date%type;
9288: --
9289: begin

Line 9286: l_org_needed_chr pay_legislation_rules.rule_mode%type;

9282: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9283: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9284: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9285: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9286: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9287: l_earned_period_end_date per_time_periods.end_date%type;
9288: --
9289: begin
9290: --

Line 9751: l_tu_needed_chr pay_legislation_rules.rule_mode%type;

9747: and paa.assignment_action_id = aaid
9748: and pbg.business_group_id = ppa.business_group_id;
9749: --
9750: l_defbal_rec t_def_bal_rec;
9751: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9752: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9753: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9754: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9755: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

Line 9752: l_jc_needed_chr pay_legislation_rules.rule_mode%type;

9748: and pbg.business_group_id = ppa.business_group_id;
9749: --
9750: l_defbal_rec t_def_bal_rec;
9751: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9752: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9753: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9754: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9755: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9756: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

Line 9753: l_si_needed_chr pay_legislation_rules.rule_mode%type;

9749: --
9750: l_defbal_rec t_def_bal_rec;
9751: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9752: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9753: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9754: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9755: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9756: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9757: l_td_needed_chr pay_legislation_rules.rule_mode%type;

Line 9754: l_st_needed_chr pay_legislation_rules.rule_mode%type;

9750: l_defbal_rec t_def_bal_rec;
9751: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9752: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9753: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9754: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9755: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9756: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9757: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9758: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

Line 9755: l_sn_needed_chr pay_legislation_rules.rule_mode%type;

9751: l_tu_needed_chr pay_legislation_rules.rule_mode%type;
9752: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9753: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9754: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9755: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9756: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9757: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9758: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9759: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

Line 9756: l_st2_needed_chr pay_legislation_rules.rule_mode%type;

9752: l_jc_needed_chr pay_legislation_rules.rule_mode%type;
9753: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9754: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9755: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9756: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9757: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9758: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9759: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9760: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

Line 9757: l_td_needed_chr pay_legislation_rules.rule_mode%type;

9753: l_si_needed_chr pay_legislation_rules.rule_mode%type;
9754: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9755: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9756: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9757: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9758: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9759: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9760: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9761: l_org_needed_chr pay_legislation_rules.rule_mode%type;

Line 9758: l_bd_needed_chr pay_legislation_rules.rule_mode%type;

9754: l_st_needed_chr pay_legislation_rules.rule_mode%type;
9755: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9756: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9757: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9758: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9759: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9760: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9761: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9762: l_context_lst t_context_tab;

Line 9759: l_lu_needed_chr pay_legislation_rules.rule_mode%type;

9755: l_sn_needed_chr pay_legislation_rules.rule_mode%type;
9756: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9757: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9758: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9759: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9760: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9761: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9762: l_context_lst t_context_tab;
9763: l_cnt number;

Line 9760: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;

9756: l_st2_needed_chr pay_legislation_rules.rule_mode%type;
9757: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9758: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9759: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9760: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9761: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9762: l_context_lst t_context_tab;
9763: l_cnt number;
9764: l_output_list t_detailed_bal_out_tab;

Line 9761: l_org_needed_chr pay_legislation_rules.rule_mode%type;

9757: l_td_needed_chr pay_legislation_rules.rule_mode%type;
9758: l_bd_needed_chr pay_legislation_rules.rule_mode%type;
9759: l_lu_needed_chr pay_legislation_rules.rule_mode%type;
9760: l_sn2_needed_chr pay_legislation_rules.rule_mode%type;
9761: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9762: l_context_lst t_context_tab;
9763: l_cnt number;
9764: l_output_list t_detailed_bal_out_tab;
9765: l_inp_val_name pay_input_values_f.name%type;

Line 10167: save_run_bals pay_legislation_rules.rule_mode%type;

10163: (pdb.legislation_code is null
10164: and pdb.business_group_id is null)
10165: );
10166: --
10167: save_run_bals pay_legislation_rules.rule_mode%type;
10168: bal_ret_buffer_sz number;
10169: l_param_value pay_action_parameters.parameter_value%type;
10170: l_found boolean;
10171: l_balance_lst t_balance_value_tab;

Line 10201: from pay_legislation_rules plr,

10197: /* First get the legislation rule */
10198: begin
10199: select plr.rule_mode
10200: into save_run_bals
10201: from pay_legislation_rules plr,
10202: per_business_groups_perf pbg,
10203: pay_payroll_actions ppa,
10204: pay_assignment_actions paa
10205: where ppa.payroll_action_id = paa.payroll_action_id

Line 10628: save_run_bals pay_legislation_rules.rule_mode%type;

10624: (pdb.legislation_code is null
10625: and pdb.business_group_id is null)
10626: );
10627: --
10628: save_run_bals pay_legislation_rules.rule_mode%type;
10629: bal_ret_buffer_sz number;
10630: l_param_value pay_action_parameters.parameter_value%type;
10631: l_found boolean;
10632: l_balance_lst t_balance_value_tab;

Line 10661: from pay_legislation_rules plr,

10657: /* First get the legislation rule */
10658: begin
10659: select plr.rule_mode
10660: into save_run_bals
10661: from pay_legislation_rules plr,
10662: per_business_groups_perf pbg,
10663: pay_payroll_actions ppa
10664: where ppa.payroll_action_id = p_pact_id
10665: and ppa.business_group_id = pbg.business_group_id

Line 10778: , pay_legislation_rules plr

10774: ,p_dim_level in varchar2)
10775: is
10776: select pbg.business_group_id
10777: from per_business_groups_perf pbg
10778: , pay_legislation_rules plr
10779: where pbg.legislation_code = plr.legislation_code
10780: and plr.legislation_code = nvl(p_leg_code, plr.legislation_code)
10781: and pbg.business_group_id = nvl(p_bg_id, pbg.business_group_id)
10782: and plr.rule_type = decode(p_dim_level, 'ASG', 'SAVE_ASG_RUN_BAL'

Line 11044: l_rule_mode pay_legislation_rules.rule_mode%type;

11040: where paa.assignment_action_id = revassactid
11041: and ppa.payroll_action_id = paa.payroll_action_id
11042: and paa.assignment_action_id = prr.assignment_action_id;
11043: --
11044: l_rule_mode pay_legislation_rules.rule_mode%type;
11045: l_si_needed pay_legislation_rules.rule_mode%type;
11046: l_st_needed pay_legislation_rules.rule_mode%type;
11047: l_sn_needed pay_legislation_rules.rule_mode%type;
11048: l_sn2_needed pay_legislation_rules.rule_mode%type;

Line 11045: l_si_needed pay_legislation_rules.rule_mode%type;

11041: and ppa.payroll_action_id = paa.payroll_action_id
11042: and paa.assignment_action_id = prr.assignment_action_id;
11043: --
11044: l_rule_mode pay_legislation_rules.rule_mode%type;
11045: l_si_needed pay_legislation_rules.rule_mode%type;
11046: l_st_needed pay_legislation_rules.rule_mode%type;
11047: l_sn_needed pay_legislation_rules.rule_mode%type;
11048: l_sn2_needed pay_legislation_rules.rule_mode%type;
11049: l_org_needed pay_legislation_rules.rule_mode%type;

Line 11046: l_st_needed pay_legislation_rules.rule_mode%type;

11042: and paa.assignment_action_id = prr.assignment_action_id;
11043: --
11044: l_rule_mode pay_legislation_rules.rule_mode%type;
11045: l_si_needed pay_legislation_rules.rule_mode%type;
11046: l_st_needed pay_legislation_rules.rule_mode%type;
11047: l_sn_needed pay_legislation_rules.rule_mode%type;
11048: l_sn2_needed pay_legislation_rules.rule_mode%type;
11049: l_org_needed pay_legislation_rules.rule_mode%type;
11050: l_st2_needed pay_legislation_rules.rule_mode%type;

Line 11047: l_sn_needed pay_legislation_rules.rule_mode%type;

11043: --
11044: l_rule_mode pay_legislation_rules.rule_mode%type;
11045: l_si_needed pay_legislation_rules.rule_mode%type;
11046: l_st_needed pay_legislation_rules.rule_mode%type;
11047: l_sn_needed pay_legislation_rules.rule_mode%type;
11048: l_sn2_needed pay_legislation_rules.rule_mode%type;
11049: l_org_needed pay_legislation_rules.rule_mode%type;
11050: l_st2_needed pay_legislation_rules.rule_mode%type;
11051: l_inp_val_name pay_input_values_f.name%type;

Line 11048: l_sn2_needed pay_legislation_rules.rule_mode%type;

11044: l_rule_mode pay_legislation_rules.rule_mode%type;
11045: l_si_needed pay_legislation_rules.rule_mode%type;
11046: l_st_needed pay_legislation_rules.rule_mode%type;
11047: l_sn_needed pay_legislation_rules.rule_mode%type;
11048: l_sn2_needed pay_legislation_rules.rule_mode%type;
11049: l_org_needed pay_legislation_rules.rule_mode%type;
11050: l_st2_needed pay_legislation_rules.rule_mode%type;
11051: l_inp_val_name pay_input_values_f.name%type;
11052: l_asg_id number;

Line 11049: l_org_needed pay_legislation_rules.rule_mode%type;

11045: l_si_needed pay_legislation_rules.rule_mode%type;
11046: l_st_needed pay_legislation_rules.rule_mode%type;
11047: l_sn_needed pay_legislation_rules.rule_mode%type;
11048: l_sn2_needed pay_legislation_rules.rule_mode%type;
11049: l_org_needed pay_legislation_rules.rule_mode%type;
11050: l_st2_needed pay_legislation_rules.rule_mode%type;
11051: l_inp_val_name pay_input_values_f.name%type;
11052: l_asg_id number;
11053: l_pactid number;

Line 11050: l_st2_needed pay_legislation_rules.rule_mode%type;

11046: l_st_needed pay_legislation_rules.rule_mode%type;
11047: l_sn_needed pay_legislation_rules.rule_mode%type;
11048: l_sn2_needed pay_legislation_rules.rule_mode%type;
11049: l_org_needed pay_legislation_rules.rule_mode%type;
11050: l_st2_needed pay_legislation_rules.rule_mode%type;
11051: l_inp_val_name pay_input_values_f.name%type;
11052: l_asg_id number;
11053: l_pactid number;
11054: l_eff_date date;

Line 11150: from pay_legislation_rules plr,

11146: if lat_bal_maintenance = TRUE then
11147: begin
11148: select rule_mode, pbg.legislation_code
11149: into l_rule_mode, leg_code
11150: from pay_legislation_rules plr,
11151: per_business_groups_perf pbg
11152: where plr.legislation_code = pbg.legislation_code
11153: and rule_type = 'BAL_ADJ_LAT_BAL'
11154: and pbg.business_group_id = l_bus_grp;