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

Line 531: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

527:
528: hr_utility.set_location(' l_defined_balance_id' || l_defined_balance_id,30);
529: hr_utility.set_location(' l_balance_value' || l_balance_value,30);
530: IF (p_child_run_ass_act_id IS NOT NULL) THEN /* 8615992 */
531: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
532: p_child_run_ass_act_id,
533: g_paye_ref,
534: null,
535: null,

Line 544: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

540: l_balance_value:=0;
541: END IF;
542: hr_utility.set_location(' l_balance_value' || l_balance_value,30);
543: IF (nvl(p_supp_flag,'N') = 'N') AND (p_last_cess_action IS NOT NULL) THEN
544: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
545: p_prev_src_id,
546: g_paye_ref,
547: null,
548: null,

Line 564: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

560: CLOSE get_last_source_id;
561:
562: hr_utility.set_location(' l_prev_source_id' || l_prev_source_id,30);
563: IF l_prev_source_id IS NOT NULL THEN /* 9337590 */
564: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
565: l_prev_source_id,
566: g_paye_ref,
567: null,
568: null,

Line 602: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

598: CLOSE cur_defined_balance_id;
599:
600: hr_utility.set_location(' l_balance_value' || l_balance_value,40);
601: IF (p_child_run_ass_act_id IS NOT NULL) THEN
602: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
603: p_child_run_ass_act_id,
604: g_paye_ref,
605: null,
606: null,

Line 615: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

611: l_balance_value:=0;
612: END IF;
613: hr_utility.set_location(' l_balance_value' || l_balance_value,40);
614: IF (nvl(p_supp_flag,'N') = 'N') AND (p_last_cess_action IS NOT NULL) THEN
615: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
616: p_prev_src_id,
617: g_paye_ref,
618: null,
619: null,

Line 634: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

630: FETCH get_last_source_id into l_prev_source_id;
631: CLOSE get_last_source_id;
632: hr_utility.set_location(' l_prev_source_id' || l_prev_source_id,40);
633: IF l_prev_source_id IS NOT NULL THEN /* 9337590 */
634: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
635: l_prev_source_id,
636: g_paye_ref,
637: null,
638: null,

Line 672: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

668: FETCH cur_defined_balance_id INTO l_defined_balance_id;
669: CLOSE cur_defined_balance_id;
670: hr_utility.set_location(' l_balance_value' || l_balance_value,50);
671: IF (p_child_run_ass_act_id IS NOT NULL) THEN
672: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
673: p_child_run_ass_act_id,
674: g_paye_ref,
675: null,
676: null,

Line 685: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

681: l_balance_value:=0;
682: END IF;
683: hr_utility.set_location(' l_balance_value' || l_balance_value,50);
684: IF (nvl(p_supp_flag,'N') = 'N') AND (p_last_cess_action IS NOT NULL) THEN
685: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
686: p_prev_src_id,
687: g_paye_ref,
688: null,
689: null,

Line 704: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

700: FETCH get_last_source_id into l_prev_source_id;
701: CLOSE get_last_source_id;
702: hr_utility.set_location(' l_prev_source_id' || l_prev_source_id,50);
703: IF l_prev_source_id IS NOT NULL THEN /* 9337590 */
704: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
705: l_prev_source_id,
706: g_paye_ref,
707: null,
708: null,

Line 744: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

740: CLOSE cur_defined_balance_id;
741:
742: hr_utility.set_location(' l_balance_value' || l_balance_value,60);
743: IF (p_child_run_ass_act_id IS NOT NULL) THEN
744: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
745: p_child_run_ass_act_id,
746: g_paye_ref,
747: null,
748: null,

Line 757: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

753: l_balance_value:=0;
754: END IF;
755: hr_utility.set_location(' l_balance_value' || l_balance_value,60);
756: IF (nvl(p_supp_flag,'N') = 'N') AND (p_last_cess_action IS NOT NULL) THEN
757: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
758: p_prev_src_id,
759: g_paye_ref,
760: null,
761: null,

Line 776: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

772: FETCH get_last_source_id into l_prev_source_id;
773: CLOSE get_last_source_id;
774: hr_utility.set_location(' l_prev_source_id' || l_prev_source_id,60);
775: IF l_prev_source_id IS NOT NULL THEN /* 9337590 */
776: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
777: l_prev_source_id,
778: g_paye_ref,
779: null,
780: null,

Line 822: l_balance_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

818:
819: hr_utility.set_location(' l_defined_balance_id' || l_defined_balance_id,30);
820: hr_utility.set_location(' l_balance_value_apr_09' || l_balance_value_apr_09,30);
821: IF l_assignment_action_apr_09 is not null THEN
822: l_balance_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
823: l_assignment_action_apr_09,
824: g_paye_ref,
825: null,
826: null,

Line 838: l_cess_last_bal_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

834: FETCH get_asg_action_eff_date INTO l_action_effective_date;
835: CLOSE get_asg_action_eff_date;
836: hr_utility.set_location('l_action_effective_date = ' || l_action_effective_date,40);
837: IF l_action_effective_date is not null and l_action_effective_date <= to_date('30/04/2009','dd/mm/yyyy') THEN
838: l_cess_last_bal_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
839: p_prev_src_id,
840: g_paye_ref,
841: null,
842: null,

Line 862: l_balance_value1_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

858:
859: hr_utility.set_location(' l_prev_source_id_apr_09' || l_prev_source_id_apr_09,40);
860: hr_utility.set_location('l_payroll_effective_date = ' || l_payroll_effective_date,40);
861: IF l_prev_source_id_apr_09 is not null and l_assignment_action_apr_09 is not null and l_payroll_effective_date <= to_date('30/04/2009','dd/mm/yyyy') THEN
862: l_balance_value1_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
863: l_prev_source_id_apr_09,
864: g_paye_ref,
865: null,
866: null,

Line 911: l_balance_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

907:
908: hr_utility.set_location(' l_defined_balance_id' || l_defined_balance_id,30);
909: hr_utility.set_location(' l_balance_value_apr_09' || l_balance_value_apr_09,30);
910: IF l_assignment_action_apr_09 is not null THEN
911: l_balance_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
912: l_assignment_action_apr_09,
913: g_paye_ref,
914: null,
915: null,

Line 927: l_cess_last_bal_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

923: FETCH get_asg_action_eff_date INTO l_action_effective_date;
924: CLOSE get_asg_action_eff_date;
925: hr_utility.set_location('l_action_effective_date = ' || l_action_effective_date,40);
926: IF l_action_effective_date is not null and l_action_effective_date <= to_date('30/04/2009','dd/mm/yyyy') THEN
927: l_cess_last_bal_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
928: p_prev_src_id,
929: g_paye_ref,
930: null,
931: null,

Line 950: l_balance_value1_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

946:
947: hr_utility.set_location(' l_prev_source_id_apr_09' || l_prev_source_id_apr_09,40);
948: hr_utility.set_location('l_payroll_effective_date = ' || l_payroll_effective_date,40);
949: IF l_prev_source_id_apr_09 is not null and l_assignment_action_apr_09 is not null and l_payroll_effective_date <= to_date('30/04/2009','dd/mm/yyyy') THEN
950: l_balance_value1_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
951: l_prev_source_id_apr_09,
952: g_paye_ref,
953: null,
954: null,

Line 999: l_balance_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

995:
996: hr_utility.set_location(' l_defined_balance_id' || l_defined_balance_id,30);
997: hr_utility.set_location(' l_balance_value_apr_09' || l_balance_value_apr_09,30);
998: IF l_assignment_action_apr_09 is not null THEN
999: l_balance_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1000: l_assignment_action_apr_09,
1001: g_paye_ref,
1002: null,
1003: null,

Line 1016: l_cess_last_bal_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1012: FETCH get_asg_action_eff_date INTO l_action_effective_date;
1013: CLOSE get_asg_action_eff_date;
1014: hr_utility.set_location('l_action_effective_date = ' || l_action_effective_date,40);
1015: IF l_action_effective_date is not null and l_action_effective_date <= to_date('30/04/2009','dd/mm/yyyy') THEN
1016: l_cess_last_bal_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1017: p_prev_src_id,
1018: g_paye_ref,
1019: null,
1020: null,

Line 1039: l_balance_value1_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1035:
1036: hr_utility.set_location(' l_prev_source_id_apr_09' || l_prev_source_id_apr_09,40);
1037: hr_utility.set_location('l_payroll_effective_date = ' || l_payroll_effective_date,40);
1038: IF l_prev_source_id_apr_09 is not null and l_assignment_action_apr_09 is not null and l_payroll_effective_date <= to_date('30/04/2009','dd/mm/yyyy') THEN
1039: l_balance_value1_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1040: l_prev_source_id_apr_09,
1041: g_paye_ref,
1042: null,
1043: null,

Line 1087: l_balance_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1083:
1084: hr_utility.set_location(' l_defined_balance_id' || l_defined_balance_id,30);
1085: hr_utility.set_location(' l_balance_value_apr_09' || l_balance_value_apr_09,30);
1086: IF l_assignment_action_apr_09 is not null THEN
1087: l_balance_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1088: l_assignment_action_apr_09,
1089: g_paye_ref,
1090: null,
1091: null,

Line 1103: l_cess_last_bal_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1099: FETCH get_asg_action_eff_date INTO l_action_effective_date;
1100: CLOSE get_asg_action_eff_date;
1101: hr_utility.set_location('l_action_effective_date = ' || l_action_effective_date,40);
1102: IF l_action_effective_date is not null and l_action_effective_date <= to_date('30/04/2009','dd/mm/yyyy') THEN
1103: l_cess_last_bal_value_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1104: p_prev_src_id,
1105: g_paye_ref,
1106: null,
1107: null,

Line 1126: l_balance_value1_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1122:
1123: hr_utility.set_location(' l_prev_source_id_apr_09' || l_prev_source_id_apr_09,40);
1124: hr_utility.set_location('l_payroll_effective_date = ' || l_payroll_effective_date,40);
1125: IF l_prev_source_id_apr_09 is not null and l_assignment_action_apr_09 is not null and l_payroll_effective_date <= to_date('30/04/2009','dd/mm/yyyy') THEN
1126: l_balance_value1_apr_09 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1127: l_prev_source_id_apr_09,
1128: g_paye_ref,
1129: null,
1130: null,

Line 1186: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1182: CLOSE cur_defined_balance_id;
1183:
1184: hr_utility.set_location(' USC Balance value : ' || l_balance_value,60);
1185: IF (p_child_run_ass_act_id IS NOT NULL) THEN
1186: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1187: p_child_run_ass_act_id,
1188: g_paye_ref,
1189: null,
1190: null,

Line 1199: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1195: l_balance_value:=0;
1196: END IF;
1197: hr_utility.set_location(' USC Balance value : ' || l_balance_value,60);
1198: IF (nvl(p_supp_flag,'N') = 'N') AND (p_last_cess_action IS NOT NULL) THEN
1199: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1200: p_prev_src_id,
1201: g_paye_ref,
1202: null,
1203: null,

Line 1218: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1214: FETCH get_last_source_id into l_prev_source_id;
1215: CLOSE get_last_source_id;
1216: hr_utility.set_location(' l_prev_source_id' || l_prev_source_id,60);
1217: IF l_prev_source_id IS NOT NULL THEN /* 9337590 */
1218: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1219: l_prev_source_id,
1220: g_paye_ref,
1221: null,
1222: null,

Line 1253: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1249: CLOSE cur_defined_balance_id;
1250:
1251: hr_utility.set_location(' Court Order Balance value : ' || l_balance_value,60);
1252: IF (p_child_run_ass_act_id IS NOT NULL) THEN
1253: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1254: p_child_run_ass_act_id,
1255: g_paye_ref,
1256: null,
1257: null,

Line 1266: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1262: l_balance_value:=0;
1263: END IF;
1264: hr_utility.set_location(' Court Order Balance value : ' || l_balance_value,60);
1265: IF (nvl(p_supp_flag,'N') = 'N') AND (p_last_cess_action IS NOT NULL) THEN
1266: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1267: p_prev_src_id,
1268: g_paye_ref,
1269: null,
1270: null,

Line 1285: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1281: FETCH get_last_source_id into l_prev_source_id;
1282: CLOSE get_last_source_id;
1283: hr_utility.set_location(' l_prev_source_id' || l_prev_source_id,60);
1284: IF l_prev_source_id IS NOT NULL THEN /* 9337590 */
1285: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1286: l_prev_source_id,
1287: g_paye_ref,
1288: null,
1289: null,

Line 1323: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1319: CLOSE cur_defined_balance_id;
1320:
1321: hr_utility.set_location(' IE Court Order Child Portion Balance value : ' || l_balance_value,60);
1322: IF (p_child_run_ass_act_id IS NOT NULL) THEN
1323: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1324: p_child_run_ass_act_id,
1325: g_paye_ref,
1326: null,
1327: null,

Line 1337: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1333: END IF;
1334: hr_utility.set_location(' IE Court Order Child Portion Balance value : ' || l_balance_value,60);
1335: IF (nvl(p_supp_flag,'N') = 'N') AND (p_last_cess_action IS NOT NULL) THEN
1336: l_cess_last_bal_value := 0;
1337: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1338: p_prev_src_id,
1339: g_paye_ref,
1340: null,
1341: null,

Line 1356: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1352: FETCH get_last_source_id into l_prev_source_id;
1353: CLOSE get_last_source_id;
1354: hr_utility.set_location(' l_prev_source_id' || l_prev_source_id,60);
1355: IF l_prev_source_id IS NOT NULL THEN /* 9337590 */
1356: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1357: l_prev_source_id,
1358: g_paye_ref,
1359: null,
1360: null,

Line 1396: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1392: CLOSE cur_defined_balance_id;
1393:
1394: hr_utility.set_location(' IE PRSA ER Contribution Balance value : ' || l_balance_value,60);
1395: IF (p_child_run_ass_act_id IS NOT NULL) THEN
1396: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1397: p_child_run_ass_act_id,
1398: g_paye_ref,
1399: null,
1400: null,

Line 1410: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1406: END IF;
1407: hr_utility.set_location(' IE PRSA ER Contribution Balance value : ' || l_balance_value,60);
1408: IF (nvl(p_supp_flag,'N') = 'N') AND (p_last_cess_action IS NOT NULL) THEN
1409: l_cess_last_bal_value := 0;
1410: l_cess_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1411: p_prev_src_id,
1412: g_paye_ref,
1413: null,
1414: null,

Line 1429: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,

1425: FETCH get_last_source_id into l_prev_source_id;
1426: CLOSE get_last_source_id;
1427: hr_utility.set_location(' l_prev_source_id' || l_prev_source_id,60);
1428: IF l_prev_source_id IS NOT NULL THEN /* 9337590 */
1429: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
1430: l_prev_source_id,
1431: g_paye_ref,
1432: null,
1433: null,