APPS.PAY_JP_ITWB_DML_PKG dependencies on PAY_INPUT_VALUES_F

Line 9083: l_item_iv pay_input_values_f_tl.name%type;

9079: --
9080: l_item_cnt number := 0;
9081: --
9082: l_item_elm pay_element_types_f_tl.element_name%type;
9083: l_item_iv pay_input_values_f_tl.name%type;
9084: l_item_bal pay_balance_types_tl.balance_name%type;
9085: l_item_dim pay_balance_dimensions_tl.database_item_suffix%type;
9086: --
9087: cursor csr_item_info

Line 9119: from pay_input_values_f_vl piv,

9115: p_input_value_id in number)
9116: is
9117: select pet.element_name,
9118: piv.name
9119: from pay_input_values_f_vl piv,
9120: pay_element_types_f_vl pet
9121: where piv.input_value_id = p_input_value_id
9122: and p_effective_date
9123: between piv.effective_start_date and piv.effective_end_date

Line 9267: from pay_input_values_f piv,

9263: --
9264: cursor csr_iv
9265: is
9266: select piv.input_value_id
9267: from pay_input_values_f piv,
9268: pay_element_types_f pet
9269: where piv.input_value_id = p_input_value_id
9270: and p_effective_date
9271: between piv.effective_start_date and piv.effective_end_date