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_SG_IRAS_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 593: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;

589: p_assct_id in pay_assignment_actions.assignment_action_id%type,
590: p_tax_uid in pay_assignment_actions.tax_unit_id%type,
591: p_person_counter in number )
592: is
593: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
594: l_context_tab pay_balance_pkg.t_context_tab;
595: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
596:
597: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

Line 594: l_context_tab pay_balance_pkg.t_context_tab;

590: p_tax_uid in pay_assignment_actions.tax_unit_id%type,
591: p_person_counter in number )
592: is
593: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
594: l_context_tab pay_balance_pkg.t_context_tab;
595: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
596:
597: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
598: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 595: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

591: p_person_counter in number )
592: is
593: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
594: l_context_tab pay_balance_pkg.t_context_tab;
595: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
596:
597: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
598: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
599:

Line 597: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

593: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
594: l_context_tab pay_balance_pkg.t_context_tab;
595: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
596:
597: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
598: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
599:
600: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
601: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;

Line 598: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;

594: l_context_tab pay_balance_pkg.t_context_tab;
595: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
596:
597: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
598: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
599:
600: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
601: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
602:

Line 600: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;

596:
597: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
598: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
599:
600: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
601: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
602:
603: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
604: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;

Line 601: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;

597: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
598: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
599:
600: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
601: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
602:
603: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
604: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
605:

Line 603: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;

599:
600: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
601: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
602:
603: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
604: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
605:
606: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
607: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;

Line 604: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;

600: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
601: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
602:
603: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
604: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
605:
606: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
607: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
608:

Line 606: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;

602:
603: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
604: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
605:
606: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
607: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
608:
609: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;
610: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;

Line 607: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;

603: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
604: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
605:
606: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
607: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
608:
609: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;
610: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;
611:

Line 609: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;

605:
606: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
607: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
608:
609: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;
610: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;
611:
612: l_ytd_a8a_counter number;
613: --

Line 610: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;

606: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
607: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
608:
609: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;
610: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;
611:
612: l_ytd_a8a_counter number;
613: --
614: cursor ytd_A8A_balances is

Line 779: pay_balance_pkg.get_value( p_assct_id,

775: end loop;
776:
777: --
778: if p_assct_id is not null then
779: pay_balance_pkg.get_value( p_assct_id,
780: l_balance_value_tab1,
781: l_context_tab,
782: false,
783: false,

Line 785: pay_balance_pkg.get_value( p_assct_id,

781: l_context_tab,
782: false,
783: false,
784: l_detailed_bal_out_tab1);
785: pay_balance_pkg.get_value( p_assct_id,
786: l_balance_value_tab2,
787: l_context_tab,
788: false,
789: false,

Line 791: pay_balance_pkg.get_value( p_assct_id,

787: l_context_tab,
788: false,
789: false,
790: l_detailed_bal_out_tab2);
791: pay_balance_pkg.get_value( p_assct_id,
792: l_balance_value_tab3,
793: l_context_tab,
794: false,
795: false,

Line 797: pay_balance_pkg.get_value( p_assct_id,

793: l_context_tab,
794: false,
795: false,
796: l_detailed_bal_out_tab3);
797: pay_balance_pkg.get_value( p_assct_id,
798: l_balance_value_tab4,
799: l_context_tab,
800: false,
801: false,

Line 803: pay_balance_pkg.get_value( p_assct_id,

799: l_context_tab,
800: false,
801: false,
802: l_detailed_bal_out_tab4);
803: pay_balance_pkg.get_value( p_assct_id,
804: l_balance_value_tab5,
805: l_context_tab,
806: false,
807: false,

Line 1053: -- that to pay_balance_pkg.

1049: ---------------------------------------------------------------------------
1050: -- Selects data required to archive the YTD and Month balances. The
1051: -- cursors' main purpose is to select the latest action sequence for the
1052: -- PERSON (independent of assignment) within the Legal Entity, and pass
1053: -- that to pay_balance_pkg.
1054: -- Also the User Entity Name must match up to the balance.
1055: --
1056: -- YTD Balances: All IRAS balances + specific previously seeded balances
1057: -- Month Balances: Specific balances required for IR8S as this breaks down

Line 1229: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1225: mtd_balance_rec mtd_balance_tab;
1226: ---------------------------------------------------------------------------------------------------
1227: -- Bug 3064282 Batch Balance fetch implemented
1228: ---------------------------------------------------------------------------------------------------
1229: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1230: g_context_tab pay_balance_pkg.t_context_tab;
1231: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1232:
1233: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

Line 1230: g_context_tab pay_balance_pkg.t_context_tab;

1226: ---------------------------------------------------------------------------------------------------
1227: -- Bug 3064282 Batch Balance fetch implemented
1228: ---------------------------------------------------------------------------------------------------
1229: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1230: g_context_tab pay_balance_pkg.t_context_tab;
1231: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1232:
1233: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1234: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1231: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

1227: -- Bug 3064282 Batch Balance fetch implemented
1228: ---------------------------------------------------------------------------------------------------
1229: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1230: g_context_tab pay_balance_pkg.t_context_tab;
1231: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1232:
1233: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1234: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1235:

Line 1233: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

1229: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1230: g_context_tab pay_balance_pkg.t_context_tab;
1231: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1232:
1233: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1234: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1235:
1236: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1237: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1234: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;

1230: g_context_tab pay_balance_pkg.t_context_tab;
1231: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1232:
1233: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1234: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1235:
1236: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1237: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1238: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;

Line 1236: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;

1232:
1233: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1234: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1235:
1236: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1237: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1238: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1239: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1240: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;

Line 1237: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;

1233: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1234: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1235:
1236: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1237: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1238: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1239: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1240: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1241: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1238: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;

1234: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1235:
1236: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1237: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1238: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1239: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1240: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1241: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
1242: ---------------------------------------------------------------------------------------------------

Line 1239: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;

1235:
1236: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1237: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1238: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1239: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1240: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1241: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
1242: ---------------------------------------------------------------------------------------------------
1243: -- Type to store the person ids with same national_identifier (Bug 2649107)

Line 1240: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;

1236: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1237: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1238: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1239: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1240: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1241: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
1242: ---------------------------------------------------------------------------------------------------
1243: -- Type to store the person ids with same national_identifier (Bug 2649107)
1244: ---------------------------------------------------------------------------------------------------

Line 1241: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;

1237: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1238: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1239: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1240: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1241: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
1242: ---------------------------------------------------------------------------------------------------
1243: -- Type to store the person ids with same national_identifier (Bug 2649107)
1244: ---------------------------------------------------------------------------------------------------
1245: type person_id_store_rec is record

Line 1394: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value

1390: g_balance_value_tab(counter).defined_balance_id := t_month_balanceid_store(counter).defined_balance_id;
1391: g_context_tab(counter).tax_unit_id := month_year_action_rec.tax_uid;
1392: end loop;
1393: ----------------------------------------------------------------------------------
1394: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1395: ----------------------------------------------------------------------------------
1396: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1397: g_balance_value_tab,
1398: g_context_tab,

Line 1396: pay_balance_pkg.get_value( month_year_action_rec.assact_id,

1392: end loop;
1393: ----------------------------------------------------------------------------------
1394: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1395: ----------------------------------------------------------------------------------
1396: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1397: g_balance_value_tab,
1398: g_context_tab,
1399: false,
1400: false,

Line 1450: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value

1446: g_context_tab(counter).tax_unit_id := month_year_action_rec.tax_uid;
1447: end loop;
1448:
1449: ----------------------------------------------------------------------------------
1450: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1451: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.
1452: ----------------------------------------------------------------------------------
1453: if month_year_action_rec.assact_id is not null then
1454: pay_balance_pkg.get_value( month_year_action_rec.assact_id,

Line 1451: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.

1447: end loop;
1448:
1449: ----------------------------------------------------------------------------------
1450: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1451: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.
1452: ----------------------------------------------------------------------------------
1453: if month_year_action_rec.assact_id is not null then
1454: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1455: g_balance_value_tab,

Line 1454: pay_balance_pkg.get_value( month_year_action_rec.assact_id,

1450: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1451: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.
1452: ----------------------------------------------------------------------------------
1453: if month_year_action_rec.assact_id is not null then
1454: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1455: g_balance_value_tab,
1456: g_context_tab,
1457: false,
1458: false,