[Home] [Help]
19: cursor csr_bg_name
20: (p_person_id number,
21: p_effective_date date) is
22: select x.name
23: from per_business_groups x , per_all_people_f papf
24: where x.business_group_id = papf.business_group_id
25: and papf.person_id=p_person_id;
26: --
27: --Added for PMxbg
95: (p_person_id number
96: ,p_effective_date date) is
97:
98: select *
99: from per_all_people_f
100: where person_id=p_person_id
101: and p_effective_date between effective_start_date and effective_end_date;
102: --
103: cursor csr_person_type
219: ,p_effective_date date) is
220: select 0,phone_id,date_from,date_to,phone_number,object_version_number
221: from per_phones
222: where parent_id=p_person_id
223: and parent_table='PER_ALL_PEOPLE_F'
224: and phone_type=p_type
225: and p_effective_date between date_from and nvl(date_to,p_effective_date)
226: UNION
227: select months_between(p_effective_date,date_to),phone_id,date_from,date_to,phone_number,object_version_number
226: UNION
227: select months_between(p_effective_date,date_to),phone_id,date_from,date_to,phone_number,object_version_number
228: from per_phones
229: where parent_id=p_person_id
230: and parent_table='PER_ALL_PEOPLE_F'
231: and phone_type=p_type
232: and p_effective_date>date_to
233: UNION
234: select months_between(date_from,p_effective_date),phone_id,date_from,date_to,phone_number,object_version_number
233: UNION
234: select months_between(date_from,p_effective_date),phone_id,date_from,date_to,phone_number,object_version_number
235: from per_phones
236: where parent_id=p_person_id
237: and parent_table='PER_ALL_PEOPLE_F'
238: and phone_type=p_type
239: and p_effective_date
241: --
471: l_rate_rec csr_asg_rates%rowtype;
472: --
473: l_uom pay_input_values_f.uom%type;
474: --
475: per_rec per_all_people_f%rowtype;
476: app_rec per_applications%rowtype;
477: pds_rec per_periods_of_service%rowtype;
478: pdp_rec per_periods_of_placement%rowtype;
479: addr_rec per_addresses%rowtype;