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.PER_EMPDIR_SS dependencies on HR_MULTI_TENANCY_PKG

Line 465: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN

461: 'WHERE p.position_id = ptl.position_id'||
462: ' AND :1 between p.effective_start_date AND p.effective_end_date'||
463: ' AND p.business_group_id = oi.organization_id'||
464: ' AND oi.org_information_context = ''Business Group Information''';
465: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
466: query_str := query_str || ' AND p.position_id NOT IN '||
467: ' (SELECT lp.position_id FROM hr_all_positions_f lp'||
468: ' WHERE label_to_char(lp.HR_ENTERPRISE) = ''C::ENT'' OR label_to_char(lp.HR_ENTERPRISE) is null)';
469: END IF;

Line 724: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN

720: ' ,object_version_number' ||
721: ' ,1 ' ||
722: ' FROM hr_locations_all l';
723: IF (p_mode = 0) THEN
724: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
725: query_str := query_str || ' WHERE label_to_char(HR_ENTERPRISE) <> ''C::ENT''';
726: END IF;
727:
728: OPEN p_cursor FOR query_str;

Line 734: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN

730: query_str := query_str || ' WHERE EXISTS (SELECT ''e'' FROM per_empdir_locations il' ||
731: ' WHERE il.orig_system_id = l.location_id'||
732: ' AND il.orig_system = ''' || g_srcSystem || '''' ||
733: ' AND il.object_version_number <> l.object_version_number)';
734: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
735: query_str := query_str || ' AND label_to_char(HR_ENTERPRISE) <> ''C::ENT''';
736: END IF;
737: OPEN p_cursor FOR query_str;
738: ELSIF (p_mode = 2) THEN

Line 742: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN

738: ELSIF (p_mode = 2) THEN
739: query_str := query_str || ' WHERE NOT EXISTS (SELECT ''e'' FROM per_empdir_locations il' ||
740: ' WHERE il.orig_system_id = l.location_id' ||
741: ' AND il.orig_system = ''' || g_srcSystem || ''')';
742: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
743: query_str := query_str || ' AND label_to_char(HR_ENTERPRISE) <> ''C::ENT''';
744: END IF;
745: OPEN p_cursor FOR query_str;
746: END IF;

Line 1114: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN

1110: ' WHERE :3 BETWEEN effective_start_date AND effective_end_date'||
1111: ' GROUP BY assignment_id HAVING count(*) > 1)'||
1112: ' AND paf.assignment_type in (''E'',''C'')';
1113:
1114: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
1115: query_str := query_str || ' AND paf.assignment_id NOT IN '||
1116: ' (SELECT assignment_id FROM per_all_assignments_f lpaf'||
1117: ' WHERE label_to_char(lpaf.HR_ENTERPRISE) = ''C::ENT'' OR label_to_char(lpaf.HR_ENTERPRISE) is null)';
1118: END IF;

Line 1423: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN

1419: ' /* Avoiding PK Violation */'||
1420: ' AND houtl.organization_id NOT IN '||
1421: ' (SELECT organization_id FROM hr_all_organization_units ihou'||
1422: ' GROUP BY organization_id HAVING count(*) > 1)';
1423: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
1424: query_str := query_str || ' AND houtl.organization_id NOT IN '||
1425: ' (SELECT organization_id FROM hr_all_organization_units lhou'||
1426: ' WHERE label_to_char(lhou.HR_ENTERPRISE) = ''C::ENT'' OR label_to_char(lhou.HR_ENTERPRISE) is null)';
1427: END IF;

Line 1626: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN

1622: 'AND jtl.name is not null '||
1623: 'AND j.business_group_id = :1 '||
1624: 'AND j.business_group_id = oi.organization_id '||
1625: 'AND oi.org_information_context = ''Business Group Information''';
1626: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
1627: query_str := query_str || ' AND j.job_id NOT IN '||
1628: ' (SELECT job_id FROM per_jobs lj'||
1629: ' WHERE label_to_char(lj.HR_ENTERPRISE) = ''C::ENT'' OR label_to_char(lj.HR_ENTERPRISE) is null)';
1630: END IF;

Line 2197: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN

2193: ' AND ppf.person_id NOT IN' ||
2194: ' (SELECT person_id FROM per_all_people_f ippf' ||
2195: ' WHERE :4 BETWEEN effective_start_date AND effective_end_date' ||
2196: ' GROUP BY person_id HAVING count(*) > 1)';
2197: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
2198: query_str := query_str || ' AND ppf.person_id NOT IN '||
2199: ' (SELECT person_id FROM per_all_people_f lppf'||
2200: ' WHERE label_to_char(lppf.HR_ENTERPRISE) = ''C::ENT'' OR label_to_char(lppf.HR_ENTERPRISE) is null)';
2201: END IF;

Line 2291: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN

2287: ' AND ph.parent_table(+) = ''PER_ALL_PEOPLE_F''' ||
2288: ' AND ph.parent_id(+) = ppf.person_id' ||
2289: ' AND ph.phone_type(+) = ''W1''' ||
2290: ' AND :2 BETWEEN date_from(+) AND nvl(date_to(+),:3 +1)';
2291: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
2292: query_str := query_str || ' AND ppf.person_id NOT IN '||
2293: ' (SELECT person_id FROM per_all_people_f lppf'||
2294: ' WHERE label_to_char(lppf.HR_ENTERPRISE) = ''C::ENT'' OR label_to_char(lppf.HR_ENTERPRISE) is null)';
2295: END IF;

Line 2386: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN

2382: '/* Picking up not exists from per_empdir_people */' ||
2383: ' AND NOT EXISTS (SELECT ''e'' from per_empdir_people ip' ||
2384: ' WHERE ip.orig_system_id = ppf.person_id' ||
2385: ' AND ip.orig_system = ''' || g_srcSystem || ''')';
2386: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
2387: query_str := query_str || ' AND ppf.person_id NOT IN '||
2388: ' (SELECT person_id FROM per_all_people_f lppf'||
2389: ' WHERE label_to_char(lppf.HR_ENTERPRISE) = ''C::ENT'' OR label_to_char(lppf.HR_ENTERPRISE) is null)';
2390: END IF;