[Home] [Help]
42: --
43:
44: l_fin_proc_date date;
45: l_person_id number;
46: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
47: l_pdp_date_start date;
48: --
49: l_proc varchar2(18) := 'iud_update_primary';
50: --
57: CURSOR csr_get_assignment_info IS
58: SELECT paaf.person_id
59: ,paaf.assignment_type
60: ,paaf.period_of_placement_date_start
61: FROM per_all_assignments_f paaf
62: WHERE paaf.assignment_id = p_ass_id
63: AND paaf.assignment_type IN ('E', 'C');
64: --
65: -- Bug 3240313 starts here.
67: CURSOR csr_get_new_asg_info IS
68: SELECT paaf.person_id
69: ,paaf.assignment_type
70: ,paaf.period_of_placement_date_start
71: FROM per_all_assignments_f paaf
72: WHERE paaf.assignment_id = p_new_prim_ass_id
73: AND paaf.assignment_type IN ('E', 'C');
74: --
75: -- Bug 3240313 ends here.
988: ,vendor_site_id
989: ,po_header_id
990: ,po_line_id
991: ,projected_assignment_end
992: from per_all_assignments_f
993: where assignment_id = p_asg_id
994: and p_eff_date between effective_start_date
995: and effective_end_date;
996: --
2049: ,vendor_site_id
2050: ,po_header_id
2051: ,po_line_id
2052: ,projected_assignment_end
2053: from per_all_assignments_f
2054: where assignment_id = p_asg_id
2055: and p_eff_date between effective_start_date
2056: and effective_end_date;
2057: --
2197: END IF;
2198: dt_api.validate_dt_mode
2199: (p_effective_date => p_sess_date
2200: ,p_datetrack_mode => 'INSERT'
2201: ,p_base_table_name => 'per_all_assignments_f'
2202: ,p_base_key_column => 'assignment_id'
2203: ,p_base_key_value => p_ass_id
2204: ,p_validation_start_date => l_vsd
2205: ,p_validation_end_date => l_ved
2373: is
2374: select effective_start_date
2375: , object_version_number
2376: , business_group_id
2377: from per_all_assignments_f
2378: where assignment_id = p_asg_id
2379: and p_eff_date between effective_start_date
2380: and effective_end_date;
2381: --