APPS.PAY_SE_ARCHIVE_TETA dependencies on HR_ORGANIZATION_INFORMATION

Line 262: ,hr_organization_information hoi1

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
266: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 263: ,hr_organization_information hoi2

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
266: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
267: AND o1.business_group_id = csr_v_business_group_id

Line 264: ,hr_organization_information hoi3

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
266: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
267: AND o1.business_group_id = csr_v_business_group_id
268: AND hoi1.organization_id = o1.organization_id

Line 383: ,hr_organization_information hoi1

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
387: AND assign.person_id = csr_v_person_id

Line 384: ,hr_organization_information hoi2

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
387: AND assign.person_id = csr_v_person_id
388: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 385: ,hr_organization_information hoi3

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
387: AND assign.person_id = csr_v_person_id
388: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
389: AND o1.business_group_id = csr_v_business_group_id

Line 418: ,hr_organization_information hoi1

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
422: AND assign.person_id = csr_v_person_id

Line 419: ,hr_organization_information hoi2

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
422: AND assign.person_id = csr_v_person_id
423: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 420: ,hr_organization_information hoi3

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
422: AND assign.person_id = csr_v_person_id
423: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
424: AND o1.business_group_id = csr_v_business_group_id