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

Line 357: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);

353: ,g_ref_date
354: ,g_archive
355: );
356:
357: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
358: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
359: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
360: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
361: pay_balance_pkg.set_context('SOURCE_ID',NULL);

Line 358: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);

354: ,g_archive
355: );
356:
357: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
358: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
359: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
360: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
361: pay_balance_pkg.set_context('SOURCE_ID',NULL);
362: pay_balance_pkg.set_context('TAX_GROUP',NULL);

Line 359: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));

355: );
356:
357: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
358: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
359: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
360: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
361: pay_balance_pkg.set_context('SOURCE_ID',NULL);
362: pay_balance_pkg.set_context('TAX_GROUP',NULL);
363: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);

Line 360: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);

356:
357: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
358: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
359: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
360: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
361: pay_balance_pkg.set_context('SOURCE_ID',NULL);
362: pay_balance_pkg.set_context('TAX_GROUP',NULL);
363: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);
364:

Line 361: pay_balance_pkg.set_context('SOURCE_ID',NULL);

357: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
358: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
359: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
360: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
361: pay_balance_pkg.set_context('SOURCE_ID',NULL);
362: pay_balance_pkg.set_context('TAX_GROUP',NULL);
363: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);
364:
365: IF g_archive = 'Y'

Line 362: pay_balance_pkg.set_context('TAX_GROUP',NULL);

358: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
359: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
360: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
361: pay_balance_pkg.set_context('SOURCE_ID',NULL);
362: pay_balance_pkg.set_context('TAX_GROUP',NULL);
363: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);
364:
365: IF g_archive = 'Y'
366: THEN

Line 363: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);

359: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
360: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
361: pay_balance_pkg.set_context('SOURCE_ID',NULL);
362: pay_balance_pkg.set_context('TAX_GROUP',NULL);
363: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);
364:
365: IF g_archive = 'Y'
366: THEN
367: -- *****************************************************************************

Line 1385: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id);

1381: -- Pick up the Balance value
1382: l_assignment_id :=lr_get_person_details.assignment_id;
1383: fnd_file.put_line(fnd_file.log,'l_assignment_id ==> '||l_assignment_id );
1384: BEGIN
1385: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id);
1386:
1387: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1388: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1389: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));

Line 1387: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);

1383: fnd_file.put_line(fnd_file.log,'l_assignment_id ==> '||l_assignment_id );
1384: BEGIN
1385: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id);
1386:
1387: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1388: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1389: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
1390: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1391: pay_balance_pkg.set_context('SOURCE_ID',NULL);

Line 1388: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);

1384: BEGIN
1385: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id);
1386:
1387: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1388: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1389: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
1390: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1391: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1392: pay_balance_pkg.set_context('TAX_GROUP',NULL);

Line 1389: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));

1385: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id);
1386:
1387: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1388: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1389: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
1390: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1391: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1392: pay_balance_pkg.set_context('TAX_GROUP',NULL);
1393: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);

Line 1390: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);

1386:
1387: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1388: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1389: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
1390: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1391: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1392: pay_balance_pkg.set_context('TAX_GROUP',NULL);
1393: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);
1394:

Line 1391: pay_balance_pkg.set_context('SOURCE_ID',NULL);

1387: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1388: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1389: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
1390: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1391: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1392: pay_balance_pkg.set_context('TAX_GROUP',NULL);
1393: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);
1394:
1395: END;

Line 1392: pay_balance_pkg.set_context('TAX_GROUP',NULL);

1388: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1389: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
1390: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1391: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1392: pay_balance_pkg.set_context('TAX_GROUP',NULL);
1393: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);
1394:
1395: END;
1396: -- *****************************************************************************

Line 1393: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);

1389: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
1390: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1391: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1392: pay_balance_pkg.set_context('TAX_GROUP',NULL);
1393: pay_balance_pkg.set_context('ORGANIZATION_ID',g_pension_provider_id);
1394:
1395: END;
1396: -- *****************************************************************************
1397: -- IF local unit selected then pick up the Local Unit context Balance

Line 1408: l_Sal_subject_pension_MTD :=to_char(pay_balance_pkg.get_value

1404:
1405: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1406: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1407:
1408: l_Sal_subject_pension_MTD :=to_char(pay_balance_pkg.get_value
1409: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1410: P_ASSIGNMENT_ID =>l_assignment_id ,
1411: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1412:

Line 1422: l_bik_subject_pension_MTD :=to_char(pay_balance_pkg.get_value

1418: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1419: CLOSE csr_Get_Defined_Balance_Id;
1420:
1421: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );
1422: l_bik_subject_pension_MTD :=to_char(pay_balance_pkg.get_value
1423: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1424: P_ASSIGNMENT_ID =>l_assignment_id ,
1425: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1426:

Line 1436: l_tax_exp_subject_pension_MTD :=to_char(pay_balance_pkg.get_value

1432: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1433: CLOSE csr_Get_Defined_Balance_Id;
1434:
1435: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1436: l_tax_exp_subject_pension_MTD :=to_char(pay_balance_pkg.get_value
1437: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1438: P_ASSIGNMENT_ID =>l_assignment_id ,
1439: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1440:

Line 1454: l_Sal_subject_pension_QTD :=to_char(pay_balance_pkg.get_value

1450:
1451: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1452: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1453:
1454: l_Sal_subject_pension_QTD :=to_char(pay_balance_pkg.get_value
1455: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1456: P_ASSIGNMENT_ID =>l_assignment_id ,
1457: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1458:

Line 1469: l_bik_subject_pension_QTD :=to_char(pay_balance_pkg.get_value

1465: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1466: CLOSE csr_Get_Defined_Balance_Id;
1467:
1468: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );
1469: l_bik_subject_pension_QTD :=to_char(pay_balance_pkg.get_value
1470: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1471: P_ASSIGNMENT_ID =>l_assignment_id ,
1472: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1473:

Line 1484: l_tax_exp_subject_pension_QTD :=to_char(pay_balance_pkg.get_value

1480: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1481: CLOSE csr_Get_Defined_Balance_Id;
1482:
1483: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1484: l_tax_exp_subject_pension_QTD :=to_char(pay_balance_pkg.get_value
1485: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1486: P_ASSIGNMENT_ID =>l_assignment_id ,
1487: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1488:

Line 1501: l_Sal_subject_pension_YTD :=to_char(pay_balance_pkg.get_value

1497:
1498: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1499: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1500:
1501: l_Sal_subject_pension_YTD :=to_char(pay_balance_pkg.get_value
1502: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1503: P_ASSIGNMENT_ID =>l_assignment_id ,
1504: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1505:

Line 1513: l_sal_sub_pension_YTD_before :=to_char(pay_balance_pkg.get_value

1509: -- Salary Balance value before termination date
1510:
1511: IF lr_get_person_details.PER_INFORMATION20 IS NOT NULL
1512: THEN
1513: l_sal_sub_pension_YTD_before :=to_char(pay_balance_pkg.get_value
1514: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1515: P_ASSIGNMENT_ID =>l_assignment_id ,
1516: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1517: ELSE

Line 1530: l_bik_subject_pension_YTD :=to_char(pay_balance_pkg.get_value

1526: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1527: CLOSE csr_Get_Defined_Balance_Id;
1528:
1529: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1530: l_bik_subject_pension_YTD :=to_char(pay_balance_pkg.get_value
1531: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1532: P_ASSIGNMENT_ID =>l_assignment_id ,
1533: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1534:

Line 1540: l_bik_sub_pension_YTD_before :=to_char(pay_balance_pkg.get_value

1536: -- *****************************************************************************
1537: -- Balance value before termination date
1538: IF lr_get_person_details.PER_INFORMATION20 IS NOT NULL
1539: THEN
1540: l_bik_sub_pension_YTD_before :=to_char(pay_balance_pkg.get_value
1541: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1542: P_ASSIGNMENT_ID =>l_assignment_id ,
1543: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1544: ELSE

Line 1557: l_tax_exp_subject_pension_YTD :=to_char(pay_balance_pkg.get_value

1553: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LU_YEAR');
1554: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1555: CLOSE csr_Get_Defined_Balance_Id;
1556:
1557: l_tax_exp_subject_pension_YTD :=to_char(pay_balance_pkg.get_value
1558: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1559: P_ASSIGNMENT_ID =>l_assignment_id ,
1560: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1561:

Line 1572: l_tax_exp_pension_YTD_before :=to_char(pay_balance_pkg.get_value

1568: CLOSE csr_Get_Defined_Balance_Id;
1569:
1570: IF lr_get_person_details.PER_INFORMATION20 IS NOT NULL
1571: THEN
1572: l_tax_exp_pension_YTD_before :=to_char(pay_balance_pkg.get_value
1573: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1574: P_ASSIGNMENT_ID =>l_assignment_id ,
1575: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1576: ELSE

Line 1593: l_Sal_subject_pension_MTD :=to_char(pay_balance_pkg.get_value

1589:
1590: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );
1591: fnd_file.put_line(fnd_file.log,'g_effective_date ==> '||g_effective_date );
1592:
1593: l_Sal_subject_pension_MTD :=to_char(pay_balance_pkg.get_value
1594: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1595: P_ASSIGNMENT_ID =>l_assignment_id ,
1596: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1597:

Line 1605: l_bik_subject_pension_MTD :=to_char(pay_balance_pkg.get_value

1601: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LE_MONTH');
1602: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1603: CLOSE csr_Get_Defined_Balance_Id;
1604:
1605: l_bik_subject_pension_MTD :=to_char(pay_balance_pkg.get_value
1606: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1607: P_ASSIGNMENT_ID =>l_assignment_id ,
1608: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1609:

Line 1619: l_tax_exp_subject_pension_MTD :=to_char(pay_balance_pkg.get_value

1615: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LE_MONTH');
1616: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1617: CLOSE csr_Get_Defined_Balance_Id;
1618:
1619: l_tax_exp_subject_pension_MTD :=to_char(pay_balance_pkg.get_value
1620: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1621: P_ASSIGNMENT_ID =>l_assignment_id ,
1622: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1623:

Line 1635: l_Sal_subject_pension_QTD :=to_char(pay_balance_pkg.get_value

1631:
1632: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );
1633: fnd_file.put_line(fnd_file.log,'g_effective_date ==> '||g_effective_date );
1634:
1635: l_Sal_subject_pension_QTD :=to_char(pay_balance_pkg.get_value
1636: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1637: P_ASSIGNMENT_ID =>l_assignment_id ,
1638: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1639:

Line 1648: l_bik_subject_pension_QTD :=to_char(pay_balance_pkg.get_value

1644: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LE_QUARTER');
1645: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1646: CLOSE csr_Get_Defined_Balance_Id;
1647:
1648: l_bik_subject_pension_QTD :=to_char(pay_balance_pkg.get_value
1649: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1650: P_ASSIGNMENT_ID =>l_assignment_id ,
1651: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1652:

Line 1663: l_tax_exp_subject_pension_QTD :=to_char(pay_balance_pkg.get_value

1659: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LE_QUARTER');
1660: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1661: CLOSE csr_Get_Defined_Balance_Id;
1662:
1663: l_tax_exp_subject_pension_QTD :=to_char(pay_balance_pkg.get_value
1664: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1665: P_ASSIGNMENT_ID =>l_assignment_id ,
1666: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1667:

Line 1681: l_Sal_subject_pension_YTD :=to_char(pay_balance_pkg.get_value

1677:
1678: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1679: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1680:
1681: l_Sal_subject_pension_YTD :=to_char(pay_balance_pkg.get_value
1682: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1683: P_ASSIGNMENT_ID =>l_assignment_id ,
1684: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1685:

Line 1693: l_sal_sub_pension_YTD_before :=to_char(pay_balance_pkg.get_value

1689: -- Salary Balance value before termination date
1690:
1691: IF lr_get_person_details.PER_INFORMATION20 IS NOT NULL
1692: THEN
1693: l_sal_sub_pension_YTD_before :=to_char(pay_balance_pkg.get_value
1694: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1695: P_ASSIGNMENT_ID =>l_assignment_id ,
1696: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1697: ELSE

Line 1708: l_bik_subject_pension_YTD :=to_char(pay_balance_pkg.get_value

1704: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LE_YEAR');
1705: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1706: CLOSE csr_Get_Defined_Balance_Id;
1707:
1708: l_bik_subject_pension_YTD :=to_char(pay_balance_pkg.get_value
1709: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1710: P_ASSIGNMENT_ID =>l_assignment_id ,
1711: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1712:

Line 1718: l_bik_sub_pension_YTD_before :=to_char(pay_balance_pkg.get_value

1714: -- *****************************************************************************
1715: -- Balance value before termination date
1716: IF lr_get_person_details.PER_INFORMATION20 IS NOT NULL
1717: THEN
1718: l_bik_sub_pension_YTD_before :=to_char(pay_balance_pkg.get_value
1719: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1720: P_ASSIGNMENT_ID =>l_assignment_id ,
1721: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1722: ELSE

Line 1733: l_tax_exp_subject_pension_YTD :=to_char(pay_balance_pkg.get_value

1729: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LE_YEAR');
1730: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1731: CLOSE csr_Get_Defined_Balance_Id;
1732:
1733: l_tax_exp_subject_pension_YTD :=to_char(pay_balance_pkg.get_value
1734: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1735: P_ASSIGNMENT_ID =>l_assignment_id ,
1736: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1737:

Line 1746: l_tax_exp_pension_YTD_before :=to_char(pay_balance_pkg.get_value

1742: CLOSE csr_Get_Defined_Balance_Id;
1743: -- Taxable Expenses Balance value before termination date
1744: IF lr_get_person_details.PER_INFORMATION20 IS NOT NULL
1745: THEN
1746: l_tax_exp_pension_YTD_before :=to_char(pay_balance_pkg.get_value
1747: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1748: P_ASSIGNMENT_ID =>l_assignment_id ,
1749: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1750: ELSE