[Home] [Help]
75: and papf.business_group_id = p_business_group_id;
76:
77: cursor csr_asg_date is
78: select min(effective_start_date)
79: from per_all_assignments_f paaf,
80: hr_soft_coding_keyflex scl,
81: per_assignment_status_types past
82: where paaf.ASSIGNMENT_STATUS_TYPE_ID = past.ASSIGNMENT_STATUS_TYPE_ID
83: and paaf.SOFT_CODING_KEYFLEX_ID = scl.SOFT_CODING_KEYFLEX_ID
352:
353: cursor csr_get_derived_details is
354: select bus.business_group_id
355: , bus.legislation_code
356: from per_all_assignments_f paf
357: , per_business_groups_perf bus
358: where paf.person_id = p_assignment_id
359: and l_effective_date between paf.effective_start_date
360: and paf.effective_end_date
453:
454: cursor csr_get_derived_details is
455: select bus.business_group_id
456: , bus.legislation_code
457: from per_all_assignments_f paf
458: , per_business_groups_perf bus
459: where paf.person_id = p_assignment_id
460: and l_effective_date between paf.effective_start_date
461: and paf.effective_end_date
554:
555: cursor csr_get_derived_details is
556: select bus.business_group_id
557: , bus.legislation_code
558: from per_all_assignments_f paf
559: , per_business_groups_perf bus
560: where paf.person_id = p_assignment_id
561: and l_effective_date between paf.effective_start_date
562: and paf.effective_end_date
778:
779: cursor csr_contract_type is
780: select soft1.segment4 contract_type1, soft2.segment4 contract_type2
781: from hr_soft_coding_keyflex soft1,
782: per_all_assignments_f paf1,
783: per_all_people_f pap,
784: per_assignment_status_types pst,
785: hr_soft_coding_keyflex soft2,
786: per_all_assignments_f paf2
782: per_all_assignments_f paf1,
783: per_all_people_f pap,
784: per_assignment_status_types pst,
785: hr_soft_coding_keyflex soft2,
786: per_all_assignments_f paf2
787: where pap.person_id = (select per_or_asg_id from pay_pl_sii_details_f
788: where sii_details_id = p_sii_details_id and
789: p_effective_date between effective_start_date
790: and effective_end_date)