[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ppa.date_earned,paa.assignment_id
FROM
pay_payroll_actions ppa,
pay_assignment_actions paa
WHERE paa.assignment_action_id = p_assignment_action_id
AND ppa.payroll_action_id=paa.payroll_action_id;
SELECT min(pea.date_start)
FROM
per_all_assignments_f paa,
per_absence_attendances pea,
pay_element_entries_f pee
WHERE pee.assignment_id=p_assignment_id
AND paa.assignment_id=pee.assignment_id
AND pea.person_id = paa.person_id
AND pee.creator_type='A'
AND pee.creator_id = pea.absence_attendance_id
AND p_date_earned between pee.effective_start_date and pee.effective_end_date
AND p_date_earned between paa.effective_start_date and paa.effective_end_date;
SELECT fnd_date.canonical_to_date(peev.screen_entry_value)
FROM
pay_element_entries_f pee,
pay_element_entry_values_f peev,
pay_element_types_f pet,
pay_input_values_f pivf
WHERE pee.assignment_id=p_assignment_id
AND pet.element_name='Specified Date'
AND pee.element_type_id=pet.element_type_id
AND pivf.element_type_id = pet.element_type_id
AND pivf.name = 'Specified Date'
AND pee.element_entry_id=peev.element_entry_id
AND peev.input_value_id=pivf.input_value_id
AND p_date_earned between pee.effective_start_date and pee.effective_end_date
AND p_date_earned between peev.effective_start_date and peev.effective_end_date
AND p_date_earned between pet.effective_start_date and pet.effective_end_date
AND p_date_earned between pivf.effective_start_date and pivf.effective_end_date;
SELECT ppa.date_earned,paa.assignment_id,ppa.effective_date
FROM
pay_payroll_actions ppa,
pay_assignment_actions paa
WHERE paa.assignment_action_id = p_assignment_action_id
AND ppa.payroll_action_id=paa.payroll_action_id;
SELECT pps.date_start
FROM per_periods_of_service pps,
per_people_f ppf,
per_assignments_f paf
WHERE paf.person_id = ppf.person_id
AND pps.person_id = paf.person_id
AND paf.assignment_id = p_assignment_id
AND paf.period_of_service_id = pps.period_of_service_id;