DBA Data[Home] [Help]

APPS.PAY_JP_ITWB_REPORT_PKG dependencies on PER_ORGANIZATION_STRUCTURES

Line 1533: from per_organization_structures pos,

1529: and nvl(g_inc_org_hier_flag,'N') = 'Y'
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'

Line 1604: from per_organization_structures pos,

1600: and nvl(g_inc_org_hier_flag,'N') = 'Y'
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'

Line 2193: from per_organization_structures pos,

2189: and nvl(g_inc_org_hier_flag,'N') = 'Y'
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'