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 1880: FROM pay_element_entries_f

1876: IS
1877: --
1878: CURSOR c_ovn (p_calculation_date IN DATE) IS
1879: SELECT object_version_number
1880: FROM pay_element_entries_f
1881: WHERE element_entry_id = p_element_entry_id
1882: AND p_calculation_date BETWEEN effective_start_date
1883: AND effective_end_date;
1884: --

Line 1885: l_ovn pay_element_entries_f.object_version_number%TYPE;

1881: WHERE element_entry_id = p_element_entry_id
1882: AND p_calculation_date BETWEEN effective_start_date
1883: AND effective_end_date;
1884: --
1885: l_ovn pay_element_entries_f.object_version_number%TYPE;
1886: --
1887: l_effective_start_date DATE;
1888: l_effective_end_date DATE;
1889: l_warning BOOLEAN;

Line 1893: FROM pay_element_entries_f pee,

1889: l_warning BOOLEAN;
1890: --
1891: CURSOR c_iv IS
1892: SELECT piv.input_value_id
1893: FROM pay_element_entries_f pee,
1894: pay_element_links_f pel,
1895: pay_input_values_f piv
1896: WHERE pee.element_entry_id = p_element_entry_id
1897: AND pee.element_link_id = pel.element_link_id

Line 1930: FROM pay_element_entries_f pee,

1926: --
1927:
1928: CURSOR c_asg_status (l_effective_date IN DATE) IS
1929: SELECT past.per_system_status
1930: FROM pay_element_entries_f pee,
1931: per_assignments_f paf,
1932: per_assignment_status_types past
1933: WHERE pee.element_entry_id = p_element_entry_id
1934: AND pee.assignment_id = paf.assignment_id

Line 1952: FROM pay_element_entries_f

1948: -- Bug 3053186: Added the c_ee_end cursor
1949: --
1950: CURSOR c_ee_end IS
1951: SELECT 'exists'
1952: FROM pay_element_entries_f
1953: WHERE element_entry_id = p_element_entry_id
1954: AND LAST_DAY(effective_end_date) = p_calculation_date;
1955: --
1956: l_message VARCHAR2(1000);