[Home] [Help]
297:
298: if g_teach_dff_name = 'PER_PEOPLE' then
299: g_teacher_sql_str :=
300: 'select '||l_column||
301: ' from per_all_people_f where ATTRIBUTE_CATEGORY = '''||l_context||'''
302: and person_id = :person_id
303: and :effective_date between effective_start_date and effective_end_date';
304:
305: elsif g_teach_dff_name = 'Extra Person Info DDF' then
426:
427: elsif g_hlta_dff_name = 'PER_PEOPLE' then
428: g_hlta_sql_str:=
429: 'select max(hr_general.decode_lookup(''YES_NO'',pcv.pcv_information3))
430: from per_all_people_f pap,
431: pqp_configuration_values pcv
432: where attribute_category = '''||l_hlta_context_name||'''
433: and pap.person_id = :person_id
434: and :effective_date between pap.effective_start_date and pap.effective_end_date
517: and :effective_date between effective_start_date and effective_end_date';
518: elsif g_origin_dff = 'PER_PEOPLE' then
519: g_origin_sql_str:=
520: 'select '||l_origin_segment||
521: ' from per_all_people_f where ATTRIBUTE_CATEGORY = '''||l_origin_context||'''
522: and person_id = :person_id
523: and :effective_date between effective_start_date and effective_end_date';
524: end if;
525:
700: ||l_proc,1);
701:
702:
703: sqlstr := 'select distinct person_id '
704: ||'from per_all_people_f ppf, '
705: ||'pay_payroll_actions ppa '
706: ||'where ppa.payroll_action_id = :payroll_action_id '
707: ||'and ppa.business_group_id = ppf.business_group_id '
708: ||'order by ppf.person_id';
1221: pap.date_of_birth date_of_birth,
1222: to_char(pap.date_of_birth,'YYYY-MM-DD') dob_dcsf
1223: from pay_assignment_actions act,
1224: per_all_assignments_f paa,
1225: per_all_people_f pap
1226: where act.assignment_action_id = p_assactid
1227: and act.assignment_id = paa.assignment_id
1228: and paa.person_id = pap.person_id
1229: and csr_effective_date between paa.effective_start_date and paa.effective_end_date
1267: cursor get_person_id(p_effective_date date) is
1268: select ppf.person_id,ppf.employee_number
1269: from pay_assignment_actions act,
1270: per_all_assignments_f paa,
1271: per_all_people_f ppf
1272: where act.assignment_action_id = p_assactid
1273: and act.assignment_id = paa.assignment_id
1274: and ppf.person_id = paa.person_id
1275: and p_effective_date between paa.effective_start_date and paa.effective_end_date
1291: l_staff_rec csr_person_details%rowtype;
1292: l_swf_def_values_rec get_swf_dff_vaues%rowtype;
1293: l_asg_active_on_census_day boolean := true; -- variable set to true if he is active on census day
1294: l_person_id number;
1295: l_employee_number per_all_people_f.employee_number%type;
1296: l_qt_status hr_lookups.meaning%type;
1297: l_qts_route hr_lookups.meaning%type;
1298: l_disablity varchar2(5) := 'NO';
1299: l_hlta_status hr_lookups.meaning%type;
4273: paa.assignment_action_id asg_act_id
4274: from pay_payroll_actions pay,
4275: pay_assignment_actions paa,
4276: per_all_assignments_f paf,
4277: per_all_people_f peo,
4278: (select max(effective_end_date) effective_date,assignment_id
4279: from per_all_assignments_f
4280: group by assignment_id) max_eff_date
4281: where pay.payroll_action_id = pactid
4320: paa.assignment_action_id asg_act_id
4321: from pay_payroll_actions pay,
4322: pay_assignment_actions paa,
4323: per_all_assignments_f paf,
4324: per_all_people_f peo,
4325: (select max(effective_end_date) effective_date,assignment_id
4326: from per_all_assignments_f
4327: group by assignment_id) max_eff_date
4328: where pay.payroll_action_id = pactid
4357: peo.last_name l_name,
4358: peo.title title,
4359: peo.employee_number emp_no,
4360: peo.national_identifier ni_no
4361: from per_all_people_f peo
4362: where person_id = p_person_id;
4363:
4364: emp_rec emp_details%rowtype;
4365: