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

Line 242: between nvl(fnd_date.canonical_to_date(hoi.org_information5),hr_api.g_sot) and nvl(fnd_date.canonical_to_date(hoi.org_information6),g_effective_date);

238: and hoi.org_information1 = 'JPEMPLDETAILSREPORT'
239: and hoi.org_information3 = 'ADDINFO'
240: and hoi.org_information4 is not null
241: and g_effective_date
242: between nvl(fnd_date.canonical_to_date(hoi.org_information5),hr_api.g_sot) and nvl(fnd_date.canonical_to_date(hoi.org_information6),g_effective_date);
243: --
244: l_csr_action csr_action%rowtype;
245: --
246: begin

Line 520: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_date

516: where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
517: and pos.primary_structure_flag = 'Y'
518: and posv.organization_structure_id = pos.organization_structure_id
519: and posv.date_from <= g_effective_date
520: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_date
521: and not exists(
522: select null
523: from per_org_structure_versions posv2
524: where posv2.organization_structure_id = pos.organization_structure_id

Line 526: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_date

522: select null
523: from per_org_structure_versions posv2
524: where posv2.organization_structure_id = pos.organization_structure_id
525: and posv2.date_from <= g_effective_date
526: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_date
527: and posv2.version_number > posv.version_number)
528: and pose.org_structure_version_id = posv.org_structure_version_id
529: start with pose.organization_id_parent = g_organization_id
530: connect by prior pose.organization_id_child = pose.organization_id_parent

Line 588: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_date

584: where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
585: and pos.primary_structure_flag = 'Y'
586: and posv.organization_structure_id = pos.organization_structure_id
587: and posv.date_from <= g_effective_date
588: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_date
589: and not exists(
590: select null
591: from per_org_structure_versions posv2
592: where posv2.organization_structure_id = pos.organization_structure_id

Line 594: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_date

590: select null
591: from per_org_structure_versions posv2
592: where posv2.organization_structure_id = pos.organization_structure_id
593: and posv2.date_from <= g_effective_date
594: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_date
595: and posv2.version_number > posv.version_number)
596: and pose.org_structure_version_id = posv.org_structure_version_id
597: start with pose.organization_id_parent = g_organization_id
598: connect by prior pose.organization_id_child = pose.organization_id_parent

Line 660: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_date

656: where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
657: and pos.primary_structure_flag = 'Y'
658: and posv.organization_structure_id = pos.organization_structure_id
659: and posv.date_from <= g_effective_date
660: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_date
661: and not exists(
662: select null
663: from per_org_structure_versions posv2
664: where posv2.organization_structure_id = pos.organization_structure_id

Line 666: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_date

662: select null
663: from per_org_structure_versions posv2
664: where posv2.organization_structure_id = pos.organization_structure_id
665: and posv2.date_from <= g_effective_date
666: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_date
667: and posv2.version_number > posv.version_number)
668: and pose.org_structure_version_id = posv.org_structure_version_id
669: start with pose.organization_id_parent = g_organization_id
670: connect by prior pose.organization_id_child = pose.organization_id_parent

Line 732: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_date

728: where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
729: and pos.primary_structure_flag = 'Y'
730: and posv.organization_structure_id = pos.organization_structure_id
731: and posv.date_from <= g_effective_date
732: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_date
733: and not exists(
734: select null
735: from per_org_structure_versions posv2
736: where posv2.organization_structure_id = pos.organization_structure_id

Line 738: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_date

734: select null
735: from per_org_structure_versions posv2
736: where posv2.organization_structure_id = pos.organization_structure_id
737: and posv2.date_from <= g_effective_date
738: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_date
739: and posv2.version_number > posv.version_number)
740: and pose.org_structure_version_id = posv.org_structure_version_id
741: start with pose.organization_id_parent = g_organization_id
742: connect by prior pose.organization_id_child = pose.organization_id_parent

Line 1536: between pj.date_from (+) and nvl(pj.date_to(+), hr_api.g_eot)

1532: per_phones pphm,
1533: per_phones pphw
1534: where pj.job_id (+) = v.job_id
1535: and v.effective_date_ass
1536: between pj.date_from (+) and nvl(pj.date_to(+), hr_api.g_eot)
1537: and pac.person_id (+) = v.person_id
1538: and pac.address_type (+) = 'JP_C'
1539: and v.effective_date_ass
1540: between pac.date_from (+) and nvl(pac.date_to(+), hr_api.g_eot)

Line 1540: between pac.date_from (+) and nvl(pac.date_to(+), hr_api.g_eot)

1536: between pj.date_from (+) and nvl(pj.date_to(+), hr_api.g_eot)
1537: and pac.person_id (+) = v.person_id
1538: and pac.address_type (+) = 'JP_C'
1539: and v.effective_date_ass
1540: between pac.date_from (+) and nvl(pac.date_to(+), hr_api.g_eot)
1541: and pphh.parent_id (+) = v.person_id
1542: and pphh.phone_type (+) = 'H1'
1543: and v.effective_date_ass
1544: between pphh.date_from (+) and nvl(pphh.date_to(+), hr_api.g_eot)

Line 1544: between pphh.date_from (+) and nvl(pphh.date_to(+), hr_api.g_eot)

1540: between pac.date_from (+) and nvl(pac.date_to(+), hr_api.g_eot)
1541: and pphh.parent_id (+) = v.person_id
1542: and pphh.phone_type (+) = 'H1'
1543: and v.effective_date_ass
1544: between pphh.date_from (+) and nvl(pphh.date_to(+), hr_api.g_eot)
1545: and pphm.parent_id (+) = v.person_id
1546: and pphm.phone_type (+) = 'M'
1547: and v.effective_date_ass
1548: between pphm.date_from (+) and nvl(pphm.date_to(+), hr_api.g_eot)

Line 1548: between pphm.date_from (+) and nvl(pphm.date_to(+), hr_api.g_eot)

1544: between pphh.date_from (+) and nvl(pphh.date_to(+), hr_api.g_eot)
1545: and pphm.parent_id (+) = v.person_id
1546: and pphm.phone_type (+) = 'M'
1547: and v.effective_date_ass
1548: between pphm.date_from (+) and nvl(pphm.date_to(+), hr_api.g_eot)
1549: and pphw.parent_id (+) = v.person_id
1550: and pphw.phone_type (+) = 'W1'
1551: and v.effective_date_ass
1552: between pphw.date_from (+) and nvl(pphw.date_to(+), hr_api.g_eot);

Line 1552: between pphw.date_from (+) and nvl(pphw.date_to(+), hr_api.g_eot);

1548: between pphm.date_from (+) and nvl(pphm.date_to(+), hr_api.g_eot)
1549: and pphw.parent_id (+) = v.person_id
1550: and pphw.phone_type (+) = 'W1'
1551: and v.effective_date_ass
1552: between pphw.date_from (+) and nvl(pphw.date_to(+), hr_api.g_eot);
1553: --
1554: cursor csr_trm_assact
1555: is
1556: select /*+ ORDERED */

Line 1596: between nvl(pac.start_date_active,hr_api.g_sot) and nvl(pac.end_date_active,l_effective_date_ass)

1592: and nvl(ppa.date_from,l_effective_date_ass) <= l_effective_date_ass
1593: and ppa.id_flex_num = c_jp_pea_flex_num
1594: and pac.analysis_criteria_id = ppa.analysis_criteria_id
1595: and l_effective_date_ass
1596: between nvl(pac.start_date_active,hr_api.g_sot) and nvl(pac.end_date_active,l_effective_date_ass)
1597: and pac.enabled_flag = 'Y';
1598: --
1599: cursor csr_emp_qua
1600: is

Line 1628: --to_date(decode(sign(hr_api.g_eot - etd_v.effective_end_date),1,to_char(etd_v.effective_end_date,'YYYY/MM/DD'),null),'YYYY/MM/DD') effective_end_date_d,

1624: std_v.assignment_id,
1625: std_v.assignment_number,
1626: std_v.effective_start_date,
1627: etd_v.effective_end_date,
1628: --to_date(decode(sign(hr_api.g_eot - etd_v.effective_end_date),1,to_char(etd_v.effective_end_date,'YYYY/MM/DD'),null),'YYYY/MM/DD') effective_end_date_d,
1629: to_date(decode(sign(l_effective_date_ass - etd_v.effective_end_date),-1,null,to_char(etd_v.effective_end_date,'YYYY/MM/DD')),'YYYY/MM/DD') effective_end_date_d,
1630: std_v.organization_id,
1631: hou.name organization_name,
1632: std_v.job_id,

Line 1733: --to_date(decode(sign(hr_api.g_eot - etd_v.effective_end_date),1,to_char(etd_v.effective_end_date,'YYYY/MM/DD'),null),'YYYY/MM/DD') effective_end_date_d,

1729: select /*+ ORDERED */
1730: std_v.assignment_id,
1731: std_v.effective_start_date,
1732: etd_v.effective_end_date,
1733: --to_date(decode(sign(hr_api.g_eot - etd_v.effective_end_date),1,to_char(etd_v.effective_end_date,'YYYY/MM/DD'),null),'YYYY/MM/DD') effective_end_date_d,
1734: to_date(decode(sign(l_effective_date_ass - etd_v.effective_end_date),-1,null,to_char(etd_v.effective_end_date,'YYYY/MM/DD')),'YYYY/MM/DD') effective_end_date_d,
1735: std_v.organization_id,
1736: hou.name organization_name,
1737: std_v.job_id,

Line 1829: to_date(decode(sign(hr_api.g_eot - pa.effective_end_date),1,to_char(pa.effective_end_date,'YYYY/MM/DD'),null),'YYYY/MM/DD') effective_end_date_d,

1825: select ppos.date_start hire_date,
1826: ppos.actual_termination_date term_date,
1827: pa.effective_start_date,
1828: pa.effective_end_date,
1829: to_date(decode(sign(hr_api.g_eot - pa.effective_end_date),1,to_char(pa.effective_end_date,'YYYY/MM/DD'),null),'YYYY/MM/DD') effective_end_date_d,
1830: pa.organization_id,
1831: hou.name organization_name,
1832: pa.job_id,
1833: pj.name job_name

Line 1896: between nvl(pcr.date_start,hr_api.g_sot) and nvl(pcr.date_end,l_effective_date_ass)

1892: from per_contact_relationships pcr,
1893: per_all_people_f pp
1894: where pcr.person_id = l_person_id
1895: and l_effective_date_ass
1896: between nvl(pcr.date_start,hr_api.g_sot) and nvl(pcr.date_end,l_effective_date_ass)
1897: and pp.person_id = pcr.contact_person_id
1898: and (l_effective_date_ass
1899: between pp.effective_start_date and pp.effective_end_date
1900: or (pp.effective_start_date = pp.start_date