DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on PAY_INPUT_VALUES_F

Line 1367: from pay_input_values_f piv,

1363: p_element_type_id number,
1364: cv_effective_date date) is
1365: select pivt.name name,
1366: pivt.input_value_id id
1367: from pay_input_values_f piv,
1368: pay_input_values_f_tl pivt
1369: where trunc(cv_effective_date)
1370: between piv.effective_start_date and piv.effective_end_date
1371: and ((piv.business_group_id is null and nvl(piv.legislation_code, p_legislation_code)

Line 1368: pay_input_values_f_tl pivt

1364: cv_effective_date date) is
1365: select pivt.name name,
1366: pivt.input_value_id id
1367: from pay_input_values_f piv,
1368: pay_input_values_f_tl pivt
1369: where trunc(cv_effective_date)
1370: between piv.effective_start_date and piv.effective_end_date
1371: and ((piv.business_group_id is null and nvl(piv.legislation_code, p_legislation_code)
1372: = p_legislation_code)or piv.business_group_id = p_target_business_group_id )