1616: l_ovn number (15);
1617: l_archive_type varchar2(3) := 'AAP';
1618: --
1619: -- Local variables added as part of tiem analysis changes
1620: l_con_fixed_working_time per_contracts_f.ctr_information10%type;
1621: l_amount per_contracts_f.ctr_information11%type;
1622: l_units per_contracts_f.ctr_information12%type;
1623: l_units_mean hr_lookups.meaning%type;
1624: l_frequency per_contracts_f.ctr_information13%type;
1617: l_archive_type varchar2(3) := 'AAP';
1618: --
1619: -- Local variables added as part of tiem analysis changes
1620: l_con_fixed_working_time per_contracts_f.ctr_information10%type;
1621: l_amount per_contracts_f.ctr_information11%type;
1622: l_units per_contracts_f.ctr_information12%type;
1623: l_units_mean hr_lookups.meaning%type;
1624: l_frequency per_contracts_f.ctr_information13%type;
1625: l_freq_mean hr_lookups.meaning%type;
1618: --
1619: -- Local variables added as part of tiem analysis changes
1620: l_con_fixed_working_time per_contracts_f.ctr_information10%type;
1621: l_amount per_contracts_f.ctr_information11%type;
1622: l_units per_contracts_f.ctr_information12%type;
1623: l_units_mean hr_lookups.meaning%type;
1624: l_frequency per_contracts_f.ctr_information13%type;
1625: l_freq_mean hr_lookups.meaning%type;
1626: --
1620: l_con_fixed_working_time per_contracts_f.ctr_information10%type;
1621: l_amount per_contracts_f.ctr_information11%type;
1622: l_units per_contracts_f.ctr_information12%type;
1623: l_units_mean hr_lookups.meaning%type;
1624: l_frequency per_contracts_f.ctr_information13%type;
1625: l_freq_mean hr_lookups.meaning%type;
1626: --
1627: -- csr_ee_address Gets the employees primary address
1628: --
1669: ,per_collective_agreements cag
1670: ,hr_all_organization_units est
1671: ,hr_organization_information estinfo
1672: ,hr_all_organization_units_tl orgtl
1673: ,per_contracts_f ctr
1674: ,fnd_lookup_values hrl
1675: ,fnd_lookup_values hrl1
1676: where asg.assignment_id = p_assignment_id
1677: and p_asat_date between asg.effective_start_date