APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on DUAL

Line 538: from dual))

534: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
535: and hou.organization_id <> hou.business_group_id
536: union
537: select g_organization_id
538: from dual))
539: or (g_organization_id is not null
540: and nvl(g_inc_org_hier_flag,'Y') = 'N'
541: and pa.organization_id = g_organization_id))
542: order by ppr.person_id;

Line 606: from dual))

602: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
603: and hou.organization_id <> hou.business_group_id
604: union
605: select g_organization_id
606: from dual))
607: or (g_organization_id is not null
608: and nvl(g_inc_org_hier_flag,'Y') = 'N'
609: and pa.organization_id = g_organization_id))
610: and to_number(decode(nvl(to_char(g_ass_set_formula_id),'-1'),'-1',

Line 678: from dual))

674: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
675: and hou.organization_id <> hou.business_group_id
676: union
677: select g_organization_id
678: from dual))
679: or (g_organization_id is not null
680: and nvl(g_inc_org_hier_flag,'Y') = 'N'
681: and pa.organization_id = g_organization_id))
682: and pp.person_id = pa.person_id

Line 750: from dual))

746: where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
747: and hou.organization_id <> hou.business_group_id
748: union
749: select g_organization_id
750: from dual))
751: or (g_organization_id is not null
752: and nvl(g_inc_org_hier_flag,'Y') = 'N'
753: and pa.organization_id = g_organization_id))
754: and to_number(decode(nvl(to_char(g_ass_set_formula_id),'-1'),'-1',

Line 1252: from dual;

1248: end if;
1249: --
1250: select pay_assignment_actions_s.nextval
1251: into l_assignment_action_id
1252: from dual;
1253: --
1254: if g_debug
1255: and g_detail_debug = 'Y' then
1256: l_assact_step := 29;