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 PER_ORG_STRUCTURE_VERSIONS

Line 1534: per_org_structure_versions posv,

1530: and pjia.organization_id in (
1531: select /*+ ORDERED */
1532: distinct pose.organization_id_child
1533: from per_organization_structures pos,
1534: per_org_structure_versions posv,
1535: per_org_structure_elements pose
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

Line 1543: from per_org_structure_versions posv2

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
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)

Line 1605: per_org_structure_versions posv,

1601: and pjia.organization_id in (
1602: select /*+ ORDERED */
1603: distinct pose.organization_id_child
1604: from per_organization_structures pos,
1605: per_org_structure_versions posv,
1606: per_org_structure_elements pose
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

Line 1614: from per_org_structure_versions posv2

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
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)

Line 2194: per_org_structure_versions posv,

2190: and pjia.organization_id in (
2191: select /*+ ORDERED */
2192: distinct pose.organization_id_child
2193: from per_organization_structures pos,
2194: per_org_structure_versions posv,
2195: per_org_structure_elements pose
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

Line 2203: from per_org_structure_versions posv2

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
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)