[Home] [Help]
3389: p_basis_start in date,
3390: p_basis_end in date )
3391: is
3392: --
3393: v_voluntary_cpf_obligatory per_assignment_extra_info.aei_information2%type;
3394: v_appr_cpf_full per_assignment_extra_info.aei_information3%type;
3395: v_assignment_id per_assignments_f.assignment_id%type;
3396: ---------------------------------------------------------------------------
3397: -- Bug# 2920732 - Modified the cursor to use the secured view per_assignments_f
3390: p_basis_end in date )
3391: is
3392: --
3393: v_voluntary_cpf_obligatory per_assignment_extra_info.aei_information2%type;
3394: v_appr_cpf_full per_assignment_extra_info.aei_information3%type;
3395: v_assignment_id per_assignments_f.assignment_id%type;
3396: ---------------------------------------------------------------------------
3397: -- Bug# 2920732 - Modified the cursor to use the secured view per_assignments_f
3398: -- Bug# 4688761 - Modified cursor to check the legal entity, and need get the
3411: select /*+ USE_NL(aei) */
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
3471: select /*+ USE_NL(aei) */
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
3818:
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
3904: p_basis_start in date,
3905: p_basis_end in date )
3906: is
3907: --
3908: v_cpf_overseas_post_obligatory per_assignment_extra_info.aei_information1%type;
3909: v_start_date varchar2(30);
3910: v_end_date varchar2(30);
3911: ---------------------------------------------------------------------------
3912: -- Bug# 2920732 - Modified the cursor to use the secured view per_assignments_f
3925: select aei.aei_information1,
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
4255: c_basis_start date,
4256: c_basis_end date) is
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
4385: aei.aei_information9 ee_cpf,
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