APPS.PAY_SIMULATOR_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 126: v_original_element pay_element_types_f.element_type_id%TYPE;

122: FUNCTION check_if_multi_entry_elem
123: (
124: p_ele_typ_id IN NUMBER
125: )RETURN BOOLEAN IS
126: v_original_element pay_element_types_f.element_type_id%TYPE;
127: lv_procedure_name VARCHAR2(100) := '.check_if_multi_entry_elem';
128: BEGIN
129:
130: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

Line 159: v_mul_allowed pay_element_types_f.multiple_entries_allowed_flag%TYPE;

155: (
156: p_ele_typ_id IN NUMBER,
157: p_eff_date IN DATE
158: )RETURN BOOLEAN IS
159: v_mul_allowed pay_element_types_f.multiple_entries_allowed_flag%TYPE;
160: lv_procedure_name VARCHAR2(100) := '.is_multiple_entries_allowed';
161: BEGIN
162:
163: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

Line 167: FROM pay_element_types_f

163: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
164:
165: SELECT multiple_entries_allowed_flag
166: INTO v_mul_allowed
167: FROM pay_element_types_f
168: WHERE element_type_id = p_ele_typ_id
169: AND p_eff_date BETWEEN effective_start_date and effective_end_date;
170:
171: hr_utility.trace('Multiple Entry Allowed Flag allowed is '||v_mul_allowed);

Line 254: ,pay_element_types_f pet

250: ,petl.reporting_name)
251: ,petl.element_name)
252: INTO elem_name
253: FROM pay_element_type_extra_info eit
254: ,pay_element_types_f pet
255: ,pay_element_types_f_tl petl
256: WHERE eit.information_type = 'SIMULATION_ELEMENTS'
257: AND eit.eei_information1 = 'Y'
258: AND eit.element_type_id = pet.element_type_id

Line 255: ,pay_element_types_f_tl petl

251: ,petl.element_name)
252: INTO elem_name
253: FROM pay_element_type_extra_info eit
254: ,pay_element_types_f pet
255: ,pay_element_types_f_tl petl
256: WHERE eit.information_type = 'SIMULATION_ELEMENTS'
257: AND eit.eei_information1 = 'Y'
258: AND eit.element_type_id = pet.element_type_id
259: AND pet.element_type_id = p_element_type_id

Line 286: v_original_element pay_element_types_f.element_type_id%TYPE;

282: p_num_ent_vals NUMBER,
283: p_inp_val_id_tbl hr_entry.number_table,
284: p_ent_val_tbl hr_entry.varchar2_table
285: ) IS
286: v_original_element pay_element_types_f.element_type_id%TYPE;
287: v_exists BOOLEAN;
288: lv_procedure_name VARCHAR2(100) := '.handle_multi_entry_case';
289:
290: CURSOR csr_orig_ent_del(p_assignment_id NUMBER,

Line 900: FROM pay_element_types_f pet

896: ,prr.start_date
897: ,prr.end_date
898: ,prr.element_entry_id
899: ,prv.formula_result_flag
900: FROM pay_element_types_f pet
901: ,pay_input_values_f piv
902: ,pay_run_results prr
903: ,pay_run_result_values prv
904: WHERE prr.assignment_action_id = v_assact_id