APPS.PAY_BAL_ADJUST dependencies on PAY_INPUT_VALUES_F

Line 1632: pay_input_values_f iv

1628: begin
1629: select ee.screen_entry_value
1630: into inp_value
1631: from pay_element_entry_values_f ee,
1632: pay_input_values_f iv
1633: where ee.element_entry_id=p_entry_id
1634: and ee.input_value_id=iv.input_value_id
1635: and upper(iv.name)=upper(inp_name)
1636: and p_effdate between iv.effective_start_date and iv.effective_end_date

Line 1714: l_ind_ele_type_id pay_input_values_f.element_type_id%type;

1710: --
1711: /* Indirect Result */
1712: --
1713: declare
1714: l_ind_ele_type_id pay_input_values_f.element_type_id%type;
1715: l_rr_id pay_run_results.run_result_id%type;
1716: begin
1717: --
1718: select element_type_id

Line 1720: from pay_input_values_f

1716: begin
1717: --
1718: select element_type_id
1719: into l_ind_ele_type_id
1720: from pay_input_values_f
1721: where input_value_id = outputs.input_value_id
1722: and p_effdate between effective_start_date
1723: and effective_end_date;
1724: --