[Home] [Help]
329:
330: cursor c_people is
331: select paf.person_id person_id,
332: paf.assignment_id assignment_id,
333: fnd_number.canonical_to_number(scl.segment1) tax_unit_id,
334: paf.effective_start_date effective_start_date,
335: paf.effective_end_date effective_end_date
336: from per_assignments_f paf,
337: hr_soft_coding_keyflex scl
357: and hoi.org_information_context =
358: 'Worksite Filing')
359: group by paf.person_id,
360: paf.assignment_id,
361: fnd_number.canonical_to_number(scl.segment1),
362: paf.effective_start_date,
363: paf.effective_end_date
364: order by 1, 2, 4 asc, 5, 3;
365:
703:
704: p_quarter_end := last_day(to_date(p_quarter || p_year,'MMYYYY'));
705: p_quarter_start := add_months(p_quarter_end, -3) + 1;
706: p_reporting_year := p_year;
707: p_reporting_quarter := to_char(fnd_number.canonical_to_number(p_quarter)/3);
708: p_effective_date := p_quarter_end;
709:
710: end get_reporting_dates;
711:
748: select PA.effective_date,
749: ltrim(substr(PA.legislative_parameters, 11,5)),
750: ltrim(substr(PA.legislative_parameters, 17,5)),
751: to_char(PA.effective_date,'YYYY'),
752: to_char(fnd_number.canonical_to_number(to_char(PA.effective_date,'MM'))/3),
753: ltrim(substr(PA.legislative_parameters, 23,5)) ,
754: to_char(business_group_id)
755: into l_effective_date,
756: l_report_type,
774: commit;
775:
776: /* Derive the start and end dates of the period being reported on. */
777:
778: l_quarter := to_char((fnd_number.canonical_to_number(l_reporting_quarter) * 3),'00');
779: get_reporting_dates( l_quarter,
780: l_reporting_year,
781: l_period_end,
782: l_quarter_start,