APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 123: -- p_sscwt_element_entry_id pay_element_entries_f.element_entry_id%TYPE --

119: -- The funciton uses dt_api to get the updation_mode. --
120: -- --
121: -- Parameters : --
122: -- IN : p_sscwt_rate NUMBER --
123: -- p_sscwt_element_entry_id pay_element_entries_f.element_entry_id%TYPE --
124: -- p_effective_date DATE --
125: -- --
126: -- OUT : N/A --
127: -- --

Line 141: ,p_sscwt_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

137: --
138:
139: FUNCTION update_sscwt_rate
140: (p_sscwt_rate IN NUMBER
141: ,p_sscwt_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
142: ,p_effective_date IN DATE)
143: RETURN BOOLEAN
144: IS
145: --

Line 158: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

154: l_procedure VARCHAR2(100);
155: l_effective_start_date DATE;
156: l_effective_end_date DATE;
157: --
158: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
159:
160: --
161: CURSOR csr_get_object_version
162: IS

Line 164: FROM pay_element_entries_f

160: --
161: CURSOR csr_get_object_version
162: IS
163: SELECT object_version_number
164: FROM pay_element_entries_f
165: WHERE element_entry_id = p_sscwt_element_entry_id
166: AND p_effective_date between effective_start_date
167: and effective_end_date;
168: --

Line 187: ,p_base_table_name => 'pay_element_entries_f'

183: -- Update, Correction, update Override or Update Change Imsert.
184: --
185: DT_Api.Find_DT_Upd_Modes
186: (p_effective_date => p_effective_date
187: ,p_base_table_name => 'pay_element_entries_f'
188: ,p_base_key_column => 'element_entry_id'
189: ,p_base_key_value => p_sscwt_element_entry_id
190: ,p_correction => l_correction
191: ,p_update => l_update

Line 597: ,pay_element_entries_f entry

593: ,per_assignments_f assignment
594: ,per_periods_of_service service
595: ,pay_element_types_f element
596: ,pay_element_links_f link
597: ,pay_element_entries_f entry
598: WHERE person.person_id BETWEEN p_start_person
599: AND p_end_person
600: AND assignment.person_id = person.person_id
601: AND assignment.business_group_id = person.business_group_id

Line 959: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

955: l_periods NUMBER;
956: l_total_periods NUMBER;
957: l_employee_full_name per_people_f.full_name%TYPE;
958: l_assignment_number per_assignments_f.assignment_number%TYPE;
959: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
960: --
961: -- Cursor Declarations
962: --
963: CURSOR csr_employees

Line 1027: pay_element_entries_f entry,

1023: ,NVL(entry_value.screen_entry_value, NVL(link.default_value
1024: ,inputv.default_value)),'N',entry_value.screen_entry_value) value
1025: ,entry.element_entry_id element_entry_id
1026: FROM pay_element_entry_values_f entry_value,
1027: pay_element_entries_f entry,
1028: pay_link_input_values_f link,
1029: pay_input_values_f inputv
1030: WHERE inputv.input_value_id = c_input_value_id
1031: AND g_financial_year between inputv.effective_start_date