APPS.HR_DE_VALIDATE_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 11: l_table PAY_ELEMENT_ENTRIES_F.ENTRY_INFORMATION9%TYPE;

7: ,p_assignment_id IN NUMBER
8: ,p_entry_information_category IN VARCHAR2
9: ,p_entry_information1 IN VARCHAR2) IS
10:
11: l_table PAY_ELEMENT_ENTRIES_F.ENTRY_INFORMATION9%TYPE;
12:
13: CURSOR csr_get_table IS
14: SELECT entry_information9
15: FROM pay_element_entries_f entry

Line 15: FROM pay_element_entries_f entry

11: l_table PAY_ELEMENT_ENTRIES_F.ENTRY_INFORMATION9%TYPE;
12:
13: CURSOR csr_get_table IS
14: SELECT entry_information9
15: FROM pay_element_entries_f entry
16: WHERE entry.assignment_id = p_assignment_id
17: AND p_effective_date between entry.effective_start_date and entry.effective_end_date
18: AND entry.element_type_id = (SELECT element_type_id
19: FROM pay_element_types_f ele

Line 52: l_table PAY_ELEMENT_ENTRIES_F.ENTRY_INFORMATION9%TYPE;

48: ,p_element_entry_id IN NUMBER
49: ,p_entry_information_category IN VARCHAR2
50: ,p_entry_information1 IN VARCHAR2) IS
51:
52: l_table PAY_ELEMENT_ENTRIES_F.ENTRY_INFORMATION9%TYPE;
53: l_assignment_id number;
54:
55: CURSOR csr_get_asg_id IS
56: SELECT assignment_id

Line 57: FROM pay_element_entries_f ENTRY

53: l_assignment_id number;
54:
55: CURSOR csr_get_asg_id IS
56: SELECT assignment_id
57: FROM pay_element_entries_f ENTRY
58: WHERE p_effective_date between entry.effective_start_date and entry.effective_end_date
59: AND entry.element_entry_id = p_element_entry_id;
60:
61: CURSOR csr_get_table (l_assignment_id number) IS

Line 63: FROM pay_element_entries_f entry

59: AND entry.element_entry_id = p_element_entry_id;
60:
61: CURSOR csr_get_table (l_assignment_id number) IS
62: SELECT entry_information9
63: FROM pay_element_entries_f entry
64: WHERE entry.assignment_id = l_assignment_id
65: AND p_effective_date between entry.effective_start_date and entry.effective_end_date
66: AND entry.element_type_id = (SELECT element_type_id
67: FROM pay_element_types_f ele