APPS.PAY_SE_ARCHIVE_TETA dependencies on HR_ORGANIZATION_UNITS

Line 261: ,hr_organization_units o1

257: SELECT assign.assignment_id
258: FROM
259: per_all_assignments_f assign
260: ,hr_soft_coding_keyflex scl
261: ,hr_organization_units o1
262: ,hr_organization_information hoi1
263: ,hr_organization_information hoi2
264: ,hr_organization_information hoi3
265: WHERE assign.person_id= csr_v_person_id

Line 382: ,hr_organization_units o1

378: ,trunc(decode(assign.effective_end_date,to_date('31/12/4712','dd/mm/yyyy'), g_date_report ,assign.effective_end_date) ) effective_end_date
379: FROM
380: per_all_assignments_f assign
381: ,hr_soft_coding_keyflex scl
382: ,hr_organization_units o1
383: ,hr_organization_information hoi1
384: ,hr_organization_information hoi2
385: ,hr_organization_information hoi3
386: WHERE assign.assignment_id = csr_v_assign_id

Line 417: ,hr_organization_units o1

413: ,sum(decode(assign.effective_end_date,to_date('31/12/4712','dd/mm/yyyy'), g_date_report ,assign.effective_end_date) - assign.effective_start_date ) days_worked
414: FROM
415: per_all_assignments_f assign
416: ,hr_soft_coding_keyflex scl
417: ,hr_organization_units o1
418: ,hr_organization_information hoi1
419: ,hr_organization_information hoi2
420: ,hr_organization_information hoi3
421: WHERE assign.assignment_id = csr_v_assign_id

Line 448: FROM hr_organization_units hou

444: csr_v_employer_id NUMBER
445: )
446: IS
447: SELECT hou.NAME
448: FROM hr_organization_units hou
449: WHERE hou.organization_id=csr_v_employer_id;
450:
451: rec_emp_name csr_emp_name%ROWTYPE;
452: