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 625: l_person_type_id_date_bind := hr_api.g_sot;

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

Line 671: l_location_id_date_bind := hr_api.g_sot;

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

Line 704: l_legal_entity_id_date_bind := hr_api.g_sot;

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

Line 740: l_payroll_id_date_bind := hr_api.g_sot;

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

Line 742: l_payroll_id_date2_bind := hr_api.g_sot;

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

Line 781: l_pstl_zip_rng_id_date_bind := hr_api.g_sot;

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

Line 782: l_pstl_zip_rng_id_date2_bind := hr_api.g_sot;

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

Line 783: l_pstl_zip_rng_id_date3_bind := hr_api.g_sot;

779: ELSE
780: --
781: l_pstl_zip_rng_id_date_bind := hr_api.g_sot;
782: l_pstl_zip_rng_id_date2_bind := hr_api.g_sot;
783: l_pstl_zip_rng_id_date3_bind := hr_api.g_sot;
784: l_pstl_zip_rng_id_bind := -1;
785: l_pstl_zip_rng_id_date4_bind := hr_api.g_sot;
786: --
787: l_query_str :=

Line 785: l_pstl_zip_rng_id_date4_bind := hr_api.g_sot;

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

Line 826: l_organization_id_date_bind := hr_api.g_sot;

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

Line 828: l_organization_id_date2_bind := hr_api.g_sot;

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

Line 829: l_organization_id_date3_bind := hr_api.g_sot;

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

Line 1290: l_person_type_id_date_bind := hr_api.g_sot;

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

Line 1325: l_location_id_date_bind := hr_api.g_sot;

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

Line 1350: l_cagr_id_date_bind := hr_api.g_sot;

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

Line 1434: l_legal_entity_id_date_bind := hr_api.g_sot;

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

Line 1462: l_payroll_id_date_bind := hr_api.g_sot;

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

Line 1464: l_payroll_id_date2_bind := hr_api.g_sot;

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

Line 1495: l_pstl_zip_rng_id_date_bind := hr_api.g_sot;

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

Line 1496: l_pstl_zip_rng_id_date2_bind := hr_api.g_sot;

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

Line 1497: l_pstl_zip_rng_id_date3_bind := hr_api.g_sot;

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

Line 1499: l_pstl_zip_rng_id_date4_bind := hr_api.g_sot;

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

Line 1531: l_organization_id_date_bind := hr_api.g_sot;

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

Line 1533: l_organization_id_date2_bind := hr_api.g_sot;

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

Line 1534: l_organization_id_date3_bind := hr_api.g_sot;

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

Line 1601: l_org_heirarchy_date := hr_api.g_sot;

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

Line 1659: l_grade_ladder_date2_bind := hr_api.g_sot;

1655: else
1656: -- bug 3171229 -- make variables date2,3,4 as sot
1657: -- let l_grade_ladder_date_bind be effective date
1658:
1659: l_grade_ladder_date2_bind := hr_api.g_sot;
1660: l_grade_ladder_date3_bind := hr_api.g_sot;
1661: l_grade_ladder_date4_bind := hr_api.g_sot;
1662:
1663:

Line 1660: l_grade_ladder_date3_bind := hr_api.g_sot;

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

Line 1661: l_grade_ladder_date4_bind := hr_api.g_sot;

1657: -- let l_grade_ladder_date_bind be effective date
1658:
1659: l_grade_ladder_date2_bind := hr_api.g_sot;
1660: l_grade_ladder_date3_bind := hr_api.g_sot;
1661: l_grade_ladder_date4_bind := hr_api.g_sot;
1662:
1663:
1664: -- bug 3171229 -- changed the bind variable order in the sql
1665: l_query_str :=

Line 1691: l_grade_ladder_date3_bind := hr_api.g_sot;

1687: --
1688: l_grade_ladder_bind := -1;
1689: l_grade_ladder_date_bind := p_effective_date; /* GSP Rate Sync */
1690: l_grade_ladder_date2_bind := p_effective_date;
1691: l_grade_ladder_date3_bind := hr_api.g_sot;
1692: l_grade_ladder_date4_bind := hr_api.g_sot;
1693:
1694: /* Bug 4030438
1695: -- For GSP Rate Sync, check EITHER

Line 1692: l_grade_ladder_date4_bind := hr_api.g_sot;

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

Line 1724: l_grade_ladder_date_bind := hr_api.g_sot;

1720:
1721: else
1722: --
1723: l_grade_ladder_bind := -1;
1724: l_grade_ladder_date_bind := hr_api.g_sot;
1725: l_grade_ladder_date2_bind := hr_api.g_sot;
1726: l_grade_ladder_date3_bind := hr_api.g_sot;
1727: l_grade_ladder_date4_bind := hr_api.g_sot;
1728:

Line 1725: l_grade_ladder_date2_bind := hr_api.g_sot;

1721: else
1722: --
1723: l_grade_ladder_bind := -1;
1724: l_grade_ladder_date_bind := hr_api.g_sot;
1725: l_grade_ladder_date2_bind := hr_api.g_sot;
1726: l_grade_ladder_date3_bind := hr_api.g_sot;
1727: l_grade_ladder_date4_bind := hr_api.g_sot;
1728:
1729: l_query_str :=

Line 1726: l_grade_ladder_date3_bind := hr_api.g_sot;

1722: --
1723: l_grade_ladder_bind := -1;
1724: l_grade_ladder_date_bind := hr_api.g_sot;
1725: l_grade_ladder_date2_bind := hr_api.g_sot;
1726: l_grade_ladder_date3_bind := hr_api.g_sot;
1727: l_grade_ladder_date4_bind := hr_api.g_sot;
1728:
1729: l_query_str :=
1730: l_query_str || ' and -1 =:grade_ladder_id'||

Line 1727: l_grade_ladder_date4_bind := hr_api.g_sot;

1723: l_grade_ladder_bind := -1;
1724: l_grade_ladder_date_bind := hr_api.g_sot;
1725: l_grade_ladder_date2_bind := hr_api.g_sot;
1726: l_grade_ladder_date3_bind := hr_api.g_sot;
1727: l_grade_ladder_date4_bind := hr_api.g_sot;
1728:
1729: l_query_str :=
1730: l_query_str || ' and -1 =:grade_ladder_id'||
1731: ' and :grade_ladder_id_date is not null'||

Line 1784: l_rate_id_date_bind := hr_api.g_sot;

1780: ' and spp.parent_spine_id = :rate_id'||
1781: ' and :effective_date between spp.effective_start_date and spp.effective_end_date)';
1782: ELSE
1783: l_rate_id_bind := -1 ;
1784: l_rate_id_date_bind := hr_api.g_sot;
1785: l_query_str :=
1786: l_query_str || ' and :effective_date is not null'||
1787: ' and -1 = :rate_id'||
1788: ' and :effective_date is not null';

Line 1933: l_concat_segs_date := hr_api.g_sot;

1929:
1930: l_query_str := l_query_str || ')' ;
1931:
1932: ELSE
1933: l_concat_segs_date := hr_api.g_sot;
1934:
1935: l_query_str :=
1936: l_query_str || ' and :effective_date is not null';
1937: