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 752: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

850: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
851: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
852: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/);
853: l_gross_salary:=l_value;
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=>trunc(l_twenty_one_years,'MM')-1/*TO_DATE('31-jan-2001')*/);
857: l_gross_salary:=l_gross_salary-l_value;
858:

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

907: /* checking whether the new record has been created by updation of category or job */
908: IF (nvl(l_prev_job,'n') = nvl(l_job,'n') AND nvl(l_prev_category,'n') = nvl(l_category,'n')) THEN
909: /*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*/
910: emp_record(l_counter).l_end_date:= l_asg_end_date;
911: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
912: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
913: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
914: l_start_gross_salary:=l_value;
915:

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

912: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
913: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
914: l_start_gross_salary:=l_value;
915:
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=>least(l_period_end_date,l_end_date)); /*TO_DATE('31-jan-2001'));*/
919: l_end_gross_salary:=l_value;
920: 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 979: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

975: emp_record(l_counter).l_termination:=l_terminated;
976: END IF;*/
977: /* IF the end period exceeds the l_end_date then */
978: IF l_asg_end_date>=l_end_date THEN
979: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
980: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
981: P_VIRTUAL_DATE=>l_end_date); /*TO_DATE('31-jan-2001'));*/
982: l_gross_salary:=l_value-l_prev_gross_salary;
983: --IF l_check_local_unit_id=g_local_unit_id THEN

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

992: emp_record(l_counter).l_termination:=l_terminated;
993: emp_record(l_counter).l_gross_salary:=l_gross_salary;*/
994: ELSE
995: IF l_asg_start_date=l_period_start_date THEN
996: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
997: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
998: P_VIRTUAL_DATE=>(l_period_start_date)); /*TO_DATE('31-jan-2001'));*/
999: l_start_gross_salary:=l_value;
1000: ELSE

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

998: P_VIRTUAL_DATE=>(l_period_start_date)); /*TO_DATE('31-jan-2001'));*/
999: l_start_gross_salary:=l_value;
1000: ELSE
1001:
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-1)); /*TO_DATE('31-jan-2001'));*/
1005: l_start_gross_salary:=l_value;
1006: END IF;

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

1009: IF l_termination_date IS NOT NULL THEN
1010: OPEN csr_final_process(l_person_id,l_termination_date-1);
1011: FETCH csr_final_process INTO l_final_process_date;
1012: CLOSE csr_final_process;
1013: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1014: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1015: --P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date,l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1016: P_VIRTUAL_DATE=>l_final_process_date);
1017: l_end_gross_salary:=l_value;

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

1016: P_VIRTUAL_DATE=>l_final_process_date);
1017: l_end_gross_salary:=l_value;
1018: l_gross_salary:=l_start_gross_salary- NVL(l_prev_gross_salary,0) + ((l_end_gross_salary-l_start_gross_salary));
1019: ELSE
1020: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1021: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1022: --P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date,l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1023: P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date));
1024: l_end_gross_salary:=l_value;

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

1030: l_prev_gross_salary:=l_prev_gross_salary+l_gross_salary;
1031: IF l_twenty_one_years < l_asg_start_date then
1032: emp_record(l_counter).l_gross_salary:=l_gross_salary;
1033: ELSE
1034: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1035: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1036: P_VIRTUAL_DATE=>LEAST((trunc(l_twenty_one_years,'MM')-1),l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1037: l_twenty_gross_salary:=l_value;
1038: 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 1048: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1044: -- ELSE
1045: END IF;
1046: --emp_record(l_counter).l_white_from:=l_white_from;
1047: /* emp_record(l_counter).l_end_date:= l_asg_end_date;
1048: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1049: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1050: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
1051: /* l_start_gross_salary:=l_value;
1052: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

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

1048: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1049: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1050: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
1051: /* l_start_gross_salary:=l_value;
1052: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1053: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1054: P_VIRTUAL_DATE=>l_period_end_date); /*TO_DATE('31-jan-2001'));*/
1055: /*l_end_gross_salary:=l_value;
1056: 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 1187: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);

1183: /* OPEN csr_assignment_action(p_payroll_action_id);
1184: FETCH csr_assignment_action INTO l_assignment_action_id;
1185: CLOSE csr_assignment_action;*/
1186: /* check whether the person has crossed 21 before the start of the year itself*/
1187: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
1188: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
1189: OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_TAXABLE_BASE_PER_LU_YTD');
1190: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1191: CLOSE csr_Get_Defined_Balance_Id;

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

1184: FETCH csr_assignment_action INTO l_assignment_action_id;
1185: CLOSE csr_assignment_action;*/
1186: /* check whether the person has crossed 21 before the start of the year itself*/
1187: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
1188: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
1189: OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_TAXABLE_BASE_PER_LU_YTD');
1190: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1191: CLOSE csr_Get_Defined_Balance_Id;
1192:

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

1216: CLOSE csr_next_local_unit;
1217: /*check whether the local unit is same in assignment and next local unit is different */
1218: /* In this case proration is not required */
1219: IF l_current_local_unit_id=l_local_unit_id AND l_next_local_unit_id <> l_local_unit_id THEN
1220: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1221: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1222: P_VIRTUAL_DATE=>l_asg_end_date);
1223: l_counter:=l_counter+1;
1224: l_gross_salary:=nvl(l_value,0)-l_prev_gross_salary;

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

1231: l_prev_gross_salary:=l_prev_gross_salary+l_gross_salary;
1232: /* check whether the local unit is different */
1233: /* no need to update the table, but calculate the balance values*/
1234: ELSIF l_current_local_unit_id<>l_local_unit_id THEN
1235: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1236: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1237: P_VIRTUAL_DATE=>l_asg_end_date);
1238: /* accumulating the previous salary values*/
1239: l_prev_gross_salary:=/*l_prev_gross_salary+*/nvl(l_value,0);

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

1243: IF l_asg_end_date>=l_end_date AND l_counter=0 THEN
1244: /* If the age of the person crosses 21 or greater than 21 */
1245: IF l_twenty_one_years<=l_start_date THEN
1246: /* Get the gross salary for whole year */
1247: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1248: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1249: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/);
1250: l_gross_salary:=l_value;
1251:

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

1249: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/);
1250: l_gross_salary:=l_value;
1251:
1252: ELSE
1253: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1254: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1255: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/);
1256: l_gross_salary:=l_value;
1257: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

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

1253: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1254: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1255: P_VIRTUAL_DATE=>l_end_date/*TO_DATE('31-jan-2001')*/);
1256: l_gross_salary:=l_value;
1257: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1258: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1259: P_VIRTUAL_DATE=>trunc(l_twenty_one_years,'MM')-1/*TO_DATE('31-jan-2001')*/);
1260: l_gross_salary:=l_gross_salary-l_value;
1261: END IF;

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

1299: --IF (l_prev_job = l_job AND l_prev_category = l_category) THEN
1300: IF (nvl(l_prev_job,'n') = nvl(l_job,'n') AND nvl(l_prev_category,'n') = nvl(l_category,'n')) THEN
1301: /*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*/
1302: emp_record(l_counter).l_end_date:= l_asg_end_date;
1303: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1304: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1305: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
1306: l_start_gross_salary:=l_value;
1307:

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

1305: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
1306: l_start_gross_salary:=l_value;
1307:
1308:
1309: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1310: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1311: P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date)); /*TO_DATE('31-jan-2001'));*/
1312: l_end_gross_salary:=l_value;
1313: 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 1321: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1317: l_prev_gross_salary:=l_prev_gross_salary+l_gross_salary;
1318: ELSE
1319: /* IF the end period exceeds the l_end_date then */
1320: IF l_asg_end_date>=l_end_date THEN
1321: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1322: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1323: P_VIRTUAL_DATE=>l_end_date); /*TO_DATE('31-jan-2001'));*/
1324: l_gross_salary:=l_value-l_prev_gross_salary;
1325:

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

1385: /*IF l_prev_category<>'WC' AND l_category='WC' THEN
1386: emp_record(l_counter).l_termination:=l_terminated;
1387: END IF;*/
1388: IF l_asg_start_date=l_period_start_date THEN
1389: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1390: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1391: P_VIRTUAL_DATE=>(l_period_start_date)); /*TO_DATE('31-jan-2001'));*/
1392: l_start_gross_salary:=l_value;
1393: ELSE

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

1390: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1391: P_VIRTUAL_DATE=>(l_period_start_date)); /*TO_DATE('31-jan-2001'));*/
1392: l_start_gross_salary:=l_value;
1393: ELSE
1394: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1395: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1396: P_VIRTUAL_DATE=>(l_period_start_date-1)); /*TO_DATE('31-jan-2001'));*/
1397: l_start_gross_salary:=l_value;
1398: END IF;

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

1401: IF l_termination_date IS NOT NULL THEN
1402: OPEN csr_final_process(l_person_id,l_termination_date-1);
1403: FETCH csr_final_process INTO l_final_process_date;
1404: CLOSE csr_final_process;
1405: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1406: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1407: --P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date,l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1408: P_VIRTUAL_DATE=>l_final_process_date);
1409: l_end_gross_salary:=l_value;

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

1408: P_VIRTUAL_DATE=>l_final_process_date);
1409: l_end_gross_salary:=l_value;
1410: l_gross_salary:=l_start_gross_salary- NVL(l_prev_gross_salary,0) + ((l_end_gross_salary-l_start_gross_salary));
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=>least(l_period_end_date,l_end_date,l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1415: P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date));
1416: l_end_gross_salary:=l_value;

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

1417:
1418: 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);
1419: END IF;
1420:
1421: /*l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1422: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1423: --P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date,l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1424: /*P_VIRTUAL_DATE=>least(l_period_end_date,l_end_date));
1425: l_end_gross_salary:=l_value;

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

1430:
1431: IF l_twenty_one_years < l_asg_start_date then
1432: emp_record(l_counter).l_gross_salary:=l_gross_salary;
1433: ELSE
1434: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1435: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1436: P_VIRTUAL_DATE=>LEAST((trunc(l_twenty_one_years,'MM')-1),l_asg_end_date)); /*TO_DATE('31-jan-2001'));*/
1437: l_twenty_gross_salary:=l_value;
1438: 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 1446: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1442: -- ELSE
1443: END IF;
1444: --emp_record(l_counter).l_white_from:=l_white_from;
1445: /* emp_record(l_counter).l_end_date:= l_asg_end_date;
1446: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1447: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1448: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
1449: /* l_start_gross_salary:=l_value;
1450:

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

1447: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1448: P_VIRTUAL_DATE=>greatest(l_period_start_date-1,l_twenty_one_years)); /*TO_DATE('31-jan-2001'));*/
1449: /* l_start_gross_salary:=l_value;
1450:
1451: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1452: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1453: P_VIRTUAL_DATE=>l_period_end_date); /*TO_DATE('31-jan-2001'));*/
1454: /*l_end_gross_salary:=l_value;
1455: 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 1718: (pay_balance_pkg.get_value

1714: CLOSE csr_def_bal_id;
1715:
1716: l_return_balance_value :=
1717: TO_CHAR
1718: (pay_balance_pkg.get_value
1719: (p_defined_balance_id => l_defined_balance_id
1720: , p_assignment_id => p_in_assignment_id
1721: , p_virtual_date => p_in_virtual_date
1722: )