[Home] [Help]
288:
289: BEGIN
290:
291: select ppos.date_start into l_ref_date
292: from per_periods_of_service ppos
293: where ppos.person_id = p_person_id
294: and ppos.date_start =
295: (select max(ppos1.date_start)
296: from per_periods_of_service ppos1
292: from per_periods_of_service ppos
293: where ppos.person_id = p_person_id
294: and ppos.date_start =
295: (select max(ppos1.date_start)
296: from per_periods_of_service ppos1
297: where ppos1.person_id = p_person_id);
298:
299: BEGIN
300:
349: select 1 INTO l_return_val
350: from per_all_assignments_f paa,
351: per_assignment_status_types past,
352: per_all_people_f pap,
353: per_periods_of_service ppos,
354: per_org_structure_versions posv
355:
356: where posv.organization_structure_id=p_org_struct_id
357: and p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
376: and pap.effective_start_date >= to_date('04-07-2006','DD-MM-RRRR')
377: and ppos.person_id = pap.person_id
378: and ppos.date_start =
379: (select max(ppos1.date_start)
380: from per_periods_of_service ppos1
381: where ppos1.person_id = ppos.person_id)
382: and ppos.date_start >= to_date('04-07-2006','DD-MM-RRRR')
383: and (exists(select 1 from per_people_extra_info ppei
384: where ppei.person_id=p_person_id
407: select 1 INTO l_return_val
408: from per_all_assignments_f paa,
409: per_assignment_status_types past,
410: per_all_people_f pap,
411: per_periods_of_service ppos,
412: per_org_structure_versions posv
413:
414: where posv.organization_structure_id=p_org_struct_id
415: and p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
424: and ppos.business_group_id = pap.business_group_id
425: and ppos.person_id = pap.person_id
426: and ppos.date_start =
427: (select max(ppos1.date_start)
428: from per_periods_of_service ppos1
429: where ppos1.person_id = ppos.person_id)
430: and ppos.date_start >= to_date('04-07-2006','DD-MM-RRRR')
431: and (exists(select 1 from per_people_extra_info ppei
432: where ppei.person_id=p_person_id
674: from per_all_assignments_f paa,
675: per_assignment_status_types past,
676: pay_payroll_actions ppa,
677: per_all_people_f pap,
678: per_periods_of_service ppos
679:
680: where p_person_id between p_start_person_id and p_end_person_id
681: and pap.person_id = p_person_id
682: and paa.person_id = pap.person_id
688: and ppos.business_group_id = pap.business_group_id
689: and ppos.person_id = pap.person_id
690: and ppos.date_start =
691: (select max(ppos1.date_start)
692: from per_periods_of_service ppos1
693: where ppos1.person_id = ppos.person_id)
694: and ppos.date_start >= to_date('04-07-2006','DD-MM-RRRR')
695: and pap.business_group_id=ppa.business_group_id
696: and ppa.payroll_action_id=p_payroll_action_id
718: from per_all_assignments_f paa,
719: per_assignment_status_types past,
720: per_all_people_f pap,
721: pay_payroll_actions ppa,
722: per_periods_of_service ppos,
723: per_org_structure_versions posv
724:
725: where posv.organization_structure_id=p_org_struct_id
726: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
747: and ppos.business_group_id = pap.business_group_id
748: and ppos.person_id = pap.person_id
749: and ppos.date_start =
750: (select max(ppos1.date_start)
751: from per_periods_of_service ppos1
752: where ppos1.person_id = ppos.person_id)
753: and ppos.date_start >= to_date('04-07-2006','DD-MM-RRRR')
754: and (EXISTS (select 1
755: from per_people_extra_info pei
775: from per_all_assignments_f paa,
776: per_assignment_status_types past,
777: per_all_people_f pap,
778: pay_payroll_actions ppa,
779: per_periods_of_service ppos,
780: per_org_structure_versions posv
781:
782: where posv.organization_structure_id=p_org_struct_id
783: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
788: and ppos.business_group_id = pap.business_group_id
789: and ppos.person_id = pap.person_id
790: and ppos.date_start =
791: (select max(ppos1.date_start)
792: from per_periods_of_service ppos1
793: where ppos1.person_id = ppos.person_id)
794: and ppos.date_start >= to_date('04-07-2006','DD-MM-RRRR')
795: and (EXISTS (select 1
796: from per_people_extra_info pei
986: from per_all_people_f pap,
987: per_all_assignments_f pas,
988: per_assignment_status_types past,
989: pay_assignment_actions paa,
990: per_periods_of_service ppos
991:
992: where paa.assignment_action_id = p_assignment_action_id
993: and pas.assignment_id = paa.assignment_id
994: and pap.person_id = pas.person_id
1002: where pap.person_id = pap1.person_id)
1003: and ppos.person_id = pap.person_id
1004: and ppos.date_start =
1005: (select max(date_start)
1006: from per_periods_of_service ppos1
1007: where ppos1.person_id = pap.person_id);
1008:
1009:
1010: CURSOR csr_get_peit(p_person_id NUMBER) IS
1310: from per_all_assignments_f paa,
1311: per_assignment_status_types past,
1312: per_all_people_f pap,
1313: pay_payroll_actions ppa,
1314: per_periods_of_service ppos,
1315: per_org_structure_versions posv
1316:
1317: where posv.organization_structure_id=p_org_struct_id
1318: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
1322: and ppos.business_group_id = pap.business_group_id
1323: and ppos.person_id = pap.person_id
1324: and ppos.date_start =
1325: (select max(ppos1.date_start)
1326: from per_periods_of_service ppos1
1327: where ppos1.person_id = ppos.person_id)
1328: and ppos.date_start >= to_date('04-07-2006','DD-MM-RRRR')
1329: and (EXISTS (select 1
1330: from per_people_extra_info pei