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 393: pay_balance_pkg.get_value ( month_year_action_rec.assact_id,

389: -----------------------------------------
390: -- Batch Balance Retrival
391: -----------------------------------------
392: --
393: pay_balance_pkg.get_value ( month_year_action_rec.assact_id,
394: g_balance_value_tab,
395: g_context_tab,
396: false,
397: false,

Line 483: pay_balance_pkg.get_value ( month_year_action_rec.assact_id,

479: -----------------------------------------
480: -- Batch Balance Retrival
481: -----------------------------------------
482: --
483: pay_balance_pkg.get_value ( month_year_action_rec.assact_id,
484: g_balance_value_tab,
485: g_context_tab,
486: false,
487: false,

Line 621: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

617: from ff_globals_f
618: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
619: and c_date_earned between effective_start_date and effective_end_date;
620: --
621: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
622: g_context_tab pay_balance_pkg.t_context_tab;
623: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
624: --
625: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 622: g_context_tab pay_balance_pkg.t_context_tab;

618: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
619: and c_date_earned between effective_start_date and effective_end_date;
620: --
621: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
622: g_context_tab pay_balance_pkg.t_context_tab;
623: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
624: --
625: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
626: l_action_sequence pay_assignment_actions.action_sequence%TYPE;

Line 623: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

619: and c_date_earned between effective_start_date and effective_end_date;
620: --
621: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
622: g_context_tab pay_balance_pkg.t_context_tab;
623: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
624: --
625: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
626: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
627: l_month number;

Line 677: pay_balance_pkg.get_value ( l_assignment_action_id,

673: g_context_tab(1).tax_unit_id := g_pact.legal_entity_id;
674: g_context_tab(2).tax_unit_id := g_pact.legal_entity_id;
675: g_context_tab(3).tax_unit_id := g_pact.legal_entity_id;
676: --
677: pay_balance_pkg.get_value ( l_assignment_action_id,
678: g_balance_value_tab,
679: g_context_tab,
680: false,
681: false,