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.BEN_BENBATCH_PERSONS dependencies on HR_API

Line 622: l_person_type_id_date_bind := hr_api.g_sot;

618:
619: -- Changed the query for fixing Bug 2224299
620: -- l_query_str := l_query_str || ' and -1 = :person_type_id';
621:
622: l_person_type_id_date_bind := hr_api.g_sot;
623: l_query_str := l_query_str ||
624: ' and -1 = :person_type_id and :person_type_id_date IS NOT NULL';
625: --
626: END IF;

Line 668: l_location_id_date_bind := hr_api.g_sot;

664: --
665: ELSE
666: --
667: l_location_id_bind := -1;
668: l_location_id_date_bind := hr_api.g_sot;
669: l_query_str :=
670: l_query_str ||
671: ' and :location_id_date IS NOT NULL and -1 = :location_id ';
672: END IF;

Line 701: l_legal_entity_id_date_bind := hr_api.g_sot;

697: and number columns */
698: --
699: ELSE
700: --
701: l_legal_entity_id_date_bind := hr_api.g_sot;
702: l_legal_entity_id_bind := -1;
703: l_query_str :=
704: l_query_str ||
705: ' and :legal_entity_id_date IS NOT NULL and -1 = :legal_entity_id ';

Line 737: l_payroll_id_date_bind := hr_api.g_sot;

733: ' and pay.effective_end_date)';
734: --
735: ELSE
736: --
737: l_payroll_id_date_bind := hr_api.g_sot;
738: l_payroll_id_bind := -1;
739: l_payroll_id_date2_bind := hr_api.g_sot;
740: --
741: l_query_str :=

Line 739: l_payroll_id_date2_bind := hr_api.g_sot;

735: ELSE
736: --
737: l_payroll_id_date_bind := hr_api.g_sot;
738: l_payroll_id_bind := -1;
739: l_payroll_id_date2_bind := hr_api.g_sot;
740: --
741: l_query_str :=
742: l_query_str ||
743: ' and :payroll_id_date IS NOT NULL and -1 = :payroll_id' ||

Line 778: l_pstl_zip_rng_id_date_bind := hr_api.g_sot;

774: ' and rzr.effective_end_date)';
775: --
776: ELSE
777: --
778: l_pstl_zip_rng_id_date_bind := hr_api.g_sot;
779: l_pstl_zip_rng_id_date2_bind := hr_api.g_sot;
780: l_pstl_zip_rng_id_date3_bind := hr_api.g_sot;
781: l_pstl_zip_rng_id_bind := -1;
782: l_pstl_zip_rng_id_date4_bind := hr_api.g_sot;

Line 779: l_pstl_zip_rng_id_date2_bind := hr_api.g_sot;

775: --
776: ELSE
777: --
778: l_pstl_zip_rng_id_date_bind := hr_api.g_sot;
779: l_pstl_zip_rng_id_date2_bind := hr_api.g_sot;
780: l_pstl_zip_rng_id_date3_bind := hr_api.g_sot;
781: l_pstl_zip_rng_id_bind := -1;
782: l_pstl_zip_rng_id_date4_bind := hr_api.g_sot;
783: --

Line 780: l_pstl_zip_rng_id_date3_bind := hr_api.g_sot;

776: ELSE
777: --
778: l_pstl_zip_rng_id_date_bind := hr_api.g_sot;
779: l_pstl_zip_rng_id_date2_bind := hr_api.g_sot;
780: l_pstl_zip_rng_id_date3_bind := hr_api.g_sot;
781: l_pstl_zip_rng_id_bind := -1;
782: l_pstl_zip_rng_id_date4_bind := hr_api.g_sot;
783: --
784: l_query_str :=

Line 782: l_pstl_zip_rng_id_date4_bind := hr_api.g_sot;

778: l_pstl_zip_rng_id_date_bind := hr_api.g_sot;
779: l_pstl_zip_rng_id_date2_bind := hr_api.g_sot;
780: l_pstl_zip_rng_id_date3_bind := hr_api.g_sot;
781: l_pstl_zip_rng_id_bind := -1;
782: l_pstl_zip_rng_id_date4_bind := hr_api.g_sot;
783: --
784: l_query_str :=
785: l_query_str || ' and :pstl_zip_rng_id_date IS NOT NULL' ||
786: ' and :pstl_zip_rng_id_date2 IS NOT NULL' ||

Line 823: l_organization_id_date_bind := hr_api.g_sot;

819: ' and nvl(org.date_to,:organization_id_date3))';
820: --
821: ELSE
822: --
823: l_organization_id_date_bind := hr_api.g_sot;
824: l_organization_id_bind := -1;
825: l_organization_id_date2_bind := hr_api.g_sot;
826: l_organization_id_date3_bind := hr_api.g_sot;
827: --

Line 825: l_organization_id_date2_bind := hr_api.g_sot;

821: ELSE
822: --
823: l_organization_id_date_bind := hr_api.g_sot;
824: l_organization_id_bind := -1;
825: l_organization_id_date2_bind := hr_api.g_sot;
826: l_organization_id_date3_bind := hr_api.g_sot;
827: --
828: l_query_str :=
829: l_query_str || ' and :organization_id_date IS NOT NULL' ||

Line 826: l_organization_id_date3_bind := hr_api.g_sot;

822: --
823: l_organization_id_date_bind := hr_api.g_sot;
824: l_organization_id_bind := -1;
825: l_organization_id_date2_bind := hr_api.g_sot;
826: l_organization_id_date3_bind := hr_api.g_sot;
827: --
828: l_query_str :=
829: l_query_str || ' and :organization_id_date IS NOT NULL' ||
830: ' and -1 = :organization_id' ||

Line 1287: l_person_type_id_date_bind := hr_api.g_sot;

1283:
1284: -- Changed the query for fixing Bug 2224299
1285: -- l_query_str := l_query_str || ' and -1 = :person_type_id';
1286:
1287: l_person_type_id_date_bind := hr_api.g_sot;
1288: l_query_str := l_query_str ||
1289: ' and -1 = :person_type_id and :person_type_id_date IS NOT NULL';
1290:
1291: END IF;

Line 1322: l_location_id_date_bind := hr_api.g_sot;

1318: ' and paf.effective_end_date' ||
1319: ' and paf.location_id = :location_id)';
1320: ELSE
1321: l_location_id_bind := -1;
1322: l_location_id_date_bind := hr_api.g_sot;
1323: l_query_str :=
1324: l_query_str ||
1325: ' and :location_id_date IS NOT NULL and -1 = :location_id ';
1326: END IF;

Line 1347: l_cagr_id_date_bind := hr_api.g_sot;

1343: ' and paf.effective_end_date' ||
1344: ' and paf.collective_agreement_id = :cagr_id)';
1345: ELSE
1346: l_cagr_id_bind := -1;
1347: l_cagr_id_date_bind := hr_api.g_sot;
1348: l_query_str :=
1349: l_query_str ||
1350: ' and :cagr_id_date IS NOT NULL and -1 = :cagr_id ';
1351: END IF;

Line 1431: l_legal_entity_id_date_bind := hr_api.g_sot;

1427: ' and hsc.segment1 = to_char(:legal_entity_id)) ';
1428: /* Note the use of to_char this is for CBO joins between varchar2
1429: and number columns */
1430: ELSE
1431: l_legal_entity_id_date_bind := hr_api.g_sot;
1432: l_legal_entity_id_bind := -1;
1433: l_query_str :=
1434: l_query_str ||
1435: ' and :legal_entity_id_date IS NOT NULL and -1 = :legal_entity_id ';

Line 1459: l_payroll_id_date_bind := hr_api.g_sot;

1455: ' and :payroll_id_date2' ||
1456: ' between pay.effective_start_date' ||
1457: ' and pay.effective_end_date)';
1458: ELSE
1459: l_payroll_id_date_bind := hr_api.g_sot;
1460: l_payroll_id_bind := -1;
1461: l_payroll_id_date2_bind := hr_api.g_sot;
1462: l_query_str :=
1463: l_query_str ||

Line 1461: l_payroll_id_date2_bind := hr_api.g_sot;

1457: ' and pay.effective_end_date)';
1458: ELSE
1459: l_payroll_id_date_bind := hr_api.g_sot;
1460: l_payroll_id_bind := -1;
1461: l_payroll_id_date2_bind := hr_api.g_sot;
1462: l_query_str :=
1463: l_query_str ||
1464: ' and :payroll_id_date IS NOT NULL and -1 = :payroll_id' ||
1465: ' and :payroll_id_date2 IS NOT NULL ';

Line 1492: l_pstl_zip_rng_id_date_bind := hr_api.g_sot;

1488: ' and :pstl_zip_rng_id_date4' ||
1489: ' between rzr.effective_start_date' ||
1490: ' and rzr.effective_end_date)';
1491: ELSE
1492: l_pstl_zip_rng_id_date_bind := hr_api.g_sot;
1493: l_pstl_zip_rng_id_date2_bind := hr_api.g_sot;
1494: l_pstl_zip_rng_id_date3_bind := hr_api.g_sot;
1495: l_pstl_zip_rng_id_bind := -1;
1496: l_pstl_zip_rng_id_date4_bind := hr_api.g_sot;

Line 1493: l_pstl_zip_rng_id_date2_bind := hr_api.g_sot;

1489: ' between rzr.effective_start_date' ||
1490: ' and rzr.effective_end_date)';
1491: ELSE
1492: l_pstl_zip_rng_id_date_bind := hr_api.g_sot;
1493: l_pstl_zip_rng_id_date2_bind := hr_api.g_sot;
1494: l_pstl_zip_rng_id_date3_bind := hr_api.g_sot;
1495: l_pstl_zip_rng_id_bind := -1;
1496: l_pstl_zip_rng_id_date4_bind := hr_api.g_sot;
1497: l_query_str :=

Line 1494: l_pstl_zip_rng_id_date3_bind := hr_api.g_sot;

1490: ' and rzr.effective_end_date)';
1491: ELSE
1492: l_pstl_zip_rng_id_date_bind := hr_api.g_sot;
1493: l_pstl_zip_rng_id_date2_bind := hr_api.g_sot;
1494: l_pstl_zip_rng_id_date3_bind := hr_api.g_sot;
1495: l_pstl_zip_rng_id_bind := -1;
1496: l_pstl_zip_rng_id_date4_bind := hr_api.g_sot;
1497: l_query_str :=
1498: l_query_str || ' and :pstl_zip_rng_id_date IS NOT NULL' ||

Line 1496: l_pstl_zip_rng_id_date4_bind := hr_api.g_sot;

1492: l_pstl_zip_rng_id_date_bind := hr_api.g_sot;
1493: l_pstl_zip_rng_id_date2_bind := hr_api.g_sot;
1494: l_pstl_zip_rng_id_date3_bind := hr_api.g_sot;
1495: l_pstl_zip_rng_id_bind := -1;
1496: l_pstl_zip_rng_id_date4_bind := hr_api.g_sot;
1497: l_query_str :=
1498: l_query_str || ' and :pstl_zip_rng_id_date IS NOT NULL' ||
1499: ' and :pstl_zip_rng_id_date2 IS NOT NULL' ||
1500: ' and :pstl_zip_rng_id_date3 IS NOT NULL' ||

Line 1528: l_organization_id_date_bind := hr_api.g_sot;

1524: ' and :organization_id_date2' ||
1525: ' between org.date_from' ||
1526: ' and nvl(org.date_to,:organization_id_date3))';
1527: ELSE
1528: l_organization_id_date_bind := hr_api.g_sot;
1529: l_organization_id_bind := -1;
1530: l_organization_id_date2_bind := hr_api.g_sot;
1531: l_organization_id_date3_bind := hr_api.g_sot;
1532: l_query_str :=

Line 1530: l_organization_id_date2_bind := hr_api.g_sot;

1526: ' and nvl(org.date_to,:organization_id_date3))';
1527: ELSE
1528: l_organization_id_date_bind := hr_api.g_sot;
1529: l_organization_id_bind := -1;
1530: l_organization_id_date2_bind := hr_api.g_sot;
1531: l_organization_id_date3_bind := hr_api.g_sot;
1532: l_query_str :=
1533: l_query_str || ' and :organization_id_date IS NOT NULL' ||
1534: ' and -1 = :organization_id' ||

Line 1531: l_organization_id_date3_bind := hr_api.g_sot;

1527: ELSE
1528: l_organization_id_date_bind := hr_api.g_sot;
1529: l_organization_id_bind := -1;
1530: l_organization_id_date2_bind := hr_api.g_sot;
1531: l_organization_id_date3_bind := hr_api.g_sot;
1532: l_query_str :=
1533: l_query_str || ' and :organization_id_date IS NOT NULL' ||
1534: ' and -1 = :organization_id' ||
1535: ' and :organization_id_date2 IS NOT NULL' ||

Line 1598: l_org_heirarchy_date := hr_api.g_sot;

1594: ' and paf.assignment_type = ''E'''||
1595: ' )';
1596: ELSE
1597: -- bind variables
1598: l_org_heirarchy_date := hr_api.g_sot;
1599: l_org_heirarchy := -1;
1600: l_org_starting_node_id := -1;
1601: l_query_str :=
1602: l_query_str || ' and :org_heirarchy_date is not null'||

Line 1655: l_grade_ladder_date2_bind := hr_api.g_sot;

1651: else
1652: -- bug 3171229 -- make variables date2,3,4 as sot
1653: -- let l_grade_ladder_date_bind be effective date
1654:
1655: l_grade_ladder_date2_bind := hr_api.g_sot;
1656: l_grade_ladder_date3_bind := hr_api.g_sot;
1657: l_grade_ladder_date4_bind := hr_api.g_sot;
1658:
1659:

Line 1656: l_grade_ladder_date3_bind := hr_api.g_sot;

1652: -- bug 3171229 -- make variables date2,3,4 as sot
1653: -- let l_grade_ladder_date_bind be effective date
1654:
1655: l_grade_ladder_date2_bind := hr_api.g_sot;
1656: l_grade_ladder_date3_bind := hr_api.g_sot;
1657: l_grade_ladder_date4_bind := hr_api.g_sot;
1658:
1659:
1660: -- bug 3171229 -- changed the bind variable order in the sql

Line 1657: l_grade_ladder_date4_bind := hr_api.g_sot;

1653: -- let l_grade_ladder_date_bind be effective date
1654:
1655: l_grade_ladder_date2_bind := hr_api.g_sot;
1656: l_grade_ladder_date3_bind := hr_api.g_sot;
1657: l_grade_ladder_date4_bind := hr_api.g_sot;
1658:
1659:
1660: -- bug 3171229 -- changed the bind variable order in the sql
1661: l_query_str :=

Line 1686: l_grade_ladder_date3_bind := hr_api.g_sot;

1682: --
1683: l_grade_ladder_bind := -1;
1684: l_grade_ladder_date_bind := p_effective_date; /* GSP Rate Sync */
1685: l_grade_ladder_date2_bind := p_effective_date;
1686: l_grade_ladder_date3_bind := hr_api.g_sot;
1687: l_grade_ladder_date4_bind := hr_api.g_sot;
1688:
1689: /* Bug 4030438
1690: -- For GSP Rate Sync, check EITHER

Line 1687: l_grade_ladder_date4_bind := hr_api.g_sot;

1683: l_grade_ladder_bind := -1;
1684: l_grade_ladder_date_bind := p_effective_date; /* GSP Rate Sync */
1685: l_grade_ladder_date2_bind := p_effective_date;
1686: l_grade_ladder_date3_bind := hr_api.g_sot;
1687: l_grade_ladder_date4_bind := hr_api.g_sot;
1688:
1689: /* Bug 4030438
1690: -- For GSP Rate Sync, check EITHER
1691: -- (a) the person is assigned to Grade Ladder that allows salary updates

Line 1719: l_grade_ladder_date_bind := hr_api.g_sot;

1715:
1716: else
1717: --
1718: l_grade_ladder_bind := -1;
1719: l_grade_ladder_date_bind := hr_api.g_sot;
1720: l_grade_ladder_date2_bind := hr_api.g_sot;
1721: l_grade_ladder_date3_bind := hr_api.g_sot;
1722: l_grade_ladder_date4_bind := hr_api.g_sot;
1723:

Line 1720: l_grade_ladder_date2_bind := hr_api.g_sot;

1716: else
1717: --
1718: l_grade_ladder_bind := -1;
1719: l_grade_ladder_date_bind := hr_api.g_sot;
1720: l_grade_ladder_date2_bind := hr_api.g_sot;
1721: l_grade_ladder_date3_bind := hr_api.g_sot;
1722: l_grade_ladder_date4_bind := hr_api.g_sot;
1723:
1724: l_query_str :=

Line 1721: l_grade_ladder_date3_bind := hr_api.g_sot;

1717: --
1718: l_grade_ladder_bind := -1;
1719: l_grade_ladder_date_bind := hr_api.g_sot;
1720: l_grade_ladder_date2_bind := hr_api.g_sot;
1721: l_grade_ladder_date3_bind := hr_api.g_sot;
1722: l_grade_ladder_date4_bind := hr_api.g_sot;
1723:
1724: l_query_str :=
1725: l_query_str || ' and -1 =:grade_ladder_id'||

Line 1722: l_grade_ladder_date4_bind := hr_api.g_sot;

1718: l_grade_ladder_bind := -1;
1719: l_grade_ladder_date_bind := hr_api.g_sot;
1720: l_grade_ladder_date2_bind := hr_api.g_sot;
1721: l_grade_ladder_date3_bind := hr_api.g_sot;
1722: l_grade_ladder_date4_bind := hr_api.g_sot;
1723:
1724: l_query_str :=
1725: l_query_str || ' and -1 =:grade_ladder_id'||
1726: ' and :grade_ladder_id_date is not null'||

Line 1779: l_rate_id_date_bind := hr_api.g_sot;

1775: ' and spp.parent_spine_id = :rate_id'||
1776: ' and :effective_date between spp.effective_start_date and spp.effective_end_date)';
1777: ELSE
1778: l_rate_id_bind := -1 ;
1779: l_rate_id_date_bind := hr_api.g_sot;
1780: l_query_str :=
1781: l_query_str || ' and :effective_date is not null'||
1782: ' and -1 = :rate_id'||
1783: ' and :effective_date is not null';

Line 1928: l_concat_segs_date := hr_api.g_sot;

1924:
1925: l_query_str := l_query_str || ')' ;
1926:
1927: ELSE
1928: l_concat_segs_date := hr_api.g_sot;
1929:
1930: l_query_str :=
1931: l_query_str || ' and :effective_date is not null';
1932: