[Home] [Help]
2827: p_basis_end in date )
2828: is
2829: --
2830: v_national_identifier per_all_people_f.national_identifier%type;
2831: v_sex hr_lookups.meaning%type;
2832: v_date_of_birth varchar2(30);
2833: ---------------------------------------------------------------------------
2834: -- Bug# 2920732 - Modified the cursor to use secured view per_people_f
2835: -- Bug 2645599
2842: select people.national_identifier,
2843: h.meaning,
2844: fnd_date.date_to_canonical(people.date_of_birth)
2845: from per_people_f people,
2846: hr_lookups h
2847: where people.person_id = c_person_id
2848: and people.effective_start_date = (
2849: select max(people1.effective_start_date)
2850: from per_people_f people1
3296: ---------------------------------------------------------------------------
3297: -- Bug# 2920732 - Modified the cursor to use the secured view per_people_f
3298: -- Bug 5435088, Removed archiving gratuity_or_comp_info, gains_or_profit_from
3299: -- _shares, remarks
3300: -- Bug 6349937, removed hr_lookups which is not being used
3301: ---------------------------------------------------------------------------
3302: cursor person_eits
3303: ( c_person_id per_all_assignments_f.assignment_id%type,
3304: c_basis_start date,
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
3544: AND assign.assignment_id = c_assignment_id
3545: AND assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3546: AND hsc.segment1 = c_legal_entity_id
5135: cursor country_code
5136: ( c_country per_addresses.country%type)
5137: is
5138: select meaning
5139: from hr_lookups
5140: where lookup_type = 'SG_COUNTRY_CODE'
5141: and lookup_code = c_country;
5142:
5143: begin