[Home] [Help]
1552: decode(paf.frequency,'Y', 1,
1553: 'M', 12,
1554: 'W', 52,
1555: 'D', 365, 1)
1556: from per_assignments_f paf
1557: where paf.assignment_id = cp_assignment_id
1558: and cp_period_end_date between paf.effective_start_date
1559: and paf.effective_end_date;
1560:
1565: 'M', 12,
1566: 'W', 52,
1567: 'D', 365, 1)
1568: from per_positions pos,
1569: per_assignments_f paf
1570: where paf.assignment_id = cp_assignment_id
1571: and cp_period_end_date between paf.effective_start_date
1572: and paf.effective_end_date
1573: and paf.position_id = pos.position_id;
1579: 'M', 12,
1580: 'W', 52,
1581: 'D', 365, 1)
1582: from per_organization_units pou,
1583: per_assignments_f paf
1584: where paf.assignment_id = cp_assignment_id
1585: and cp_period_end_date between paf.effective_start_date
1586: and paf.effective_end_date
1587: and paf.organization_id = pou.organization_id;
1593: 'M', 12,
1594: 'W', 52,
1595: 'D', 365, 1)
1596: from per_business_groups pbg,
1597: per_assignments_f paf
1598: where paf.assignment_id = cp_assignment_id
1599: and cp_period_end_date between paf.effective_start_date
1600: and paf.effective_end_date
1601: and paf.business_group_id = pbg.business_group_id;
1875: -- RLN Bug 9074420 added or condition for bug 10628755 11730301 --*/
1876: CURSOR get_person_info(l_assignment_id number) IS
1877: select paf.business_group_id, paf.organization_id,
1878: paf.location_id, paf.person_id
1879: from per_assignments_f paf, per_periods_of_service pps
1880: where paf.assignment_id = l_assignment_id
1881: and p_effective_date between paf.effective_start_date
1882: and paf.effective_end_date
1883: and pps.period_of_service_id = paf.period_of_service_id
1886: /* --TERM cursor RLN 11730301 -- */
1887: CURSOR get_person_info_t(l_assignment_id number) IS
1888: select paf.business_group_id, paf.organization_id,
1889: paf.location_id, paf.person_id
1890: from per_assignments_f paf, per_periods_of_service pps
1891: where paf.assignment_id = l_assignment_id --13084713 Removed eff. date from where clause
1892: and pps.period_of_service_id = paf.period_of_service_id
1893: and pps.actual_termination_date between paf.effective_start_date
1894: and paf.effective_end_date;
1928: /*--13084713 Added Max for the termination date and Removed eff. date from where clause */
1929: Select nvl(max(pps.actual_termination_date), to_date('12/31/4712','mm/dd/yyyy'))
1930: into l_actual_termination_date
1931: from per_periods_of_service pps,
1932: per_assignments_f paf
1933: where paf.assignment_id = p_id
1934: and pps.period_of_service_id = paf.period_of_service_id;
1935:
1936: IF l_actual_termination_date = to_date('12/31/4712','mm/dd/yyyy')