APPS.PAY_JP_ITWB_DML_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 9082: l_item_elm pay_element_types_f_tl.element_name%type;

9078: l_proc varchar2(80) := c_package||'select_item_info';
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: --

Line 9120: pay_element_types_f_vl pet

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
9124: and pet.element_type_id = piv.element_type_id

Line 9268: pay_element_types_f pet

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
9272: and nvl(piv.business_group_id,p_business_group_id) = p_business_group_id