APPS.PAY_SG_AWCAP_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 225: -- Tables for pay_balance_pkg

221: --
222: l_assignment_id per_all_assignments_f.assignment_id%type;
223: l_payroll_id pay_payroll_actions.payroll_action_id%type ;
224: --------------------------
225: -- Tables for pay_balance_pkg
226: --------------------------
227: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
228: g_context_tab pay_balance_pkg.t_context_tab;
229: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

Line 227: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

223: l_payroll_id pay_payroll_actions.payroll_action_id%type ;
224: --------------------------
225: -- Tables for pay_balance_pkg
226: --------------------------
227: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
228: g_context_tab pay_balance_pkg.t_context_tab;
229: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
230: --
231: l_asg_act_id pay_assignment_actions.assignment_action_id%type;

Line 228: g_context_tab pay_balance_pkg.t_context_tab;

224: --------------------------
225: -- Tables for pay_balance_pkg
226: --------------------------
227: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
228: g_context_tab pay_balance_pkg.t_context_tab;
229: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
230: --
231: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
232: l_person_id per_all_people_f.person_id%type;

Line 229: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

225: -- Tables for pay_balance_pkg
226: --------------------------
227: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
228: g_context_tab pay_balance_pkg.t_context_tab;
229: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
230: --
231: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
232: l_person_id per_all_people_f.person_id%type;
233: l_cpf_tot_earn_cap_amt ff_globals_f.global_value%type;

Line 396: pay_balance_pkg.get_value ( month_year_action_rec.assact_id,

392: -----------------------------------------
393: -- Batch Balance Retrival
394: -----------------------------------------
395: --
396: pay_balance_pkg.get_value ( month_year_action_rec.assact_id,
397: g_balance_value_tab,
398: g_context_tab,
399: false,
400: false,

Line 486: pay_balance_pkg.get_value ( month_year_action_rec.assact_id,

482: -----------------------------------------
483: -- Batch Balance Retrival
484: -----------------------------------------
485: --
486: pay_balance_pkg.get_value ( month_year_action_rec.assact_id,
487: g_balance_value_tab,
488: g_context_tab,
489: false,
490: false,

Line 625: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

621: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
622: and p_date between effective_start_date and effective_end_date;
623:
624: --
625: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
626: g_context_tab pay_balance_pkg.t_context_tab;
627: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
628: --
629: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 626: g_context_tab pay_balance_pkg.t_context_tab;

622: and p_date between effective_start_date and effective_end_date;
623:
624: --
625: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
626: g_context_tab pay_balance_pkg.t_context_tab;
627: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
628: --
629: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
630: l_action_sequence pay_assignment_actions.action_sequence%TYPE;

Line 627: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

623:
624: --
625: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
626: g_context_tab pay_balance_pkg.t_context_tab;
627: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
628: --
629: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
630: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
631: l_month number;

Line 702: pay_balance_pkg.get_value ( l_assignment_action_id,

698: fetch c_globals into l_ord_mon_cap_amt, l_ord_mon_cap_amt_tmp_date;
699: close c_globals;
700: end if;
701:
702: pay_balance_pkg.get_value ( l_assignment_action_id,
703: g_balance_value_tab,
704: g_context_tab,
705: false,
706: false,