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.HR_JP_DATA_MIGRATION_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 470: from per_all_assignments_f pa,

466: INDEX(PA PER_ASSIGNMENTS_F_PK) */
467: pbg.business_group_id bg_id,
468: pbg.name bg_name,
469: pa.assignment_number ass_num
470: from per_all_assignments_f pa,
471: per_business_groups_perf pbg
472: where pa.assignment_id = p_assignment_id
473: and p_effective_date
474: between pa.effective_start_date and pa.effective_end_date

Line 1429: per_all_assignments_f pa

1425: pbg.name bg_name,
1426: pa.assignment_id,
1427: pa.assignment_number
1428: from per_business_groups_perf pbg,
1429: per_all_assignments_f pa
1430: where pbg.legislation_code = g_legislation_code
1431: and pa.business_group_id = pbg.business_group_id
1432: and pa.effective_start_date = (
1433: select /*+ INDEX(PA2 PER_ASSIGNMENTS_F_PK) */

Line 1435: from per_all_assignments_f pa2

1431: and pa.business_group_id = pbg.business_group_id
1432: and pa.effective_start_date = (
1433: select /*+ INDEX(PA2 PER_ASSIGNMENTS_F_PK) */
1434: max(pa2.effective_start_date)
1435: from per_all_assignments_f pa2
1436: where pa2.assignment_id = pa.assignment_id);
1437: --
1438: l_csr_range_ass csr_range_ass%rowtype;
1439: --

Line 1851: from per_all_assignments_f pa,

1847: cursor csr_cei_target
1848: is
1849: select /*+ ORDERED */
1850: pp_c.person_id
1851: from per_all_assignments_f pa,
1852: per_contact_relationships pcr,
1853: per_contact_extra_info_f pcei,
1854: per_all_people_f pp_c
1855: where pa.assignment_id = p_assignment_id

Line 1889: from per_all_assignments_f pa,

1885: cursor csr_cei_oe_target
1886: is
1887: select /*+ ORDERED */
1888: pp_c.person_id
1889: from per_all_assignments_f pa,
1890: per_contact_relationships pcr,
1891: per_contact_extra_info_f pcei,
1892: per_all_people_f pp_c
1893: where pa.assignment_id = p_assignment_id

Line 1915: from per_all_assignments_f pa,

1911: cursor csr_ee_target
1912: is
1913: select /*+ ORDERED */
1914: pcei.contact_extra_info_id
1915: from per_all_assignments_f pa,
1916: per_contact_relationships pcr,
1917: per_contact_extra_info_f pcei
1918: where pa.assignment_id = p_assignment_id
1919: and p_session_date

Line 1931: from per_all_assignments_f pa,

1927: cursor csr_ft_cei
1928: is
1929: select /*+ ORDERED */
1930: pcei.contact_extra_info_id
1931: from per_all_assignments_f pa,
1932: per_contact_relationships pcr,
1933: per_contact_extra_info_f pcei,
1934: per_all_people_f pp_c
1935: where pa.assignment_id = p_assignment_id

Line 1955: from per_all_assignments_f pa,

1951: cursor csr_ft_cei_oe
1952: is
1953: select /*+ ORDERED */
1954: pcei.contact_extra_info_id
1955: from per_all_assignments_f pa,
1956: per_contact_relationships pcr,
1957: per_contact_extra_info_f pcei,
1958: per_all_people_f pp_c
1959: where pa.assignment_id = p_assignment_id

Line 2304: from per_all_assignments_f pa,

2300: to_date(decode(to_char(nvl(least(pp_c.date_of_death,p_session_date),p_session_date),'YYYY/MM/DD'),
2301: to_char(pp_c.date_of_death,'YYYY/MM/DD'),to_char(pp_c.date_of_death,'YYYY/MM/DD'),
2302: to_char((add_months(trunc(p_session_date,'YYYY'),12) - 1),'YYYY/MM/DD')),'YYYY/MM/DD') + 1,
2303: pp_c.date_of_birth) / 12) c_age
2304: from per_all_assignments_f pa,
2305: per_contact_relationships pcr,
2306: per_contact_extra_info_f pcei,
2307: per_all_people_f pp_c
2308: where pa.assignment_id = p_assignment_id

Line 2351: from per_all_assignments_f pa,

2347: to_date(decode(to_char(nvl(least(pp_c.date_of_death,p_session_date),p_session_date),'YYYY/MM/DD'),
2348: to_char(pp_c.date_of_death,'YYYY/MM/DD'),to_char(pp_c.date_of_death,'YYYY/MM/DD'),
2349: to_char((add_months(trunc(p_session_date,'YYYY'),12) - 1),'YYYY/MM/DD')),'YYYY/MM/DD') + 1,
2350: pp_c.date_of_birth) / 12) c_age
2351: from per_all_assignments_f pa,
2352: per_contact_relationships pcr,
2353: per_contact_extra_info_f pcei,
2354: per_all_people_f pp_c
2355: where pa.assignment_id = p_assignment_id

Line 2378: from per_all_assignments_f pa,

2374: cursor csr_ee
2375: is
2376: select /*+ ORDERED */
2377: pcei.contact_extra_info_id
2378: from per_all_assignments_f pa,
2379: per_contact_relationships pcr,
2380: per_contact_extra_info_f pcei
2381: where pa.assignment_id = p_assignment_id
2382: and p_session_date

Line 2787: per_all_assignments_f pa

2783: pbg.name bg_name,
2784: pa.assignment_id,
2785: pa.assignment_number
2786: from per_business_groups_perf pbg,
2787: per_all_assignments_f pa
2788: where pbg.legislation_code = g_legislation_code
2789: and pa.business_group_id = pbg.business_group_id
2790: and pa.effective_start_date = (
2791: select /*+ INDEX(PA2 PER_ASSIGNMENTS_F_PK) */

Line 2793: from per_all_assignments_f pa2

2789: and pa.business_group_id = pbg.business_group_id
2790: and pa.effective_start_date = (
2791: select /*+ INDEX(PA2 PER_ASSIGNMENTS_F_PK) */
2792: max(pa2.effective_start_date)
2793: from per_all_assignments_f pa2
2794: where pa2.assignment_id = pa.assignment_id);
2795: --
2796: l_csr_range_ass csr_range_ass%rowtype;
2797: --