[Home] [Help]
2528: target.org_information18,
2529: target.org_information8
2530: from hr_organization_units org,
2531: hr_organization_information target,
2532: hr_soft_coding_keyflex scl
2533: where org.business_group_id = c_business_group_id
2534: and org.organization_id = c_legal_entity_id
2535: and org.organization_id = target.organization_id
2536: and target.org_information_context = 'SG_LEGAL_ENTITY'
2544: select target.org_information5,
2545: target.org_information7
2546: from hr_organization_units org,
2547: hr_organization_information target,
2548: hr_soft_coding_keyflex scl
2549: where org.business_group_id = c_business_group_id
2550: and org.organization_id = c_legal_entity_id
2551: and org.organization_id = target.organization_id
2552: and target.org_information_context = 'SG_LE_IRAS'
3283: aei.aei_information2,
3284: aei.aei_information3
3285: from per_assignments_f assign,
3286: per_assignment_extra_info aei,
3287: hr_soft_coding_keyflex hsc
3288: where assign.person_id = c_person_id
3289: and assign.assignment_id = c_assignment_id
3290: and assign.assignment_id = aei.assignment_id
3291: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3343: to_char(fnd_date.canonical_to_date(aei.aei_information1),'YYYY')||'/'||to_char(fnd_date.canonical_to_date(aei.aei_information1),'MM')||'/'||
3344: to_char(fnd_date.canonical_to_date(aei.aei_information1),'DD')
3345: from per_assignments_f assign,
3346: per_assignment_extra_info aei,
3347: hr_soft_coding_keyflex hsc
3348: where assign.person_id = c_person_id
3349: and assign.assignment_id = c_assignment_id
3350: and assign.assignment_id = aei.assignment_id
3351: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3406: is
3407:
3408: SELECT pea.segment4 bank_name
3409: FROM per_assignments_f assign,
3410: hr_soft_coding_keyflex hsc,
3411: pay_external_accounts pea,
3412: pay_personal_payment_methods_f ppm,
3413: hr_lookups hl
3414: WHERE assign.person_id = c_person_id
3492:
3493: select grade.name
3494: from per_assignments_f assign,
3495: per_grades grade,
3496: hr_soft_coding_keyflex hsc
3497: where assign.person_id = c_person_id
3498: and assign.assignment_id = c_assignment_id
3499: and grade.grade_id = assign.grade_id
3500: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3526:
3527: select jbt.name
3528: from per_assignments_f assign,
3529: per_jobs_tl jbt,
3530: hr_soft_coding_keyflex hsc
3531: where assign.person_id = c_person_id
3532: and assign.assignment_id = c_assignment_id
3533: and jbt.job_id = assign.job_id
3534: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3562: select pst.name
3563: from per_assignments_f assign,
3564: hr_all_positions_f_tl pst,
3565: hr_all_positions_f pos,
3566: hr_soft_coding_keyflex hsc
3567: where assign.person_id = c_person_id
3568: and assign.assignment_id = c_assignment_id
3569: and pos.position_id = assign.position_id
3570: and pst.position_id = pos.position_id
3629: 'SEGMENt28',ppd.segment28,
3630: 'SEGMENT29',ppd.segment29,
3631: 'SEGMENT30',ppd.segment30)
3632: from per_assignments_f assign,
3633: hr_soft_coding_keyflex hsc,
3634: hr_all_positions_f pos,
3635: hr_all_positions_f_tl pst,
3636: per_position_definitions ppd,
3637: hr_organization_units hou,
3689: select /*+ USE_NL(aei) */
3690: aei.aei_information1
3691: from per_assignments_f assign,
3692: per_assignment_extra_info aei,
3693: hr_soft_coding_keyflex hsc
3694: where assign.person_id = c_person_id
3695: and assign.assignment_id = c_assignment_id
3696: and assign.assignment_id = aei.assignment_id
3697: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3796: min(fnd_date.date_to_canonical(assign.effective_start_date)),
3797: max(fnd_date.date_to_canonical(nvl(assign.effective_end_date,c_basis_end)))
3798: from per_assignments_f assign,
3799: per_assignment_extra_info aei,
3800: hr_soft_coding_keyflex hsc
3801: where assign.person_id = c_person_id
3802: and assign.assignment_id = aei.assignment_id
3803: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3804: and hsc.segment1 = c_legal_entity_id
3997:
3998: select count(distinct (paei.assignment_extra_info_id))
3999: from per_assignment_extra_info paei,
4000: per_assignments_f paa,
4001: hr_soft_coding_keyflex hsc
4002: where paa.person_id = c_person_id
4003: and paa.assignment_id = paei.assignment_id
4004: and paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
4005: and hsc.segment1 = c_tax_unit_id
4126: aei.aei_information10 ee_cpf_interest,
4127: aei.aei_information11 ee_cpf_date
4128: from per_assignments_f ass,
4129: per_assignment_extra_info aei,
4130: hr_soft_coding_keyflex hsc
4131: where ass.person_id = c_person_id
4132: and ass.assignment_id = aei.assignment_id
4133: and ass.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
4134: and hsc.segment1 = c_tax_unit_id
4503: c_basis_end date )
4504: is
4505: select 'X'
4506: from per_assignments_f paf,
4507: hr_soft_coding_keyflex hsc
4508: where paf.person_id = c_person_id
4509: and paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
4510: and hsc.segment1 = c_tax_unit_id
4511: and paf.primary_flag = 'Y'
4566: c_basis_end date )
4567: is
4568: select paf.assignment_id
4569: from per_assignments_f paf,
4570: hr_soft_coding_keyflex hsc
4571: where paf.person_id = c_person_id
4572: and paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
4573: and hsc.segment1 = c_tax_unit_id
4574: and paf.primary_flag = 'Y'
4635: c_basis_end date )
4636: is
4637: select max(paf.assignment_id)
4638: from per_assignments_f paf,
4639: hr_soft_coding_keyflex hsc
4640: where paf.person_id = c_person_id
4641: and paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
4642: and hsc.segment1 = c_tax_unit_id
4643: and paf.assignment_type = 'E'