APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 1515: from per_all_assignments_f pa,

1511: to_char(nvl(ppos.actual_termination_date,g_effective_date),'YYYY/MM/DD')),'YYYY/MM/DD') effective_date_ass,
1512: to_date(decode(nvl(g_inc_term_flag,'N'),
1513: 'N',to_char(least(nvl(ppos.final_process_date,g_effective_date),g_effective_date),'YYYY/MM/DD'),
1514: to_char(nvl(ppos.final_process_date,g_effective_date),'YYYY/MM/DD')),'YYYY/MM/DD') effective_date_proc
1515: from per_all_assignments_f pa,
1516: per_periods_of_service ppos,
1517: per_all_people_f pp
1518: where pa.assignment_id = p_assignment_id
1519: and ppos.period_of_service_id = pa.period_of_service_id

Line 1647: from per_all_assignments_f pa_std

1643: pa_std.position_id,
1644: pa_std.grade_id,
1645: pa_std.effective_start_date,
1646: pa_std.effective_end_date
1647: from per_all_assignments_f pa_std
1648: where pa_std.assignment_id = p_assignment_id
1649: and pa_std.effective_start_date <= l_effective_date_ass
1650: and (exists(
1651: select null

Line 1652: from per_all_assignments_f pa_sp

1648: where pa_std.assignment_id = p_assignment_id
1649: and pa_std.effective_start_date <= l_effective_date_ass
1650: and (exists(
1651: select null
1652: from per_all_assignments_f pa_sp
1653: where pa_sp.assignment_id = pa_std.assignment_id
1654: and pa_sp.effective_start_date <= l_effective_date_ass
1655: and (pa_sp.organization_id <> pa_std.organization_id
1656: or nvl(pa_sp.job_id,-1) <> nvl(pa_std.job_id,-1)

Line 1663: from per_all_assignments_f pa_sm

1659: and (pa_sp.effective_end_date + 1 = pa_std.effective_start_date
1660: or pa_sp.effective_start_date = pa_std.effective_end_date + 1))
1661: or not exists(
1662: select null
1663: from per_all_assignments_f pa_sm
1664: where pa_sm.assignment_id = pa_std.assignment_id
1665: and pa_sm.effective_start_date <= l_effective_date_ass
1666: and pa_sm.effective_start_date < pa_std.effective_start_date))
1667: and not exists(

Line 1669: from per_all_assignments_f pa_se

1665: and pa_sm.effective_start_date <= l_effective_date_ass
1666: and pa_sm.effective_start_date < pa_std.effective_start_date))
1667: and not exists(
1668: select null
1669: from per_all_assignments_f pa_se
1670: where pa_se.assignment_id = pa_std.assignment_id
1671: and pa_se.effective_start_date <= l_effective_date_ass
1672: and pa_se.organization_id = pa_std.organization_id
1673: and nvl(pa_se.job_id,-1) = nvl(pa_std.job_id,-1)

Line 1686: from per_all_assignments_f pa_etd

1682: pa_etd.position_id,
1683: pa_etd.grade_id,
1684: pa_etd.effective_start_date,
1685: pa_etd.effective_end_date
1686: from per_all_assignments_f pa_etd
1687: where pa_etd.assignment_id = p_assignment_id
1688: and pa_etd.effective_start_date <= l_effective_date_ass
1689: and (exists(
1690: select null

Line 1691: from per_all_assignments_f pa_ep

1687: where pa_etd.assignment_id = p_assignment_id
1688: and pa_etd.effective_start_date <= l_effective_date_ass
1689: and (exists(
1690: select null
1691: from per_all_assignments_f pa_ep
1692: where pa_ep.assignment_id = pa_etd.assignment_id
1693: and pa_ep.effective_start_date <= l_effective_date_ass
1694: and (pa_ep.organization_id <> pa_etd.organization_id
1695: or nvl(pa_ep.job_id,-1) <> nvl(pa_etd.job_id,-1)

Line 1702: from per_all_assignments_f pa_em

1698: and (pa_ep.effective_end_date + 1 = pa_etd.effective_start_date
1699: or pa_ep.effective_start_date = pa_etd.effective_end_date + 1))
1700: or not exists(
1701: select null
1702: from per_all_assignments_f pa_em
1703: where pa_em.assignment_id = pa_etd.assignment_id
1704: and pa_em.effective_start_date <= l_effective_date_ass
1705: and pa_em.effective_start_date > pa_etd.effective_start_date))
1706: and not exists(

Line 1708: from per_all_assignments_f pa_ee

1704: and pa_em.effective_start_date <= l_effective_date_ass
1705: and pa_em.effective_start_date > pa_etd.effective_start_date))
1706: and not exists(
1707: select null
1708: from per_all_assignments_f pa_ee
1709: where pa_ee.assignment_id = pa_etd.assignment_id
1710: and pa_ee.effective_start_date <= l_effective_date_ass
1711: and pa_ee.organization_id = pa_etd.organization_id
1712: and nvl(pa_ee.job_id,-1) = nvl(pa_etd.job_id,-1)

Line 1748: from per_all_assignments_f pa_std

1744: pa_std.job_id,
1745: pa_std.position_id,
1746: pa_std.effective_start_date,
1747: pa_std.effective_end_date
1748: from per_all_assignments_f pa_std
1749: where pa_std.assignment_id = p_assignment_id
1750: and pa_std.effective_start_date <= l_effective_date_ass
1751: and (exists(
1752: select null

Line 1753: from per_all_assignments_f pa_sp

1749: where pa_std.assignment_id = p_assignment_id
1750: and pa_std.effective_start_date <= l_effective_date_ass
1751: and (exists(
1752: select null
1753: from per_all_assignments_f pa_sp
1754: where pa_sp.assignment_id = pa_std.assignment_id
1755: and pa_sp.effective_start_date <= l_effective_date_ass
1756: and (pa_sp.organization_id <> pa_std.organization_id
1757: or nvl(pa_sp.job_id,-1) <> nvl(pa_std.job_id,-1)

Line 1763: from per_all_assignments_f pa_sm

1759: and (pa_sp.effective_end_date + 1 = pa_std.effective_start_date
1760: or pa_sp.effective_start_date = pa_std.effective_end_date + 1))
1761: or not exists(
1762: select null
1763: from per_all_assignments_f pa_sm
1764: where pa_sm.assignment_id = pa_std.assignment_id
1765: and pa_sm.effective_start_date <= l_effective_date_ass
1766: and pa_sm.effective_start_date < pa_std.effective_start_date))
1767: and not exists(

Line 1769: from per_all_assignments_f pa_se

1765: and pa_sm.effective_start_date <= l_effective_date_ass
1766: and pa_sm.effective_start_date < pa_std.effective_start_date))
1767: and not exists(
1768: select null
1769: from per_all_assignments_f pa_se
1770: where pa_se.assignment_id = pa_std.assignment_id
1771: and pa_se.effective_start_date <= l_effective_date_ass
1772: and pa_se.organization_id = pa_std.organization_id
1773: and nvl(pa_se.job_id,-1) = nvl(pa_std.job_id,-1)

Line 1784: from per_all_assignments_f pa_etd

1780: pa_etd.job_id,
1781: pa_etd.position_id,
1782: pa_etd.effective_start_date,
1783: pa_etd.effective_end_date
1784: from per_all_assignments_f pa_etd
1785: where pa_etd.assignment_id = p_assignment_id
1786: and pa_etd.effective_start_date <= l_effective_date_ass
1787: and (exists(
1788: select null

Line 1789: from per_all_assignments_f pa_ep

1785: where pa_etd.assignment_id = p_assignment_id
1786: and pa_etd.effective_start_date <= l_effective_date_ass
1787: and (exists(
1788: select null
1789: from per_all_assignments_f pa_ep
1790: where pa_ep.assignment_id = pa_etd.assignment_id
1791: and pa_ep.effective_start_date <= l_effective_date_ass
1792: and (pa_ep.organization_id <> pa_etd.organization_id
1793: or nvl(pa_ep.job_id,-1) <> nvl(pa_etd.job_id,-1)

Line 1799: from per_all_assignments_f pa_em

1795: and (pa_ep.effective_end_date + 1 = pa_etd.effective_start_date
1796: or pa_ep.effective_start_date = pa_etd.effective_end_date + 1))
1797: or not exists(
1798: select null
1799: from per_all_assignments_f pa_em
1800: where pa_em.assignment_id = pa_etd.assignment_id
1801: and pa_em.effective_start_date <= l_effective_date_ass
1802: and pa_em.effective_start_date > pa_etd.effective_start_date))
1803: and not exists(

Line 1805: from per_all_assignments_f pa_ee

1801: and pa_em.effective_start_date <= l_effective_date_ass
1802: and pa_em.effective_start_date > pa_etd.effective_start_date))
1803: and not exists(
1804: select null
1805: from per_all_assignments_f pa_ee
1806: where pa_ee.assignment_id = pa_etd.assignment_id
1807: and pa_ee.effective_start_date <= l_effective_date_ass
1808: and pa_ee.organization_id = pa_etd.organization_id
1809: and nvl(pa_ee.job_id,-1) = nvl(pa_etd.job_id,-1)

Line 1835: per_all_assignments_f pa,

1831: hou.name organization_name,
1832: pa.job_id,
1833: pj.name job_name
1834: from per_periods_of_service ppos,
1835: per_all_assignments_f pa,
1836: hr_organization_units hou,
1837: per_jobs_vl pj
1838: where ppos.person_id = l_person_id
1839: and ppos.date_start < l_hire_date