[Home] [Help]
2081: RETURN l_ddf_input_value_name;
2082: END ddf_input_value_name;
2083:
2084: FUNCTION accr_plan_added_date_ivs (
2085: p_accrual_plan_id IN pay_accrual_plans.accrual_plan_id%TYPE,
2086: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2087: p_effective_date IN pay_element_types_f.effective_start_date%TYPE
2088: )
2089: RETURN input_value_name_table
2100: -- Date Input Value, so that will get filtered anyway by
2101: -- pncr.date_input_value_id = piv.input_value_id, but I will leave it for
2102: -- now.
2103: CURSOR csr_accrual_plan_ivs (
2104: p_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE,
2105: p_effective_date pay_element_types_f.effective_start_date%TYPE,
2106: p_element_type_id pay_element_types_f.element_type_id%TYPE
2107: )
2108: IS
2107: )
2108: IS
2109: SELECT DISTINCT piv.NAME
2110: FROM pay_input_values_f piv,
2111: pay_accrual_plans pap,
2112: pay_net_calculation_rules pncr
2113: WHERE piv.element_type_id = p_element_type_id
2114: AND p_effective_date BETWEEN piv.effective_start_date
2115: AND piv.effective_end_date
2159: p_effective_date pay_element_types_f.effective_start_date%TYPE
2160: )
2161: IS
2162: SELECT pap.accrual_plan_id
2163: FROM pay_accrual_plans pap,
2164: pay_element_links_f pelf,
2165: pay_element_entries_f peef
2166: WHERE pelf.element_type_id = pap.accrual_plan_element_type_id
2167: AND p_effective_date BETWEEN pelf.effective_start_date
2198:
2199: FUNCTION accrual_plan_exists (
2200: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2201: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
2202: p_accrual_plan_id IN pay_accrual_plans.accrual_plan_id%TYPE
2203: )
2204: RETURN BOOLEAN
2205: AS
2206: l_proc proc_name ;