APPS.PAY_AE_IV_MIGRATE_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 65: FROM pay_element_entries_f pee

61:
62: /* Get the element entries for SI and SI Adjustment element */
63: CURSOR csr_get_ele_entries (l_si_et NUMBER, l_asg_id NUMBER) IS
64: SELECT pee.element_entry_id , pee.effective_start_date,pee.effective_end_date
65: FROM pay_element_entries_f pee
66: WHERE pee.element_type_id = l_si_et
67: AND pee.assignment_id = l_asg_id
68: Order by effective_start_date asc;
69:

Line 74: FROM pay_element_entries_f

70:
71: /* Get all the columns for element entry for SI element */
72: CURSOR csr_get_si_ee_all (l_si_et NUMBER, l_asg_id NUMBER) IS
73: SELECT *
74: FROM pay_element_entries_f
75: WHERE element_type_id = l_si_et
76: AND assignment_id = l_asg_id
77: ORDER BY effective_start_date ASC;
78:

Line 83: FROM pay_element_entries_f pee

79: rec_ele_entry csr_get_si_ee_all%ROWTYPE;
80:
81: CURSOR csr_get_max_ovn (l_si_et NUMBER,l_asg_id NUMBER) IS
82: SELECT max(pee.object_version_number)
83: FROM pay_element_entries_f pee
84: WHERE pee.element_type_id = l_si_et
85: AND pee.assignment_id = l_asg_id;
86:
87: /* Get the screen entry value for SI Adjustment Exception type value */