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

Line 796: PROCEDURE balance_difference(g_result_table1 IN pay_balance_pkg.t_detailed_bal_out_tab

792: -- Rev# Date Userid Description --
793: --------------------------------------------------------------------------
794: -- 115.0 09-SEP-2005 aaagarwa Initial Version --
795: --------------------------------------------------------------------------
796: PROCEDURE balance_difference(g_result_table1 IN pay_balance_pkg.t_detailed_bal_out_tab
797: ,g_result_table2 IN pay_balance_pkg.t_detailed_bal_out_tab
798: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
799: )
800: IS

Line 797: ,g_result_table2 IN pay_balance_pkg.t_detailed_bal_out_tab

793: --------------------------------------------------------------------------
794: -- 115.0 09-SEP-2005 aaagarwa Initial Version --
795: --------------------------------------------------------------------------
796: PROCEDURE balance_difference(g_result_table1 IN pay_balance_pkg.t_detailed_bal_out_tab
797: ,g_result_table2 IN pay_balance_pkg.t_detailed_bal_out_tab
798: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
799: )
800: IS
801: l_message VARCHAR2(255);

Line 798: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

794: -- 115.0 09-SEP-2005 aaagarwa Initial Version --
795: --------------------------------------------------------------------------
796: PROCEDURE balance_difference(g_result_table1 IN pay_balance_pkg.t_detailed_bal_out_tab
797: ,g_result_table2 IN pay_balance_pkg.t_detailed_bal_out_tab
798: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
799: )
800: IS
801: l_message VARCHAR2(255);
802: l_procedure VARCHAR2(100);

Line 850: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab

846: ,p_balance_dimension IN VARCHAR2
847: ,p_balance_dimension1 IN VARCHAR2 DEFAULT NULL
848: ,p_balance_dimension2 IN VARCHAR2 DEFAULT NULL
849: ,p_balance_dimension3 IN VARCHAR2 DEFAULT NULL
850: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab
851: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
852: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
853: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
854: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

Line 851: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

847: ,p_balance_dimension1 IN VARCHAR2 DEFAULT NULL
848: ,p_balance_dimension2 IN VARCHAR2 DEFAULT NULL
849: ,p_balance_dimension3 IN VARCHAR2 DEFAULT NULL
850: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab
851: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
852: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
853: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
854: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
855: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab

Line 852: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

848: ,p_balance_dimension2 IN VARCHAR2 DEFAULT NULL
849: ,p_balance_dimension3 IN VARCHAR2 DEFAULT NULL
850: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab
851: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
852: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
853: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
854: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
855: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab
856: )

Line 853: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

849: ,p_balance_dimension3 IN VARCHAR2 DEFAULT NULL
850: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab
851: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
852: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
853: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
854: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
855: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab
856: )
857: IS

Line 854: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

850: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab
851: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
852: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
853: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
854: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
855: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab
856: )
857: IS
858:

Line 855: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab

851: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
852: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
853: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
854: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
855: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab
856: )
857: IS
858:
859: l_action_info_id NUMBER;

Line 861: l_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

857: IS
858:
859: l_action_info_id NUMBER;
860: l_ovn NUMBER;
861: l_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
862: l_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
863: l_message VARCHAR2(255);
864: l_procedure VARCHAR2(100);
865: l_result_table4 pay_balance_pkg.t_detailed_bal_out_tab;

Line 862: l_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

858:
859: l_action_info_id NUMBER;
860: l_ovn NUMBER;
861: l_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
862: l_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
863: l_message VARCHAR2(255);
864: l_procedure VARCHAR2(100);
865: l_result_table4 pay_balance_pkg.t_detailed_bal_out_tab;
866:

Line 865: l_result_table4 pay_balance_pkg.t_detailed_bal_out_tab;

861: l_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
862: l_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
863: l_message VARCHAR2(255);
864: l_procedure VARCHAR2(100);
865: l_result_table4 pay_balance_pkg.t_detailed_bal_out_tab;
866:
867:
868: BEGIN
869:

Line 898: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

894:
895: g_balance_value_tab(1).defined_balance_id :=
896: pay_in_tax_utils.get_defined_balance('Adjusted Advance for Allowances','_ASG_COMP_YTD');
897:
898: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
899: ,p_defined_balance_lst => g_balance_value_tab
900: ,p_context_lst => g_context_table
901: ,p_output_table => l_result_table1
902: );

Line 908: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id

904:
905: IF pre_gre_asg_act_id IS NOT NULL
906: THEN
907: pay_in_utils.set_location(g_debug,l_procedure, 30);
908: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id
909: ,p_defined_balance_lst => g_balance_value_tab
910: ,p_context_lst => g_context_table
911: ,p_output_table => l_result_table2
912: );

Line 930: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

926:
927: g_balance_value_tab(1).defined_balance_id :=
928: pay_in_tax_utils.get_defined_balance(p_balance_name,p_balance_dimension);
929:
930: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
931: ,p_defined_balance_lst => g_balance_value_tab
932: ,p_context_lst => g_context_table
933: ,p_output_table => l_result_table1--g_result_table
934: );

Line 941: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id

937:
938: IF pre_gre_asg_act_id IS NOT NULL
939: THEN
940: pay_in_utils.set_location(g_debug,l_procedure, 30);
941: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id
942: ,p_defined_balance_lst => g_balance_value_tab
943: ,p_context_lst => g_context_table
944: ,p_output_table => l_result_table2
945: );

Line 959: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

955: pay_in_utils.set_location(g_debug,l_procedure, 50);
956: g_balance_value_tab(1).defined_balance_id :=
957: pay_in_tax_utils.get_defined_balance(p_balance_name1,p_balance_dimension1);
958:
959: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
960: ,p_defined_balance_lst => g_balance_value_tab
961: ,p_context_lst => g_context_table
962: ,p_output_table => l_result_table1--g_result_table1
963: );

Line 967: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id

963: );
964: IF pre_gre_asg_act_id IS NOT NULL AND p_action_inf_category = 'IN_EOY_PERQ'
965: THEN
966: pay_in_utils.set_location(g_debug,l_procedure, 60);
967: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id
968: ,p_defined_balance_lst => g_balance_value_tab
969: ,p_context_lst => g_context_table
970: ,p_output_table => l_result_table2
971: );

Line 986: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

982: pay_in_utils.set_location(g_debug,l_procedure, 90);
983: g_balance_value_tab(1).defined_balance_id :=
984: pay_in_tax_utils.get_defined_balance(p_balance_name2,p_balance_dimension2);
985:
986: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
987: ,p_defined_balance_lst => g_balance_value_tab
988: ,p_context_lst => g_context_table
989: ,p_output_table => l_result_table1--g_result_table2
990: );

Line 994: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id

990: );
991: IF pre_gre_asg_act_id IS NOT NULL
992: THEN
993: pay_in_utils.set_location(g_debug,l_procedure, 100);
994: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id
995: ,p_defined_balance_lst => g_balance_value_tab
996: ,p_context_lst => g_context_table
997: ,p_output_table => l_result_table2
998: );

Line 1012: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1008: pay_in_utils.set_location(g_debug,l_procedure, 120);
1009: g_balance_value_tab(1).defined_balance_id :=
1010: pay_in_tax_utils.get_defined_balance(p_balance_name3,p_balance_dimension3);
1011:
1012: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1013: ,p_defined_balance_lst => g_balance_value_tab
1014: ,p_context_lst => g_context_table
1015: ,p_output_table => g_result_table3
1016: );

Line 1187: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1183: AND pbd.balance_dimension_id = pdb.balance_dimension_id
1184: ORDER BY pbt.balance_name;
1185:
1186: g_bal_name_tab t_bal_name_tab;
1187: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1188: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1189: g_context_table pay_balance_pkg.t_context_tab;
1190: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1191: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1188: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

1184: ORDER BY pbt.balance_name;
1185:
1186: g_bal_name_tab t_bal_name_tab;
1187: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1188: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1189: g_context_table pay_balance_pkg.t_context_tab;
1190: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1191: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1192: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1189: g_context_table pay_balance_pkg.t_context_tab;

1185:
1186: g_bal_name_tab t_bal_name_tab;
1187: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1188: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1189: g_context_table pay_balance_pkg.t_context_tab;
1190: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1191: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1192: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1193: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1190: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

1186: g_bal_name_tab t_bal_name_tab;
1187: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1188: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1189: g_context_table pay_balance_pkg.t_context_tab;
1190: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1191: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1192: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1193: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1194:

Line 1191: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

1187: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1188: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1189: g_context_table pay_balance_pkg.t_context_tab;
1190: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1191: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1192: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1193: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1194:
1195: i NUMBER;

Line 1192: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

1188: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1189: g_context_table pay_balance_pkg.t_context_tab;
1190: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1191: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1192: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1193: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1194:
1195: i NUMBER;
1196: l_defined_balance_id NUMBER;

Line 1193: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;

1189: g_context_table pay_balance_pkg.t_context_tab;
1190: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1191: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1192: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1193: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1194:
1195: i NUMBER;
1196: l_defined_balance_id NUMBER;
1197: l_action_info_id NUMBER;

Line 1238: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1234: pay_in_utils.set_location(g_debug,l_procedure, 20);
1235:
1236: g_context_table(1).tax_unit_id := p_gre_id;
1237:
1238: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1239: ,p_defined_balance_lst => g_balance_value_tab
1240: ,p_context_lst => g_context_table
1241: ,p_output_table => g_result_table
1242: );

Line 1286: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1282: END LOOP;
1283:
1284:
1285:
1286: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1287: ,p_defined_balance_lst => g_balance_value_tab
1288: ,p_context_lst => g_context_table
1289: ,p_output_table => g_result_table
1290: );

Line 1314: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1310:
1311: g_balance_value_tab1(1).defined_balance_id :=
1312: pay_in_tax_utils.get_defined_balance('Gross Chapter VIA Deductions','_ASG_LE_COMP_DE_PTD');
1313:
1314: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1315: ,p_defined_balance_lst => g_balance_value_tab1
1316: ,p_context_lst => g_context_table
1317: ,p_output_table => g_result_table1
1318: );

Line 1432: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1428: g_balance_value_tab(1).defined_balance_id :=
1429: pay_in_tax_utils.get_defined_balance('Deductions under Section 80CCE','_ASG_LE_COMP_DE_PTD');
1430:
1431: -- Qualifying Amounts for Life Insurance and Deferred Annuity obtained
1432: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1433: ,p_defined_balance_lst => g_balance_value_tab
1434: ,p_context_lst => g_context_table
1435: ,p_output_table => g_result_table
1436: );

Line 1452: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1448: g_context_table(1).tax_unit_id := p_gre_id;
1449: g_balance_value_tab1(1).defined_balance_id :=
1450: pay_in_tax_utils.get_defined_balance('Gross Chapter VIA Deductions','_ASG_LE_COMP_DE_PTD');
1451:
1452: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1453: ,p_defined_balance_lst => g_balance_value_tab1
1454: ,p_context_lst => g_context_table
1455: ,p_output_table => g_result_table1
1456: );

Line 1482: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1478: g_balance_value_tab1(3).defined_balance_id :=
1479: pay_in_tax_utils.get_defined_balance('Senior Citizens Savings Scheme','_ASG_LE_DE_PTD');
1480:
1481:
1482: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1483: ,p_defined_balance_lst => g_balance_value_tab1
1484: ,p_context_lst => g_context_table
1485: ,p_output_table => g_result_table1
1486: );

Line 1510: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1506: pay_in_tax_utils.get_defined_balance('F16 ER Pension Contribution','_ASG_LE_DE_PTD');
1507: g_balance_value_tab1(2).defined_balance_id :=
1508: pay_in_tax_utils.get_defined_balance('F16 Section 80CCD','_ASG_LE_DE_PTD');
1509:
1510: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1511: ,p_defined_balance_lst => g_balance_value_tab1
1512: ,p_context_lst => g_context_table
1513: ,p_output_table => g_result_table1
1514: );

Line 1676: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1672: AND (pur.legislation_code = 'IN' OR pur.business_group_id = g_bg_id)
1673: AND g_start_date BETWEEN pur.effective_start_date AND pur.effective_end_date
1674: ORDER by name ASC;
1675:
1676: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1677: g_context_table pay_balance_pkg.t_context_tab;
1678: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1679: l_action_info_id NUMBER;
1680: l_ovn NUMBER;

Line 1677: g_context_table pay_balance_pkg.t_context_tab;

1673: AND g_start_date BETWEEN pur.effective_start_date AND pur.effective_end_date
1674: ORDER by name ASC;
1675:
1676: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1677: g_context_table pay_balance_pkg.t_context_tab;
1678: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1679: l_action_info_id NUMBER;
1680: l_ovn NUMBER;
1681: l_defined_balance_id NUMBER;

Line 1678: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

1674: ORDER by name ASC;
1675:
1676: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1677: g_context_table pay_balance_pkg.t_context_tab;
1678: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1679: l_action_info_id NUMBER;
1680: l_ovn NUMBER;
1681: l_defined_balance_id NUMBER;
1682: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1682: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

1678: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1679: l_action_info_id NUMBER;
1680: l_ovn NUMBER;
1681: l_defined_balance_id NUMBER;
1682: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1683: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1684: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1685: l_value NUMBER;
1686: i NUMBER := 0;

Line 1683: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

1679: l_action_info_id NUMBER;
1680: l_ovn NUMBER;
1681: l_defined_balance_id NUMBER;
1682: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1683: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1684: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1685: l_value NUMBER;
1686: i NUMBER := 0;
1687: l_message VARCHAR2(255);

Line 1684: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;

1680: l_ovn NUMBER;
1681: l_defined_balance_id NUMBER;
1682: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1683: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1684: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1685: l_value NUMBER;
1686: i NUMBER := 0;
1687: l_message VARCHAR2(255);
1688: l_procedure VARCHAR2(100);

Line 1744: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

1740: THEN
1741: IF p_flag -- Neither the first nor the last record. Hence diff of THRA _ASG_YTD at 2 diff act ids.
1742: THEN
1743: l_defined_balance_id := pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance','_ASG_YTD');
1744: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1745: ,p_assignment_action_id => p_run_asg_action_id
1746: );
1747: l_value := l_value - pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1748: ,p_assignment_action_id => pre_gre_asg_act_id

Line 1747: l_value := l_value - pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

1743: l_defined_balance_id := pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance','_ASG_YTD');
1744: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1745: ,p_assignment_action_id => p_run_asg_action_id
1746: );
1747: l_value := l_value - pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1748: ,p_assignment_action_id => pre_gre_asg_act_id
1749: );
1750: ELSE -- Last Record. Hence diff of Projected and YTD value.
1751: l_defined_balance_id :=

Line 1754: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

1750: ELSE -- Last Record. Hence diff of Projected and YTD value.
1751: l_defined_balance_id :=
1752: pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance for Projection','_ASG_LE_DE_PTD');
1753:
1754: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1755: ,p_assignment_action_id => p_run_asg_action_id
1756: );
1757: l_defined_balance_id := pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance','_ASG_YTD');
1758: l_value := l_value - pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

Line 1758: l_value := l_value - pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

1754: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1755: ,p_assignment_action_id => p_run_asg_action_id
1756: );
1757: l_defined_balance_id := pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance','_ASG_YTD');
1758: l_value := l_value - pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1759: ,p_assignment_action_id => pre_gre_asg_act_id
1760: );
1761: END IF;
1762: ELSIF p_flag -- First Record in a multi tan scenario, hence take the THRA_ASG_YTD

Line 1766: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

1762: ELSIF p_flag -- First Record in a multi tan scenario, hence take the THRA_ASG_YTD
1763: THEN
1764: pay_in_utils.set_location(g_debug,l_procedure, 40);
1765: l_defined_balance_id := pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance','_ASG_YTD');
1766: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1767: ,p_assignment_action_id => p_run_asg_action_id
1768: );
1769: ELSE -- Only a single record exists, hence take the Projetced value
1770: pay_in_utils.set_location(g_debug,l_procedure, 50);

Line 1772: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

1768: );
1769: ELSE -- Only a single record exists, hence take the Projetced value
1770: pay_in_utils.set_location(g_debug,l_procedure, 50);
1771: l_defined_balance_id := pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance for Projection','_ASG_DE_PTD');
1772: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1773: ,p_assignment_action_id => p_run_asg_action_id
1774: );
1775: END IF;
1776:

Line 1818: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1814: ,p_gre_id IN NUMBER
1815: ,pre_gre_asg_act_id IN NUMBER DEFAULT NULL
1816: )
1817: IS
1818: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1819: g_context_table pay_balance_pkg.t_context_tab;
1820: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1821: l_action_info_id NUMBER;
1822: l_ovn NUMBER;

Line 1819: g_context_table pay_balance_pkg.t_context_tab;

1815: ,pre_gre_asg_act_id IN NUMBER DEFAULT NULL
1816: )
1817: IS
1818: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1819: g_context_table pay_balance_pkg.t_context_tab;
1820: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1821: l_action_info_id NUMBER;
1822: l_ovn NUMBER;
1823: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1820: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

1816: )
1817: IS
1818: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1819: g_context_table pay_balance_pkg.t_context_tab;
1820: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1821: l_action_info_id NUMBER;
1822: l_ovn NUMBER;
1823: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1824: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1823: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

1819: g_context_table pay_balance_pkg.t_context_tab;
1820: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1821: l_action_info_id NUMBER;
1822: l_ovn NUMBER;
1823: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1824: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1825: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1826: l_message VARCHAR2(255);
1827: l_procedure VARCHAR2(100);

Line 1824: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

1820: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1821: l_action_info_id NUMBER;
1822: l_ovn NUMBER;
1823: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1824: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1825: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1826: l_message VARCHAR2(255);
1827: l_procedure VARCHAR2(100);
1828:

Line 1825: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;

1821: l_action_info_id NUMBER;
1822: l_ovn NUMBER;
1823: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1824: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1825: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1826: l_message VARCHAR2(255);
1827: l_procedure VARCHAR2(100);
1828:
1829: BEGIN

Line 1994: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1990: AND pbd.legislation_code = 'IN'
1991: AND pbt.balance_type_id = pdb.balance_type_id
1992: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
1993:
1994: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1995: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1996: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1997:
1998: i NUMBER;

Line 1995: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

1991: AND pbt.balance_type_id = pdb.balance_type_id
1992: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
1993:
1994: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1995: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1996: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1997:
1998: i NUMBER;
1999: j NUMBER;

Line 1996: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

1992: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
1993:
1994: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1995: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1996: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1997:
1998: i NUMBER;
1999: j NUMBER;
2000: g_bal_name_tab t_bal_name_tab;

Line 2002: g_context_table pay_balance_pkg.t_context_tab;

1998: i NUMBER;
1999: j NUMBER;
2000: g_bal_name_tab t_bal_name_tab;
2001: g_bal_name_tab1 t_bal_name_tab;
2002: g_context_table pay_balance_pkg.t_context_tab;
2003: l_action_info_id NUMBER;
2004: l_ovn NUMBER;
2005: l_in_tax_ded NUMBER;
2006: l_message VARCHAR2(255);

Line 2038: pay_balance_pkg.get_value(p_run_asg_action_id,g_balance_value_tab);

2034: g_bal_name_tab(i).balance_name := c_rec.balance_name;
2035: i := i + 1;
2036: END LOOP;
2037:
2038: pay_balance_pkg.get_value(p_run_asg_action_id,g_balance_value_tab);
2039:
2040: pay_in_utils.set_location(g_debug,l_procedure, 20);
2041:
2042:

Line 2079: pay_balance_pkg.get_value(p_run_asg_action_id,g_balance_value_tab1);

2075: g_bal_name_tab1(i).balance_name := c_rec.balance_name;
2076: i := i + 1;
2077: END LOOP;
2078:
2079: pay_balance_pkg.get_value(p_run_asg_action_id,g_balance_value_tab1);
2080:
2081: pay_in_utils.set_location(g_debug,l_procedure, 30);
2082:
2083: FOR i IN 1..g_balance_value_tab1.COUNT

Line 2128: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

2124: END LOOP;
2125:
2126: pay_in_utils.set_location(g_debug,l_procedure, 50);
2127:
2128: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
2129: ,p_defined_balance_lst => g_balance_value_tab1
2130: ,p_context_lst => g_context_table
2131: ,p_output_table => g_result_table
2132: );

Line 2303: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

2299:
2300:
2301:
2302:
2303: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
2304: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
2305: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
2306: g_context_table pay_balance_pkg.t_context_tab;
2307: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

Line 2304: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

2300:
2301:
2302:
2303: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
2304: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
2305: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
2306: g_context_table pay_balance_pkg.t_context_tab;
2307: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
2308: g_bal_name_tab t_bal_name_tab;

Line 2305: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;

2301:
2302:
2303: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
2304: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
2305: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
2306: g_context_table pay_balance_pkg.t_context_tab;
2307: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
2308: g_bal_name_tab t_bal_name_tab;
2309: i NUMBER;

Line 2306: g_context_table pay_balance_pkg.t_context_tab;

2302:
2303: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
2304: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
2305: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
2306: g_context_table pay_balance_pkg.t_context_tab;
2307: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
2308: g_bal_name_tab t_bal_name_tab;
2309: i NUMBER;
2310: l_context VARCHAR2(50);

Line 2307: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

2303: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
2304: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
2305: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
2306: g_context_table pay_balance_pkg.t_context_tab;
2307: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
2308: g_bal_name_tab t_bal_name_tab;
2309: i NUMBER;
2310: l_context VARCHAR2(50);
2311: l_defined_balance_id NUMBER;

Line 2354: pay_balance_pkg.get_value(p_run_asg_action_id,l_balance_value_tab1);

2350:
2351: l_balance_value_tab1 := g_balance_value_tab;
2352: l_balance_value_tab2 := g_balance_value_tab;
2353:
2354: pay_balance_pkg.get_value(p_run_asg_action_id,l_balance_value_tab1);
2355:
2356: IF pre_gre_asg_act_id IS NOT NULL
2357: THEN
2358: pay_balance_pkg.get_value(pre_gre_asg_act_id,l_balance_value_tab2);

Line 2358: pay_balance_pkg.get_value(pre_gre_asg_act_id,l_balance_value_tab2);

2354: pay_balance_pkg.get_value(p_run_asg_action_id,l_balance_value_tab1);
2355:
2356: IF pre_gre_asg_act_id IS NOT NULL
2357: THEN
2358: pay_balance_pkg.get_value(pre_gre_asg_act_id,l_balance_value_tab2);
2359: END IF;
2360:
2361: pay_in_utils.set_location(g_debug,l_procedure, 30);
2362: FOR i IN 1..g_balance_value_tab.COUNT