APPS.PAY_CN_DEDUCTIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 222: pay_element_entries_f pee,

218: ,p_effective_date DATE
219: ,p_plan_category VARCHAR2) IS
220: SELECT pap.accrual_plan_id
221: FROM pay_accrual_plans pap,
222: pay_element_entries_f pee,
223: pay_element_links_f pel,
224: pay_element_types_f pet
225: WHERE pee.assignment_id = p_assignment_id
226: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date

Line 1870: FROM pay_element_entries_f

1866: IS
1867: --
1868: CURSOR c_ovn (p_calculation_date IN DATE) IS
1869: SELECT object_version_number
1870: FROM pay_element_entries_f
1871: WHERE element_entry_id = p_element_entry_id
1872: AND p_calculation_date BETWEEN effective_start_date
1873: AND effective_end_date;
1874: --

Line 1875: l_ovn pay_element_entries_f.object_version_number%TYPE;

1871: WHERE element_entry_id = p_element_entry_id
1872: AND p_calculation_date BETWEEN effective_start_date
1873: AND effective_end_date;
1874: --
1875: l_ovn pay_element_entries_f.object_version_number%TYPE;
1876: --
1877: l_effective_start_date DATE;
1878: l_effective_end_date DATE;
1879: l_warning BOOLEAN;

Line 1883: FROM pay_element_entries_f pee,

1879: l_warning BOOLEAN;
1880: --
1881: CURSOR c_iv IS
1882: SELECT piv.input_value_id
1883: FROM pay_element_entries_f pee,
1884: pay_element_links_f pel,
1885: pay_input_values_f piv
1886: WHERE pee.element_entry_id = p_element_entry_id
1887: AND pee.element_link_id = pel.element_link_id

Line 1920: FROM pay_element_entries_f pee,

1916: --
1917:
1918: CURSOR c_asg_status (l_effective_date IN DATE) IS
1919: SELECT past.per_system_status
1920: FROM pay_element_entries_f pee,
1921: per_assignments_f paf,
1922: per_assignment_status_types past
1923: WHERE pee.element_entry_id = p_element_entry_id
1924: AND pee.assignment_id = paf.assignment_id

Line 1942: FROM pay_element_entries_f

1938: -- Bug 3053186: Added the c_ee_end cursor
1939: --
1940: CURSOR c_ee_end IS
1941: SELECT 'exists'
1942: FROM pay_element_entries_f
1943: WHERE element_entry_id = p_element_entry_id
1944: AND LAST_DAY(effective_end_date) = p_calculation_date;
1945: --
1946: l_message VARCHAR2(1000);