[Home] [Help]
327: from pay_element_entries_f peef,
328: pay_element_entry_values_f peevf,
329: pay_input_values_f pivf,
330: pay_element_types_f petf,
331: pay_element_links_f pelf
332: where peef.assignment_id = p_assignment_id
333: and peef.creator_type = 'UT'
334: and petf.element_name = 'VERTEX'
335: and peevf.screen_entry_value like p_subordinate_jurisdiction||'%'
466: p_effective_date date
467: ) is
468: select peef.element_entry_id
469: from pay_element_entries_f peef, pay_element_entry_values_f peevf,
470: pay_element_links_f pelf, pay_element_types_f petf
471: where peef.assignment_id= p_assignment_id
472: and petf.element_name='VERTEX'
473: and peevf.screen_entry_value = p_jurisdiction
474: and p_effective_date between peef.effective_start_date
517: l_assignment_id per_assignments_f.assignment_id%TYPE := null;
518: l_effective_date per_assignments_f.effective_start_date%TYPE := null;
519: l_input_value_id pay_input_values_f.input_value_id%TYPE := null;
520: l_input_name pay_input_values_f.name%TYPE := null;
521: l_element_link_id pay_element_links_f.element_link_id%TYPE := null;
522: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE := null;
523: l_io boolean;
524: l_modified_correction boolean := FALSE;
525: l_validate boolean;
2098: ) is
2099: select peef.element_entry_id
2100: from pay_element_entries_f peef
2101: ,pay_element_entry_values_f peevf
2102: ,pay_element_links_f pelf
2103: ,pay_element_types_f petf
2104: where peef.assignment_id= l_csr_assignment_id
2105: and petf.element_name = lc_workers_comp
2106: and l_csr_effective_date < peef.effective_end_date
3372:
3373: cursor csr_defaultpayrollremoved(p_assignment_id number,p_effective_date date) is
3374: select null
3375: from per_all_assignments_f paa,
3376: pay_element_links_f pel,
3377: pay_element_types_f pet
3378: where paa.assignment_id=p_assignment_id
3379: and paa.payroll_id is null
3380: and p_effective_date between paa.effective_start_date