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 462: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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