APPS.PAY_CN_ELEMENT_TEMPLATE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 292: l_element_type_id pay_element_types_f.element_type_id%TYPE;

288:
289: c_end_of_time CONSTANT DATE := TO_DATE('31/12/4712','DD/MM/YYYY');
290: v_form_res_rule_id pay_formula_result_rules_f.formula_result_rule_id%TYPE;
291: l_input_value_id pay_formula_result_rules_f.input_value_id%TYPE;
292: l_element_type_id pay_element_types_f.element_type_id%TYPE;
293: BEGIN
294:
295: IF p_result_rule_type = 'D' THEN
296:

Line 312: FROM pay_input_values_f piv, pay_element_types_f pet

308: SELECT piv.input_value_id
309: , pet.element_type_id
310: INTO l_input_value_id
311: , l_element_type_id
312: FROM pay_input_values_f piv, pay_element_types_f pet
313: WHERE p_effective_date BETWEEN piv.effective_start_date
314: AND piv.effective_end_date
315: AND p_effective_date BETWEEN pet.effective_start_date
316: AND pet.effective_end_date

Line 398: FROM pay_element_types_f pet

394: SELECT pet.element_type_id
395: ,pet.business_group_id
396: ,pet.effective_start_date
397: ,pet.object_version_number
398: FROM pay_element_types_f pet
399: ,pay_element_templates tmp
400: WHERE pet.element_name = tmp.base_name
401: AND tmp.template_id = p_template_id;
402:

Line 406: l_element_ovn pay_element_types_f.object_version_number%TYPE;

402:
403: l_element_type_id pay_element_types.element_type_id%TYPE;
404: l_business_group_id pay_element_types.business_group_id%TYPE;
405: l_effective_date DATE;
406: l_element_ovn pay_element_types_f.object_version_number%TYPE;
407:
408: l_st_start_date DATE ;
409: l_st_end_date DATE ;
410: l_st_ovn pay_status_processing_rules_f.object_version_number%TYPE;