[Home] [Help]
2539: target.org_information8,
2540: target.org_information9
2541: from hr_organization_units org,
2542: hr_organization_information target,
2543: hr_soft_coding_keyflex scl
2544: where org.business_group_id = c_business_group_id
2545: and org.organization_id = c_legal_entity_id
2546: and org.organization_id = target.organization_id
2547: and target.org_information_context = 'SG_LEGAL_ENTITY'
2555: select target.org_information5,
2556: target.org_information7
2557: from hr_organization_units org,
2558: hr_organization_information target,
2559: hr_soft_coding_keyflex scl
2560: where org.business_group_id = c_business_group_id
2561: and org.organization_id = c_legal_entity_id
2562: and org.organization_id = target.organization_id
2563: and target.org_information_context = 'SG_LE_IRAS'
2574: count(distinct pei.person_extra_info_id)
2575: from per_all_people_f pap,
2576: per_people_extra_info pei,
2577: per_assignments_f assign,
2578: hr_soft_coding_keyflex hsc
2579: where pap.person_id = pei.person_id
2580: and pei.information_type = 'HR_STOCK_EXERCISE_SG'
2581: and pap.person_id = pei.person_id
2582: and pap.person_id = assign.person_id
3059: is
3060: select min(assign.effective_start_date),
3061: max(assign.effective_start_date)
3062: from per_assignments_f assign,
3063: hr_soft_coding_keyflex hsc,
3064: per_assignment_status_types sta
3065: where assign.person_id = c_person_id
3066: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3067: and hsc.segment1 = c_legal_entity_id
3078: c_date date )
3079: is
3080: select 'Y'
3081: from per_assignments_f assign,
3082: hr_soft_coding_keyflex hsc,
3083: per_assignment_status_types sta
3084: where assign.person_id = c_person_id
3085: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3086: and hsc.segment1 = c_legal_entity_id
3097: is
3098: select min(assign.effective_end_date),
3099: max(assign.effective_end_date)
3100: from per_assignments_f assign,
3101: hr_soft_coding_keyflex hsc,
3102: per_assignment_status_types sta
3103: where assign.person_id = c_person_id
3104: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3105: and hsc.segment1 = c_legal_entity_id
3412: aei.aei_information2,
3413: aei.aei_information3
3414: from per_assignments_f assign,
3415: per_assignment_extra_info aei,
3416: hr_soft_coding_keyflex hsc
3417: where assign.person_id = c_person_id
3418: and assign.assignment_id = c_assignment_id
3419: and assign.assignment_id = aei.assignment_id
3420: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3472: to_char(fnd_date.canonical_to_date(aei.aei_information1),'YYYY')||'/'||to_char(fnd_date.canonical_to_date(aei.aei_information1),'MM')||'/'||
3473: to_char(fnd_date.canonical_to_date(aei.aei_information1),'DD')
3474: from per_assignments_f assign,
3475: per_assignment_extra_info aei,
3476: hr_soft_coding_keyflex hsc
3477: where assign.person_id = c_person_id
3478: and assign.assignment_id = c_assignment_id
3479: and assign.assignment_id = aei.assignment_id
3480: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3535: is
3536:
3537: SELECT pea.segment4 bank_name
3538: FROM per_assignments_f assign,
3539: hr_soft_coding_keyflex hsc,
3540: pay_external_accounts pea,
3541: pay_personal_payment_methods_f ppm,
3542: hr_lookups hl
3543: WHERE assign.person_id = c_person_id
3622:
3623: select grade.name
3624: from per_assignments_f assign,
3625: per_grades grade,
3626: hr_soft_coding_keyflex hsc
3627: where assign.person_id = c_person_id
3628: and assign.assignment_id = c_assignment_id
3629: and grade.grade_id = assign.grade_id
3630: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3656:
3657: select jbt.name
3658: from per_assignments_f assign,
3659: per_jobs_tl jbt,
3660: hr_soft_coding_keyflex hsc
3661: where assign.person_id = c_person_id
3662: and assign.assignment_id = c_assignment_id
3663: and jbt.job_id = assign.job_id
3664: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3692: select pst.name
3693: from per_assignments_f assign,
3694: hr_all_positions_f_tl pst,
3695: hr_all_positions_f pos,
3696: hr_soft_coding_keyflex hsc
3697: where assign.person_id = c_person_id
3698: and assign.assignment_id = c_assignment_id
3699: and pos.position_id = assign.position_id
3700: and pst.position_id = pos.position_id
3759: 'SEGMENt28',ppd.segment28,
3760: 'SEGMENT29',ppd.segment29,
3761: 'SEGMENT30',ppd.segment30)
3762: from per_assignments_f assign,
3763: hr_soft_coding_keyflex hsc,
3764: hr_all_positions_f pos,
3765: hr_all_positions_f_tl pst,
3766: per_position_definitions ppd,
3767: hr_organization_units hou,
3819: select /*+ USE_NL(aei) */
3820: aei.aei_information1
3821: from per_assignments_f assign,
3822: per_assignment_extra_info aei,
3823: hr_soft_coding_keyflex hsc
3824: where assign.person_id = c_person_id
3825: and assign.assignment_id = c_assignment_id
3826: and assign.assignment_id = aei.assignment_id
3827: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3926: min(fnd_date.date_to_canonical(assign.effective_start_date)),
3927: max(fnd_date.date_to_canonical(nvl(assign.effective_end_date,c_basis_end)))
3928: from per_assignments_f assign,
3929: per_assignment_extra_info aei,
3930: hr_soft_coding_keyflex hsc
3931: where assign.person_id = c_person_id
3932: and assign.assignment_id = aei.assignment_id
3933: and assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3934: and hsc.segment1 = c_legal_entity_id
4257:
4258: select count(distinct (paei.assignment_extra_info_id))
4259: from per_assignment_extra_info paei,
4260: per_assignments_f paa,
4261: hr_soft_coding_keyflex hsc
4262: where paa.person_id = c_person_id
4263: and paa.assignment_id = paei.assignment_id
4264: and paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
4265: and hsc.segment1 = c_tax_unit_id
4386: aei.aei_information10 ee_cpf_interest,
4387: aei.aei_information11 ee_cpf_date
4388: from per_assignments_f ass,
4389: per_assignment_extra_info aei,
4390: hr_soft_coding_keyflex hsc
4391: where ass.person_id = c_person_id
4392: and ass.assignment_id = aei.assignment_id
4393: and ass.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
4394: and hsc.segment1 = c_tax_unit_id
4763: c_basis_end date )
4764: is
4765: select 'X'
4766: from per_assignments_f paf,
4767: hr_soft_coding_keyflex hsc
4768: where paf.person_id = c_person_id
4769: and paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
4770: and hsc.segment1 = c_tax_unit_id
4771: and paf.primary_flag = 'Y'
4826: c_basis_end date )
4827: is
4828: select paf.assignment_id
4829: from per_assignments_f paf,
4830: hr_soft_coding_keyflex hsc
4831: where paf.person_id = c_person_id
4832: and paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
4833: and hsc.segment1 = c_tax_unit_id
4834: and paf.primary_flag = 'Y'
4895: c_basis_end date )
4896: is
4897: select max(paf.assignment_id)
4898: from per_assignments_f paf,
4899: hr_soft_coding_keyflex hsc
4900: where paf.person_id = c_person_id
4901: and paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
4902: and hsc.segment1 = c_tax_unit_id
4903: and paf.assignment_type = 'E'