[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
legislative_parameters
from
pay_payroll_actions
where
payroll_action_id = pactid;
str := 'select
distinct paf.person_id
from
hr_assignment_set_amendments hasa,
per_assignments_f paf,
pay_payroll_actions ppa
WHERE
hasa.assignment_set_id =
pycadar_pkg.get_parameter(''ASSIGNMENT_SET_ID'',ppa.legislative_parameters) and
hasa.include_or_exclude = ''I'' and
hasa.assignment_id = paf.assignment_id and
ppa.payroll_action_id = :pactid
ORDER BY paf.person_id';
str := 'select
fnd_number.canonical_to_number(substr(legislative_parameters,11,(decode(instr(legislative_parameters,'' ''),0,10,instr(legislative_parameters,'' '')-11))))
from pay_payroll_actions ppa
where ppa.payroll_action_id=:pactid';
select fdi.user_entity_id
from ff_database_items fdi
where fdi.user_name = p_user_name;
select
puc.user_column_name
from
per_assignments_f paf,
hr_soft_coding_keyflex hsck,
pay_user_columns puc
where
paf.assignment_id = p_asg_id and
paf.business_group_id = p_business_group_id and
paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id and
p_current_date between
paf.effective_start_date and
paf.effective_end_date and
hsck.segment4 = puc.user_column_id;
select
hoi.org_information2
from
hr_organization_units hou,
hr_organization_information hoi
where
hou.business_group_id = p_business_group_id and
hou.organization_id = hoi.organization_id and
hoi.org_information_context = 'Canadian Work Schedule';
select
pdb.defined_balance_id
from
pay_defined_balances pdb,
pay_balance_types pbt,
pay_balance_dimensions pbd1
where
pbt.balance_name = p_balance_name and
pbt.business_group_id is null and
pbt.legislation_code = 'CA' and
pbt.balance_type_id = pdb.balance_type_id and
pdb.balance_dimension_id = pbd1.balance_dimension_id and
pbd1.dimension_name = p_dimension_name and
pbd1.business_group_id is null and
pbd1.legislation_code = 'CA';
SELECT
'X'
FROM
pay_balance_feeds_f pbf,
pay_balance_types pbt,
pay_input_values_f piv,
pay_element_types_f pet
WHERE
pbt.balance_name = p_balance_name and
pbt.business_group_id is NULL and
pbf.balance_type_id = pbt.balance_type_id and
pbf.input_value_id = piv.input_value_id and
piv.element_type_id = pet.element_type_id;
select pps.actual_termination_date termination_date,
NULL recall_date,
pps.pds_information1 roe_reason,
pps.pds_information2 roe_comment,
pps.date_start
from per_periods_of_service pps
where pps.person_id=p_person_id
and pps.business_group_id = p_business_group_id
and p_effective_date - nvl(pps.actual_termination_date,p_effective_date) <= 31
and pps.date_start <= p_effective_date
and pps.actual_termination_date <= p_effective_date
order by pps.date_start desc;
select paav.date_start date_start,
paav.date_end recall_date,
paav.abs_information1 roe_reason,
paav.abs_information2 roe_comment
from per_absence_attendances_v paav
where paav.person_id=p_person_id
and paav.business_group_id = p_business_group_id
and paav.date_start <= cp_effective_date
and p_effective_date - paav.date_start <= 31;
select paa.assignment_action_id
from pay_assignment_actions paa,
pay_payroll_actions ppa,
per_assignments_f paf
where paf.person_id = p_person_id
and paf.assignment_id = paa.assignment_id
and paa.payroll_action_id = ppa.payroll_action_id
and ppa.action_type = 'X'
and ppa.action_status = 'C'
and ppa.effective_date < p_effective_date
and ppa.report_type = 'ROE'
order by ppa.effective_date desc;
select fnd_date.canonical_to_date(fai.value)
from ff_archive_items fai,
ff_database_items fdi
where fai.user_entity_id = fdi.user_entity_id
and fdi.user_name = 'ROE_DATE'
and fai.context1 = to_char(b_assignment_action_id);
SELECT
business_group_id
FROM
pay_payroll_actions
WHERE
payroll_action_id = p_payroll_action_id;
select fai.value
from ff_archive_items fai,
ff_database_items fdi
where fdi.user_name = p_user_name
and fdi.user_entity_id = fai.user_entity_id
and fai.context1 = p_assactid;
select
legislative_parameters,
effective_date,
business_group_id
from
pay_payroll_actions
where
payroll_action_id = pactid;
select
distinct paf.person_id person_id
from
hr_assignment_set_amendments hasa,
per_assignments_f paf
WHERE
hasa.assignment_set_id = l_assignment_set_id and
hasa.include_or_exclude = 'I' and
hasa.assignment_id = paf.assignment_id and
least(l_effective_date,paf.effective_end_date) between
paf.effective_start_date and
paf.effective_end_date;
is select
paf.assignment_id assignment_id,
paf.payroll_id payroll_id
from
per_assignments_f paf
where
paf.person_id = b_person_id
and paf.person_id >= stperson
and paf.person_id <= endperson
and paf.assignment_type in ('E','C')
and (paf.effective_end_date >= b_end_date
or trunc(paf.effective_end_date) = hr_general.END_OF_TIME
)
and paf.effective_start_date <= b_start_date
group by
paf.assignment_id,
paf.payroll_id;
select
distinct paa.tax_unit_id gre_id,
'T4' gre_type
from
pay_assignment_actions paa,
pay_payroll_actions ppa,
hr_organization_information hoi
where
paa.assignment_id = p_assignment_id and
ppa.payroll_action_id = paa.payroll_action_id and
ppa.payroll_id = p_payroll_id and
ppa.action_type in ( 'R','B','F','R','Q','I') and
ppa.action_status = 'C' and
p_effective_date - 400 <= ppa.date_earned and
ppa.date_earned <= p_effective_date and
hoi.organization_id = paa.tax_unit_id and
hoi.org_information_context = 'Canada Employer Identification' and
hoi.org_information5 = 'T4/RL1'
union all
select
distinct paa.tax_unit_id gre_id,
'T4A' gre_type
from
pay_assignment_actions paa,
pay_payroll_actions ppa,
hr_organization_information hoi
where
paa.assignment_id = p_assignment_id and
ppa.payroll_action_id = paa.payroll_action_id and
ppa.payroll_id = p_payroll_id and
ppa.action_type in ( 'R','B','F','R','Q') and
ppa.action_status = 'C' and
p_effective_date - 400 <= ppa.date_earned and
ppa.date_earned <= p_effective_date and
hoi.organization_id = paa.tax_unit_id and
hoi.org_information_context = 'Canada Employer Identification' and
hoi.org_information5 in ('T4A/RL1','T4A/RL2') and
not exists
(select 1
from
pay_assignment_actions paa_t4,
pay_payroll_actions ppa_t4,
hr_organization_information hoi_t4
where
paa_t4.assignment_id = p_assignment_id and
ppa_t4.payroll_action_id = paa_t4.payroll_action_id and
ppa_t4.payroll_id = p_payroll_id and
ppa_t4.action_type in ( 'R','B','F','R','Q') and
ppa_t4.action_status = 'C' and
p_effective_date - 400 <= ppa_t4.date_earned and
ppa_t4.date_earned <= p_effective_date and
hoi_t4.organization_id = paa_t4.tax_unit_id and
hoi_t4.org_information_context = 'Canada Employer Identification' and
hoi_t4.org_information5 = 'T4/RL1');
select
pay_assignment_actions_s.nextval
from
dual;
select
ptp.end_date
from
per_time_periods ptp
where
ptp.payroll_id = p_payroll_id and
p_date between
ptp.start_date and ptp.end_date;
select max(service.date_start) hire_date
from per_periods_of_service service,
per_assignments_f asg
-- where asg.assignment_id = l_assignment_id
where asg.person_id = l_person_id
and l_effective_date BETWEEN
asg.effective_start_date
AND asg.effective_end_date
and asg.person_id = service.person_id(+)
and service.date_start <= l_effective_date;
select abs.date_end date_end
from per_absence_attendances abs
where abs.person_id = b_person_id
and abs.date_start = b_date_start;
SELECT max(date_start)
FROM per_periods_of_service
WHERE person_id = p_person_id
AND business_group_id = p_business_group_id
AND date_start <= p_effective_date;
select
paa.assignment_action_id locked_action_id
from
pay_payroll_actions ppa,
pay_assignment_actions paa,
ff_archive_items fai1,
ff_archive_items fai2
where
ppa.report_type = 'ROE' and
ppa.report_category = 'ROEC' and
ppa.report_qualifier = 'ROEQ' and
ppa.payroll_action_id = paa.payroll_action_id and
paa.tax_unit_id = p_gre_id and
paa.assignment_id = p_assignment_id and
paa.assignment_action_id = fai1.context1 and
fai1.user_entity_id = v_roe_date and
fnd_date.canonical_to_date(fai1.value) =
fnd_date.canonical_to_date(to_char(p_roe_date,'yyyy/mm/dd hh24:mi:ss')) and
fai1.context1 = fai2.context1 and
fai2.user_entity_id = v_payroll_id and
fai2.value = to_char(p_payroll_id);
select
'x'
from
pay_action_interlocks
where
locked_action_id = l_context1;
select
full_name
from
per_people_f ppf
where
ppf.person_id = p_person_id and
p_roe_date between ppf.effective_start_date and
ppf.effective_end_date;
update pay_assignment_actions
set
serial_number = 'Y'
where
assignment_action_id = l_lockingactid;
update pay_assignment_actions
set
serial_number = 'Y'
where
assignment_action_id = l_lockingactid;
select
fai2.value
from
pay_payroll_actions ppa,
pay_assignment_actions paa,
ff_archive_items fai1,
ff_archive_items fai2
where
ppa.report_type = 'ROE' and
ppa.report_category = 'ROEC' and
ppa.report_qualifier = 'ROEQ' and
ppa.payroll_action_id = paa.payroll_action_id and
paa.tax_unit_id = p_gre_id and
paa.assignment_id = p_asg_id and
paa.assignment_action_id = fai1.context1 and
fai1.user_entity_id = l_payroll_uid and
fai1.value = to_char(p_payroll_id) and
fai1.context1 = fai2.context1 and
fai2.user_entity_id = l_edor_uid;
select abs.date_end date_end
from per_absence_attendances abs
where abs.person_id = b_person_id
and abs.date_start = b_date_start;
select
paa.assignment_id,
paa.tax_unit_id,
ppa.effective_date,
ppa.business_group_id,
ppa.payroll_id,
legislative_parameters,
NVL(paa.serial_number,'N')
from
pay_payroll_actions ppa,
pay_assignment_actions paa
where
paa.assignment_action_id = p_assactid and
paa.payroll_action_id = ppa.payroll_action_id;
select
ptp.end_date
from
per_time_periods ptp
where
ptp.payroll_id = p_payroll_id and
p_date between
ptp.start_date and ptp.end_date;
select
paf.person_id person_id
from
pay_assignment_actions paa,
per_assignments_f paf
where
paa.assignment_action_id = p_assignment_action_id and
paa.assignment_id = paf.assignment_id and
l_effective_date between paf.effective_start_date and
paf.effective_end_date;
select
pai.locking_action_id
from
pay_action_interlocks pai
where
pai.locked_action_id = l_assignment_amend;
select hctu.name name,
hctu.address_line_1 address_line_1,
hctu.address_line_2 address_line_2,
hctu.address_line_3 address_line_3,
hctu.province province,
hctu.country country,
hctu.postal_code postal_code
from hr_ca_tax_units_v hctu
where hctu.tax_unit_id=l_tax_unit_id;
select nvl(hoi.org_information9,hctu.name) name,
hctu.address_line_1 address_line_1,
hctu.address_line_2 address_line_2,
hctu.address_line_3 address_line_3,
hctu.town_or_city city,
hctu.province province,
hctu.country country,
hctu.postal_code postal_code,
hctu.telephone_number_1 telephone
from hr_ca_tax_units_v hctu,
hr_organization_information hoi
where hctu.tax_unit_id=l_tax_unit_id
and hoi.organization_id = l_tax_unit_id
and hoi.org_information_context = 'Canada Employer Identification';
select people.first_name first_name,
people.last_name last_name,
people.national_identifier social_insurance_number,
people.middle_names middle_names,
decode (people.correspondence_language, 'FRC','F','E') correspondence_language
from
per_all_people_f people
, per_person_types ptype
, per_phones phone
, fnd_sessions ses
, hr_lookups a
, hr_lookups c
, hr_lookups d
, hr_lookups e
, hr_lookups f
, hr_lookups g
, hr_lookups h
, hr_lookups i
, per_all_assignments_f ASSIGN
where l_effective_date BETWEEN
ASSIGN.effective_start_date
AND ASSIGN.effective_end_date
and ASSIGN.assignment_id = l_assignment_id
and PEOPLE.person_id = ASSIGN.person_id
and l_effective_date BETWEEN
PEOPLE.effective_start_date
AND PEOPLE.effective_end_date
and PTYPE.person_type_id = PEOPLE.person_type_id
and PHONE.parent_id (+) = PEOPLE.person_id
AND PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'
and PHONE.phone_type (+)= 'W1'
AND l_effective_date
BETWEEN NVL(PHONE.date_from(+),l_effective_date)
AND NVL(PHONE.date_to(+),l_effective_date)
and a.lookup_type = 'YES_NO'
and a.lookup_code = nvl(PEOPLE.current_applicant_flag,'N')
and a.application_id = 800
and c.lookup_type = 'YES_NO'
and c.lookup_code = nvl(PEOPLE.current_employee_flag,'N')
and c.application_id = 800
and d.lookup_type = 'YES_NO'
and d.lookup_code = nvl(PEOPLE.registered_disabled_flag,'N')
and d.application_id = 800
and e.lookup_type (+)= 'HOME_OFFICE'
and e.lookup_code (+)= PEOPLE.expense_check_send_to_address
and e.application_id (+)= 800
and f.lookup_type (+)= 'MAR_STATUS'
and f.lookup_code (+)= PEOPLE.marital_status
and f.application_id (+)= 800
and g.lookup_type (+)= 'NATIONALITY'
and g.lookup_code (+)= PEOPLE.nationality
and g.application_id (+)= 800
and h.lookup_type (+)= 'SEX'
and h.lookup_code (+)= PEOPLE.sex
and h.application_id (+)= 800
and i.lookup_type (+)= 'TITLE'
and i.lookup_code (+)= PEOPLE.title
and i.application_id (+)= 800
and SES.session_id = USERENV('SESSIONID');
select addr.address_line1 address_line_1,
addr.address_line2 address_line_2,
addr.address_line3 address_line_3,
addr.town_or_city city,
addr.region_1 province,
addr.country country,
addr.postal_code postal_code,
addr.telephone_number_1 telephone_number
from per_all_assignments_f assign,
per_addresses addr
where assign.assignment_id = l_assignment_id
and l_effective_date BETWEEN
assign.effective_start_date
AND assign.effective_end_date
and assign.person_id = addr.person_id(+)
and addr.primary_flag(+) = 'Y'
and l_effective_date
BETWEEN nvl(ADDR.date_from,l_effective_date)
AND nvl(ADDR.date_to,l_effective_date);
select max(service.date_start) hire_date
from per_periods_of_service service,
per_assignments_f asg
where asg.assignment_id = l_assignment_id
and l_effective_date BETWEEN
asg.effective_start_date
AND asg.effective_end_date
and asg.person_id = service.person_id(+)
and service.date_start <= l_effective_date;
select paf.assignment_number asg_number
from per_assignments_f paf
where l_effective_date between paf.effective_start_date
AND paf.effective_end_date
and paf.assignment_id = l_assignment_id;
select hoi.org_information1 business_number
from hr_organization_information hoi
where l_tax_unit_id = hoi.organization_id
and ltrim(rtrim(hoi.org_information_context)) =
'Canada Employer Identification';
select people1.full_name contact_person,
ppf.prl_information2 contact_phone_number,
people2.full_name roe_issuer,
ppf.prl_information4 correspondence_language,
people1.first_name contact_first_name,
people1.middle_names contact_middle_names,
people1.last_name contact_last_name
from pay_payrolls_f ppf,
per_people_f people1,
per_people_f people2
where ppf.payroll_id = l_payroll_id
and ppf.prl_information_category = 'CA'
and ppf.prl_information1 = people1.person_id(+)
and ppf.prl_information3 = people2.person_id(+)
and p_pay_period_end_date BETWEEN nvl(people1.effective_start_date,
p_pay_period_end_date)
AND nvl(people1.effective_end_date,p_pay_period_end_date)
and p_pay_period_end_date BETWEEN nvl(people2.effective_start_date,
p_pay_period_end_date)
AND nvl(people2.effective_end_date,p_pay_period_end_date)
and p_pay_period_end_date BETWEEN nvl(ppf.effective_start_date,
p_pay_period_end_date)
AND nvl(ppf.effective_end_date,p_pay_period_end_date);
select
job.name name
from
per_all_assignments_f assign
, per_grades grade
, per_jobs job
, per_assignment_status_types ast
, pay_all_payrolls_f payroll
, per_time_periods timep
, hr_locations loc
, hr_all_organization_units org
, pay_people_groups grp
, per_all_vacancies vac
, per_all_people_f people1
, per_all_people_f people2
, per_all_positions pos1
, per_all_positions pos2
, per_all_positions pos3
, hr_lookups hr1
, hr_lookups hr2
, hr_lookups hr3
, hr_lookups hr4
, hr_lookups hr5
, hr_lookups hr6
, hr_lookups hr7
, fnd_lookups fnd1
, fnd_lookups fnd2
where
l_effective_date BETWEEN assign.effective_start_date
AND assign.effective_end_date
and assign.assignment_id = l_assignment_id
and grade.grade_id (+)= assign.grade_id
and job.job_id (+)= assign.job_id
and ast.assignment_status_type_id = assign.assignment_status_type_id
and payroll.payroll_id (+)= assign.payroll_id
and l_effective_date between
nvl (payroll.effective_start_date,l_effective_date)
and nvl (payroll.effective_end_date,l_effective_date)
and timep.payroll_id (+)= assign.payroll_id
and l_effective_date between nvl (timep.start_date(+), l_effective_date)
and nvl (timep.end_date(+), l_effective_date)
and loc.location_id (+)= assign.location_id
and org.organization_id = assign.organization_id
and grp.people_group_id (+)= assign.people_group_id
and vac.vacancy_id (+)= assign.vacancy_id
and hr1.lookup_code = assign.assignment_type
and hr1.lookup_type = 'EMP_APL'
and hr2.lookup_code (+)= assign.probation_unit
and hr2.lookup_type (+)= 'UNITS'
and hr3.lookup_code (+)= assign.frequency
and hr3.lookup_type (+)= 'FREQUENCY'
and fnd1.lookup_code = assign.primary_flag
and fnd1.lookup_type = 'YES_NO'
and fnd2.lookup_code (+)= assign.manager_flag
and fnd2.lookup_type (+)= 'YES_NO'
and people1.person_id (+)= assign.recruiter_id
and people2.person_id (+)= assign.supervisor_id
and pos1.position_id (+)= assign.position_id
and hr4.lookup_code (+)= pos1.frequency
and hr4.lookup_type (+)= 'FREQUENCY'
and hr5.lookup_code (+)= assign.employment_category
and hr5.lookup_type (+)= 'EMP_CAT'
and hr6.lookup_code (+)= assign.perf_review_period_frequency
and hr6.lookup_type (+)= 'FREQUENCY'
and hr7.lookup_code (+)= assign.sal_review_period_frequency
and hr7.lookup_type (+)= 'FREQUENCY'
and pos2.position_id (+)= pos1.successor_position_id
and pos3.position_id (+)= pos1.relief_position_id;
select min(ptp.start_date) start_date,
max(ptp.end_date) end_date
from pay_payroll_actions ppa,
pay_assignment_actions paa,
per_time_periods ptp,
per_time_period_types tptype
where paa.assignment_id = l_assignment_id
and paa.tax_unit_id = l_tax_unit_id
and paa.payroll_action_id = ppa.payroll_action_id
and ppa.payroll_id = l_payroll_id
and ppa.action_type in ('R','Q')
and ppa.date_earned <= p_pay_period_end_date
and ppa.payroll_id = ptp.payroll_id
and p_pay_period_end_date BETWEEN ptp.start_date
AND ptp.end_date
and ptp.period_type = tptype.period_type;
select max(ppa.date_earned) last_day_paid
from pay_payroll_actions ppa,
pay_assignment_actions paa
where paa.assignment_id = l_assignment_id
and paa.payroll_action_id = ppa.payroll_action_id
and ppa.action_type in ('R','Q')
and paa.action_status = 'C'
and ppa.date_earned <= l_effective_date
and ppa.payroll_id = l_payroll_id
and paa.tax_unit_id = l_tax_unit_id;
SELECT
assignment_set_name
FROM
hr_assignment_sets
WHERE assignment_set_id = l_assignment_set_id
AND business_group_id = l_business_group_id;
select
max(paa.assignment_action_id)
from
pay_assignment_actions paa,
pay_payroll_actions ppa,
per_assignments_f paf
where
paa.assignment_id = l_assignment_id and
paa.tax_unit_id = p_tax_unit_id and
paa.payroll_action_id = ppa.payroll_action_id and
ppa.action_type in ('R','Q','V','B','F') and
ppa.action_status = 'C' and
ppa.date_earned between
l_pay_period_start_date and
l_pay_period_end_date and
paa.assignment_id = paf.assignment_id and
l_pay_period_end_date between paf.effective_start_date and
paf.effective_end_date and
paf.payroll_id = l_payroll_id;
select
org_information4
from
hr_organization_information
where
organization_id = l_tax_unit_id and
org_information_context = 'Canada Employer Identification';
select
organization_id tax_unit_id
from
hr_organization_information
where
org_information4 = p_tax_group_id and
org_information_context = 'Canada Employer Identification' and
org_information5 in ('T4A/RL1','T4A/RL2') and
l_t4a_gre = 'Y'
union
select
l_tax_unit_id tax_unit_id
from
dual;
pay_ca_archive.delete_asg_set_records(l_asg_set_name,
l_assignment_id,
l_business_group_id);
pay_ca_archive.delete_asg_set_records('LOA_ASG_SET',
l_assignment_id,
l_business_group_id);
pay_ca_archive.delete_asg_set_records('TERMINATION_ASG_SET',
l_assignment_id,
l_business_group_id);
SELECT assignment_set_id
FROM hr_assignment_sets
WHERE UPPER(assignment_set_name) = UPPER(p_asg_set)
AND business_group_id = p_business_group_id;
SELECT hr_assignment_sets_s.nextval
FROM dual;
SELECT 'X'
FROM hr_assignment_set_amendments
WHERE assignment_id = p_assignment_id
AND assignment_set_id = l_assignment_set_id
AND include_or_exclude = 'I';
hr_assignment_set_amds_pkg.insert_row(
p_rowid => l_rowid
,p_assignment_id => p_assignment_id
,p_assignment_set_id => l_assignment_set_id
,p_include_or_exclude => 'I');
hr_assignment_sets_pkg.insert_row(
p_rowid => l_rowid,
p_assignment_set_id => l_assignment_set_id,
p_business_group_id => p_business_group_id,
p_payroll_id => '',
p_assignment_set_name => p_assignment_set_name,
p_formula_id => null);
hr_assignment_set_amds_pkg.insert_row(
p_rowid => l_rowid
,p_assignment_id => p_assignment_id
,p_assignment_set_id => l_assignment_set_id
,p_include_or_exclude => 'I');
procedure delete_asg_set_records(p_assignment_set_name in VARCHAR2,
p_assignment_id in NUMBER,
p_business_group_id NUMBER) IS
--
begin
declare
CURSOR cur_asg_set_id IS
SELECT assignment_set_id
FROM hr_assignment_sets
WHERE UPPER(assignment_set_name) = UPPER(p_assignment_set_name)
AND business_group_id = p_business_group_id;
SELECT 'X'
FROM hr_assignment_set_amendments
WHERE assignment_id = p_assignment_id
AND assignment_set_id = l_assignment_set_id
AND include_or_exclude = 'I';
SELECT 'X'
FROM hr_assignment_set_amendments
WHERE assignment_set_id = l_assignment_set_id;
hr_utility.trace(' Begin pay_ca_archive.delete_asg_set_records');
hr_utility.trace(' In delete_asg_set_records, cur_asg_set_id found !');
hr_utility.trace(' In delete_asg_set_records, l_assignment_set_id = '
|| to_char(l_assignment_set_id));
hr_utility.trace(' In delete_asg_set_records, c_already_in_set found !');
DELETE FROM
hr_assignment_set_amendments
WHERE
assignment_set_id = l_assignment_set_id and
assignment_id = p_assignment_id;
hr_utility.trace('In delete_asg_set_records cur_last_row = ' ||
to_char(cur_last_row%ROWCOUNT));
DELETE FROM hr_assignment_sets
where assignment_set_id = l_assignment_set_id;
end delete_asg_set_records;