[Home] [Help]
2775: p_basis_end in date )
2776: is
2777: --
2778: v_national_identifier per_all_people_f.national_identifier%type;
2779: v_sex hr_lookups.meaning%type;
2780: v_date_of_birth varchar2(30);
2781: ---------------------------------------------------------------------------
2782: -- Bug# 2920732 - Modified the cursor to use secured view per_people_f
2783: -- Bug 2645599
2790: select people.national_identifier,
2791: h.meaning,
2792: fnd_date.date_to_canonical(people.date_of_birth)
2793: from per_people_f people,
2794: hr_lookups h
2795: where people.person_id = c_person_id
2796: and people.effective_start_date = (
2797: select max(people1.effective_start_date)
2798: from per_people_f people1
3164: ---------------------------------------------------------------------------
3165: -- Bug# 2920732 - Modified the cursor to use the secured view per_people_f
3166: -- Bug 5435088, Removed archiving gratuity_or_comp_info, gains_or_profit_from
3167: -- _shares, remarks
3168: -- Bug 6349937, removed hr_lookups which is not being used
3169: ---------------------------------------------------------------------------
3170: cursor person_eits
3171: ( c_person_id per_all_assignments_f.assignment_id%type,
3172: c_basis_start date,
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
3415: AND assign.assignment_id = c_assignment_id
3416: AND assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3417: AND hsc.segment1 = c_legal_entity_id
4880: cursor country_code
4881: ( c_country per_addresses.country%type)
4882: is
4883: select meaning
4884: from hr_lookups
4885: where lookup_type = 'SG_COUNTRY_CODE'
4886: and lookup_code = c_country;
4887:
4888: begin