[Home] [Help]
3260: p_basis_start in date,
3261: p_basis_end in date )
3262: is
3263: --
3264: v_voluntary_cpf_obligatory per_assignment_extra_info.aei_information2%type;
3265: v_appr_cpf_full per_assignment_extra_info.aei_information3%type;
3266: v_assignment_id per_assignments_f.assignment_id%type;
3267: ---------------------------------------------------------------------------
3268: -- Bug# 2920732 - Modified the cursor to use the secured view per_assignments_f
3261: p_basis_end in date )
3262: is
3263: --
3264: v_voluntary_cpf_obligatory per_assignment_extra_info.aei_information2%type;
3265: v_appr_cpf_full per_assignment_extra_info.aei_information3%type;
3266: v_assignment_id per_assignments_f.assignment_id%type;
3267: ---------------------------------------------------------------------------
3268: -- Bug# 2920732 - Modified the cursor to use the secured view per_assignments_f
3269: -- Bug# 4688761 - Modified cursor to check the legal entity, and need get the
3282: select /*+ USE_NL(aei) */
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
3342: select /*+ USE_NL(aei) */
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
3688:
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
3774: p_basis_start in date,
3775: p_basis_end in date )
3776: is
3777: --
3778: v_cpf_overseas_post_obligatory per_assignment_extra_info.aei_information1%type;
3779: v_start_date varchar2(30);
3780: v_end_date varchar2(30);
3781: ---------------------------------------------------------------------------
3782: -- Bug# 2920732 - Modified the cursor to use the secured view per_assignments_f
3795: select aei.aei_information1,
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
3995: c_basis_start date,
3996: c_basis_end date) is
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
4125: aei.aei_information9 ee_cpf,
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