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_JP_ITWB_REPORT_PKG dependencies on HR_API

Line 1540: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_soy

1536: where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
1537: and pos.primary_structure_flag = 'Y'
1538: and posv.organization_structure_id = pos.organization_structure_id
1539: and posv.date_from <= g_effective_eoy
1540: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_soy
1541: and not exists(
1542: select null
1543: from per_org_structure_versions posv2
1544: where posv2.organization_structure_id = pos.organization_structure_id

Line 1546: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_soy

1542: select null
1543: from per_org_structure_versions posv2
1544: where posv2.organization_structure_id = pos.organization_structure_id
1545: and posv2.date_from <= g_effective_eoy
1546: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_soy
1547: and posv2.version_number > posv.version_number)
1548: and pose.org_structure_version_id = posv.org_structure_version_id
1549: start with pose.organization_id_parent = g_organization_id
1550: connect by prior pose.organization_id_child = pose.organization_id_parent

Line 1611: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_soy

1607: where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
1608: and pos.primary_structure_flag = 'Y'
1609: and posv.organization_structure_id = pos.organization_structure_id
1610: and posv.date_from <= g_effective_eoy
1611: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_soy
1612: and not exists(
1613: select null
1614: from per_org_structure_versions posv2
1615: where posv2.organization_structure_id = pos.organization_structure_id

Line 1617: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_soy

1613: select null
1614: from per_org_structure_versions posv2
1615: where posv2.organization_structure_id = pos.organization_structure_id
1616: and posv2.date_from <= g_effective_eoy
1617: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_soy
1618: and posv2.version_number > posv.version_number)
1619: and pose.org_structure_version_id = posv.org_structure_version_id
1620: start with pose.organization_id_parent = g_organization_id
1621: connect by prior pose.organization_id_child = pose.organization_id_parent

Line 2200: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_soy

2196: where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
2197: and pos.primary_structure_flag = 'Y'
2198: and posv.organization_structure_id = pos.organization_structure_id
2199: and posv.date_from <= g_effective_eoy
2200: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_soy
2201: and not exists(
2202: select null
2203: from per_org_structure_versions posv2
2204: where posv2.organization_structure_id = pos.organization_structure_id

Line 2206: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_soy

2202: select null
2203: from per_org_structure_versions posv2
2204: where posv2.organization_structure_id = pos.organization_structure_id
2205: and posv2.date_from <= g_effective_eoy
2206: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_soy
2207: and posv2.version_number > posv.version_number)
2208: and pose.org_structure_version_id = posv.org_structure_version_id
2209: start with pose.organization_id_parent = g_organization_id
2210: connect by prior pose.organization_id_child = pose.organization_id_parent