APPS.AHL_LTP_SPACE_SCHEDULE_PVT dependencies on AHL_SPACES_VL

Line 843: l_sql_string1 := l_sql_string1 || ' from ahl_spaces_vl a , ahl_space_assignments b, fnd_lookup_values_vl c,';

839: l_sql_string1 := ' SELECT distinct(a.space_id), space_name, space_category, meaning,';
840: l_sql_string1 := l_sql_string1 || ' a.bom_department_id, department_code, d.description,';
841: l_sql_string1 := l_sql_string1 || ' a.organization_id, e.name org_name ';
842: -- From Clause
843: l_sql_string1 := l_sql_string1 || ' from ahl_spaces_vl a , ahl_space_assignments b, fnd_lookup_values_vl c,';
844: l_sql_string1 := l_sql_string1 || ' bom_departments d, hr_all_organization_units e ';
845: -- Where Clause
846: l_sql_string1 := l_sql_string1 || ' where c.lookup_type(+) = ''AHL_LTP_SPACE_CATEGORY''';
847: l_sql_string1 := l_sql_string1 || ' and c.lookup_code(+) = a.space_category';

Line 1897: l_sql_string1 := l_sql_string1 || ' from ahl_spaces_vl a , ahl_space_assignments b, fnd_lookup_values_vl c,';

1893: l_sql_string1 := ' SELECT distinct(a.space_id), space_name, space_category, meaning,';
1894: l_sql_string1 := l_sql_string1 || ' a.bom_department_id, department_code, d.description,';
1895: l_sql_string1 := l_sql_string1 || ' a.organization_id, e.name org_name ';
1896: -- From Clause
1897: l_sql_string1 := l_sql_string1 || ' from ahl_spaces_vl a , ahl_space_assignments b, fnd_lookup_values_vl c,';
1898: l_sql_string1 := l_sql_string1 || ' bom_departments d, hr_all_organization_units e ';
1899: -- Where Clause
1900: l_sql_string1 := l_sql_string1 || ' where c.lookup_type(+) = ''AHL_LTP_SPACE_CATEGORY''';
1901: l_sql_string1 := l_sql_string1 || ' and c.lookup_code(+) = a.space_category';

Line 2943: l_sql_string1 := l_sql_string1 || ' from ahl_spaces_vl a , ahl_space_assignments b, fnd_lookup_values_vl c,';

2939: l_sql_string1 := ' SELECT distinct(a.space_id), space_name, space_category, meaning,';
2940: l_sql_string1 := l_sql_string1 || ' a.bom_department_id, department_code, d.description,';
2941: l_sql_string1 := l_sql_string1 || ' a.organization_id, e.name org_name ';
2942: -- From Clause
2943: l_sql_string1 := l_sql_string1 || ' from ahl_spaces_vl a , ahl_space_assignments b, fnd_lookup_values_vl c,';
2944: l_sql_string1 := l_sql_string1 || ' bom_departments d, hr_all_organization_units e ';
2945: -- Where Clause
2946: l_sql_string1 := l_sql_string1 || ' where c.lookup_type(+) = ''AHL_LTP_SPACE_CATEGORY''';
2947: l_sql_string1 := l_sql_string1 || ' and c.lookup_code(+) = a.space_category';

Line 5423: FROM AHL_SPACES_VL

5419: c_space_name IN VARCHAR2,
5420: c_dept_id IN NUMBER)
5421: IS
5422: SELECT space_id,space_name
5423: FROM AHL_SPACES_VL
5424: WHERE bom_department_id = c_dept_id
5425: AND (space_id = c_space_id
5426: OR space_name = c_space_name);
5427: -- Get visits associated at department level