DBA Data[Home] [Help]

APPS.BEN_EXT_PAYROLL dependencies on PAY_INPUT_VALUES_F

Line 123: pay_input_values_f iv

119: from
120: pay_element_entry_values_f eev,
121: pay_element_entries_f ee,
122: per_all_assignments_f asg,
123: pay_input_values_f iv
124: where
125: asg.person_id = p_person_id
126: and asg.assignment_id = ee.assignment_id
127: and ee.element_entry_id = eev.element_entry_id

Line 160: name pay_input_values_f.name%TYPE,

156:
157:
158: TYPE get_csr_val IS RECORD
159: (
160: name pay_input_values_f.name%TYPE,
161: uom pay_input_values_f.uom%TYPE,
162: display_sequence pay_input_values_f.display_sequence%TYPE,
163: input_value_id pay_input_values_f.input_value_id%TYPE,
164: element_type_id pay_input_values_f.element_type_id%TYPE,

Line 161: uom pay_input_values_f.uom%TYPE,

157:
158: TYPE get_csr_val IS RECORD
159: (
160: name pay_input_values_f.name%TYPE,
161: uom pay_input_values_f.uom%TYPE,
162: display_sequence pay_input_values_f.display_sequence%TYPE,
163: input_value_id pay_input_values_f.input_value_id%TYPE,
164: element_type_id pay_input_values_f.element_type_id%TYPE,
165: screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE,

Line 162: display_sequence pay_input_values_f.display_sequence%TYPE,

158: TYPE get_csr_val IS RECORD
159: (
160: name pay_input_values_f.name%TYPE,
161: uom pay_input_values_f.uom%TYPE,
162: display_sequence pay_input_values_f.display_sequence%TYPE,
163: input_value_id pay_input_values_f.input_value_id%TYPE,
164: element_type_id pay_input_values_f.element_type_id%TYPE,
165: screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE,
166: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE,

Line 163: input_value_id pay_input_values_f.input_value_id%TYPE,

159: (
160: name pay_input_values_f.name%TYPE,
161: uom pay_input_values_f.uom%TYPE,
162: display_sequence pay_input_values_f.display_sequence%TYPE,
163: input_value_id pay_input_values_f.input_value_id%TYPE,
164: element_type_id pay_input_values_f.element_type_id%TYPE,
165: screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE,
166: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE,
167: eev_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE,

Line 164: element_type_id pay_input_values_f.element_type_id%TYPE,

160: name pay_input_values_f.name%TYPE,
161: uom pay_input_values_f.uom%TYPE,
162: display_sequence pay_input_values_f.display_sequence%TYPE,
163: input_value_id pay_input_values_f.input_value_id%TYPE,
164: element_type_id pay_input_values_f.element_type_id%TYPE,
165: screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE,
166: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE,
167: eev_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE,
168: eev_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE,

Line 250: pay_input_values_f iv,

246: pay_element_entry_values_f eev,
247: pay_element_entries_f ee,
248: per_all_assignments_f asg,
249: per_all_people_f per,
250: pay_input_values_f iv,
251: pay_element_types_f et,
252: pay_element_classifications ec,
253: ff_formulas_f ff,
254: pay_cost_allocation_keyflex ca

Line 325: pay_input_values_f iv

321: from
322: pay_element_entry_values_f eev,
323: pay_element_entries_f ee,
324: per_all_assignments_f asg,
325: pay_input_values_f iv
326: where
327: asg.person_id = p_person_id
328: and asg.assignment_id = ee.assignment_id
329: and ee.element_entry_id = eev.element_entry_id

Line 368: pay_input_values_f iv

364: from
365: pay_element_entry_values_f eev,
366: pay_element_entries_f ee,
367: per_all_assignments_f asg,
368: pay_input_values_f iv
369: where
370: asg.person_id = p_person_id
371: and asg.assignment_id = ee.assignment_id
372: and ee.element_entry_id = eev.element_entry_id