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

Line 755: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);

751: /*OPEN csr_assignment_action(p_payroll_action_id);
752: FETCH csr_assignment_action INTO l_assignment_action_id;
753: CLOSE csr_assignment_action;*/
754: /* check whether the person has crossed 21 before the start of the year itself*/
755: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
756: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id); --3621);
757: --OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_TAXABLE_BASE_PER_LU_YTD');
758: OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_TAXABLE_BASE_ASG_YTD');
759: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;

Line 756: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id); --3621);

752: FETCH csr_assignment_action INTO l_assignment_action_id;
753: CLOSE csr_assignment_action;*/
754: /* check whether the person has crossed 21 before the start of the year itself*/
755: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
756: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id); --3621);
757: --OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_TAXABLE_BASE_PER_LU_YTD');
758: OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_TAXABLE_BASE_ASG_YTD');
759: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
760: CLOSE csr_Get_Defined_Balance_Id;

Line 790: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

786: CLOSE csr_next_local_unit;
787: /*check whether the local unit is same in assignment and next local unit is different */
788: /* In this case proration is not required */
789: IF l_current_local_unit_id=g_local_unit_id AND l_next_local_unit_id <> g_local_unit_id THEN
790: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
791: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
792: P_VIRTUAL_DATE=>l_asg_end_date);
793: l_counter:=l_counter+1;
794: l_gross_salary:=nvl(l_value,0)-l_prev_gross_salary;

Line 806: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

802: l_prev_gross_salary:=l_prev_gross_salary+l_gross_salary;
803: /* check whether the local unit is different */
804: /* no need to update the table, but calculate the balance values*/
805: ELSIF l_current_local_unit_id<>g_local_unit_id THEN
806: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
807: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
808: P_VIRTUAL_DATE=>l_asg_end_date);
809: /* accumulating the previous salary values*/
810: l_prev_gross_salary:=/*l_prev_gross_salary+*/nvl(l_value,0);

Line 816: /*l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

812: ELSE
813: /* one record which crosses the period */
814: IF l_asg_end_date>=l_end_date AND l_counter=0 THEN
815: /* Get the gross salary for whole year */
816: /*l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
817: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
818: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/--);
819: /*l_gross_salary:=l_value;
820: fnd_file.put_line(fnd_file.LOG,'l_value'||l_value);

Line 848: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

844: /* If the age of the person crosses 21 or greater than 21 */
845: --IF l_twenty_one_years<=l_asg_end_date THEN
846: IF l_twenty_one_years<=l_start_date THEN
847: /* Get the gross salary for whole year */
848: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
849: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
850: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/);
851: l_gross_salary:=l_value;
852:

Line 854: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

850: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/);
851: l_gross_salary:=l_value;
852:
853: ELSE
854: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
855: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
856: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/);
857: l_gross_salary:=l_value;
858: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

Line 858: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

854: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
855: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
856: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/);
857: l_gross_salary:=l_value;
858: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
859: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
860: P_VIRTUAL_DATE=>trunc(l_twenty_one_years,'MM')-1/*TO_DATE('31-jan-2001')*/);
861: l_gross_salary:=l_gross_salary-l_value;
862:

Line 916: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

912: /* checking whether the new record has been created by updation of category or job */
913: IF (nvl(l_prev_job,'n') = nvl(l_job,'n') AND nvl(l_prev_category,'n') = nvl(l_category,'n')) THEN
914: /*IF (l_prev_job <> l_job AND l_prev_category <> l_category) OR (l_prev_job IS NULL AND l_prev_category IS NULL) THEN*/
915: emp_record(l_counter).l_end_date:= l_asg_end_date;
916: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
917: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
918: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
919: l_start_gross_salary:=l_value;
920:

Line 921: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

917: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
918: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
919: l_start_gross_salary:=l_value;
920:
921: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
922: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
923: P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date)); /*TO_DATE('31-jan-2001'));*/
924: l_end_gross_salary:=l_value;
925: l_gross_salary:=l_start_gross_salary- NVL(l_prev_gross_salary,0) + ((l_end_gross_salary-l_start_gross_salary)*l_days_in_period/l_days_in_payroll);

Line 985: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

981: emp_record(l_counter).l_termination:=l_terminated;
982: END IF;*/
983: /* IF the end period exceeds the l_end_date then */
984: IF l_asg_end_date>=l_end_date THEN
985: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
986: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
987: P_VIRTUAL_DATE=>l_end_date); /*TO_DATE('31-jan-2001'));*/
988: l_gross_salary:=l_value-l_prev_gross_salary;
989: --IF l_check_local_unit_id=g_local_unit_id THEN

Line 1002: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

998: emp_record(l_counter).l_termination:=l_terminated;
999: emp_record(l_counter).l_gross_salary:=l_gross_salary;*/
1000: ELSE
1001: IF l_asg_start_date=l_period_start_date THEN
1002: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1003: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1004: P_VIRTUAL_DATE=>(l_period_start_date)); /*TO_DATE('31-jan-2001'));*/
1005: l_start_gross_salary:=l_value;
1006: ELSE

Line 1008: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1004: P_VIRTUAL_DATE=>(l_period_start_date)); /*TO_DATE('31-jan-2001'));*/
1005: l_start_gross_salary:=l_value;
1006: ELSE
1007:
1008: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1009: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1010: P_VIRTUAL_DATE=>(l_period_start_date-1)); /*TO_DATE('31-jan-2001'));*/
1011: l_start_gross_salary:=l_value;
1012: END IF;

Line 1019: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1015: IF l_termination_date IS NOT NULL THEN
1016: OPEN csr_final_process(l_person_id,l_termination_date-1);
1017: FETCH csr_final_process INTO l_final_process_date;
1018: CLOSE csr_final_process;
1019: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1020: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1021: --P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date,l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1022: P_VIRTUAL_DATE=>l_final_process_date);
1023: l_end_gross_salary:=l_value;

Line 1026: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1022: P_VIRTUAL_DATE=>l_final_process_date);
1023: l_end_gross_salary:=l_value;
1024: l_gross_salary:=l_start_gross_salary- NVL(l_prev_gross_salary,0) + ((l_end_gross_salary-l_start_gross_salary));
1025: ELSE
1026: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1027: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1028: --P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date,l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1029: P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date));
1030: l_end_gross_salary:=l_value;

Line 1040: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1036: l_prev_gross_salary:=l_prev_gross_salary+l_gross_salary;
1037: IF l_twenty_one_years < l_asg_start_date then
1038: emp_record(l_counter).l_gross_salary:=l_gross_salary;
1039: ELSE
1040: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1041: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1042: P_VIRTUAL_DATE=>LEAST((trunc(l_twenty_one_years,'MM')-1),l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1043: l_twenty_gross_salary:=l_value;
1044: l_gross_salary:=l_start_gross_salary-NVL(l_twenty_gross_salary,0)+((l_end_gross_salary-l_start_gross_salary)*l_days_in_period/l_days_in_payroll);

Line 1054: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1050: -- ELSE
1051: END IF;
1052: --emp_record(l_counter).l_white_from:=l_white_from;
1053: /* emp_record(l_counter).l_end_date:= l_asg_end_date;
1054: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1055: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1056: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
1057: /* l_start_gross_salary:=l_value;
1058: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

Line 1058: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1054: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1055: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1056: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
1057: /* l_start_gross_salary:=l_value;
1058: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1059: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1060: P_VIRTUAL_DATE=>l_period_end_date); /*TO_DATE('31-jan-2001'));*/
1061: /*l_end_gross_salary:=l_value;
1062: l_gross_salary:=l_start_gross_salary- l_prev_gross_salary + ((l_end_gross_salary-l_start_gross_salary)*l_days_in_period/l_days_in_payroll);

Line 1201: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);

1197: /* OPEN csr_assignment_action(p_payroll_action_id);
1198: FETCH csr_assignment_action INTO l_assignment_action_id;
1199: CLOSE csr_assignment_action;*/
1200: /* check whether the person has crossed 21 before the start of the year itself*/
1201: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
1202: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
1203: OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_TAXABLE_BASE_PER_LU_YTD');
1204: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1205: CLOSE csr_Get_Defined_Balance_Id;

Line 1202: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);

1198: FETCH csr_assignment_action INTO l_assignment_action_id;
1199: CLOSE csr_assignment_action;*/
1200: /* check whether the person has crossed 21 before the start of the year itself*/
1201: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
1202: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
1203: OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_TAXABLE_BASE_PER_LU_YTD');
1204: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1205: CLOSE csr_Get_Defined_Balance_Id;
1206:

Line 1234: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1230: CLOSE csr_next_local_unit;
1231: /*check whether the local unit is same in assignment and next local unit is different */
1232: /* In this case proration is not required */
1233: IF l_current_local_unit_id=l_local_unit_id AND l_next_local_unit_id <> l_local_unit_id THEN
1234: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1235: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1236: P_VIRTUAL_DATE=>l_asg_end_date);
1237: l_counter:=l_counter+1;
1238: l_gross_salary:=nvl(l_value,0)-l_prev_gross_salary;

Line 1250: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1246: l_prev_gross_salary:=l_prev_gross_salary+l_gross_salary;
1247: /* check whether the local unit is different */
1248: /* no need to update the table, but calculate the balance values*/
1249: ELSIF l_current_local_unit_id<>l_local_unit_id THEN
1250: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1251: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1252: P_VIRTUAL_DATE=>l_asg_end_date);
1253: /* accumulating the previous salary values*/
1254: l_prev_gross_salary:=/*l_prev_gross_salary+*/nvl(l_value,0);

Line 1262: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1258: IF l_asg_end_date>=l_end_date AND l_counter=0 THEN
1259: /* If the age of the person crosses 21 or greater than 21 */
1260: IF l_twenty_one_years<=l_start_date THEN
1261: /* Get the gross salary for whole year */
1262: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1263: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1264: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/);
1265: l_gross_salary:=l_value;
1266:

Line 1268: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1264: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/);
1265: l_gross_salary:=l_value;
1266:
1267: ELSE
1268: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1269: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1270: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/);
1271: l_gross_salary:=l_value;
1272: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

Line 1272: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1268: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1269: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1270: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/);
1271: l_gross_salary:=l_value;
1272: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1273: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1274: P_VIRTUAL_DATE=>trunc(l_twenty_one_years,'MM')-1/*TO_DATE('31-jan-2001')*/);
1275: l_gross_salary:=l_gross_salary-l_value;
1276: END IF;

Line 1319: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1315: --IF (l_prev_job = l_job AND l_prev_category = l_category) THEN
1316: IF (nvl(l_prev_job,'n') = nvl(l_job,'n') AND nvl(l_prev_category,'n') = nvl(l_category,'n')) THEN
1317: /*IF (l_prev_job <> l_job AND l_prev_category <> l_category) OR (l_prev_job IS NULL AND l_prev_category IS NULL) THEN*/
1318: emp_record(l_counter).l_end_date:= l_asg_end_date;
1319: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1320: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1321: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
1322: l_start_gross_salary:=l_value;
1323:

Line 1325: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1321: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
1322: l_start_gross_salary:=l_value;
1323:
1324:
1325: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1326: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1327: P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date)); /*TO_DATE('31-jan-2001'));*/
1328: l_end_gross_salary:=l_value;
1329: l_gross_salary:=l_start_gross_salary- NVL(l_prev_gross_salary,0) + ((l_end_gross_salary-l_start_gross_salary)*l_days_in_period/l_days_in_payroll);

Line 1337: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1333: l_prev_gross_salary:=l_prev_gross_salary+l_gross_salary;
1334: ELSE
1335: /* IF the end period exceeds the l_end_date then */
1336: IF l_asg_end_date>=l_end_date THEN
1337: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1338: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1339: P_VIRTUAL_DATE=>l_end_date); /*TO_DATE('31-jan-2001'));*/
1340: l_gross_salary:=l_value-l_prev_gross_salary;
1341:

Line 1407: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1403: /*IF l_prev_category<>'WC' AND l_category='WC' THEN
1404: emp_record(l_counter).l_termination:=l_terminated;
1405: END IF;*/
1406: IF l_asg_start_date=l_period_start_date THEN
1407: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1408: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1409: P_VIRTUAL_DATE=>(l_period_start_date)); /*TO_DATE('31-jan-2001'));*/
1410: l_start_gross_salary:=l_value;
1411: ELSE

Line 1412: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1408: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1409: P_VIRTUAL_DATE=>(l_period_start_date)); /*TO_DATE('31-jan-2001'));*/
1410: l_start_gross_salary:=l_value;
1411: ELSE
1412: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1413: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1414: P_VIRTUAL_DATE=>(l_period_start_date-1)); /*TO_DATE('31-jan-2001'));*/
1415: l_start_gross_salary:=l_value;
1416: END IF;

Line 1423: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1419: IF l_termination_date IS NOT NULL THEN
1420: OPEN csr_final_process(l_person_id,l_termination_date-1);
1421: FETCH csr_final_process INTO l_final_process_date;
1422: CLOSE csr_final_process;
1423: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1424: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1425: --P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date,l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1426: P_VIRTUAL_DATE=>l_final_process_date);
1427: l_end_gross_salary:=l_value;

Line 1430: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1426: P_VIRTUAL_DATE=>l_final_process_date);
1427: l_end_gross_salary:=l_value;
1428: l_gross_salary:=l_start_gross_salary- NVL(l_prev_gross_salary,0) + ((l_end_gross_salary-l_start_gross_salary));
1429: ELSE
1430: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1431: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1432: --P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date,l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1433: P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date));
1434: l_end_gross_salary:=l_value;

Line 1439: /*l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1435:
1436: l_gross_salary:=l_start_gross_salary- NVL(l_prev_gross_salary,0) + ((l_end_gross_salary-l_start_gross_salary)*l_days_in_period/l_days_in_payroll);
1437: END IF;
1438:
1439: /*l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1440: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1441: --P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date,l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1442: /*P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date));
1443: l_end_gross_salary:=l_value;

Line 1452: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1448:
1449: IF l_twenty_one_years < l_asg_start_date then
1450: emp_record(l_counter).l_gross_salary:=l_gross_salary;
1451: ELSE
1452: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1453: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1454: P_VIRTUAL_DATE=>LEAST((trunc(l_twenty_one_years,'MM')-1),l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1455: l_twenty_gross_salary:=l_value;
1456: l_gross_salary:=l_start_gross_salary-NVL(l_twenty_gross_salary,0)+((l_end_gross_salary-l_start_gross_salary)*l_days_in_period/l_days_in_payroll);

Line 1464: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1460: -- ELSE
1461: END IF;
1462: --emp_record(l_counter).l_white_from:=l_white_from;
1463: /* emp_record(l_counter).l_end_date:= l_asg_end_date;
1464: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1465: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1466: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
1467: /* l_start_gross_salary:=l_value;
1468:

Line 1469: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1465: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1466: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
1467: /* l_start_gross_salary:=l_value;
1468:
1469: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1470: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1471: P_VIRTUAL_DATE=>l_period_end_date); /*TO_DATE('31-jan-2001'));*/
1472: /*l_end_gross_salary:=l_value;
1473: l_gross_salary:=l_start_gross_salary- l_prev_gross_salary + ((l_end_gross_salary-l_start_gross_salary)*l_days_in_period/l_days_in_payroll);

Line 1744: (pay_balance_pkg.get_value

1740: CLOSE csr_def_bal_id;
1741:
1742: l_return_balance_value :=
1743: TO_CHAR
1744: (pay_balance_pkg.get_value
1745: (p_defined_balance_id => l_defined_balance_id
1746: , p_assignment_id => p_in_assignment_id
1747: , p_virtual_date => p_in_virtual_date
1748: )