DBA Data[Home] [Help]

APPS.PER_PYP_BUS dependencies on PAY_LINK_INPUT_VALUES_F

Line 1727: l_link_w_or_e pay_link_input_values_f.warning_or_error%TYPE;

1723: l_maximum NUMBER;
1724: l_ele_w_or_e pay_input_values_f.warning_or_error%TYPE;
1725: l_ele_min_value pay_input_values_f.min_value%TYPE;
1726: l_ele_max_value pay_input_values_f.max_value%TYPE;
1727: l_link_w_or_e pay_link_input_values_f.warning_or_error%TYPE;
1728: l_link_min_value pay_link_input_values_f.min_value%TYPE;
1729: l_link_max_value pay_link_input_values_f.max_value%TYPE;
1730: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1731: l_pay_basis VARCHAR2(30);

Line 1728: l_link_min_value pay_link_input_values_f.min_value%TYPE;

1724: l_ele_w_or_e pay_input_values_f.warning_or_error%TYPE;
1725: l_ele_min_value pay_input_values_f.min_value%TYPE;
1726: l_ele_max_value pay_input_values_f.max_value%TYPE;
1727: l_link_w_or_e pay_link_input_values_f.warning_or_error%TYPE;
1728: l_link_min_value pay_link_input_values_f.min_value%TYPE;
1729: l_link_max_value pay_link_input_values_f.max_value%TYPE;
1730: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1731: l_pay_basis VARCHAR2(30);
1732: l_grade_basis VARCHAR2(30);

Line 1729: l_link_max_value pay_link_input_values_f.max_value%TYPE;

1725: l_ele_min_value pay_input_values_f.min_value%TYPE;
1726: l_ele_max_value pay_input_values_f.max_value%TYPE;
1727: l_link_w_or_e pay_link_input_values_f.warning_or_error%TYPE;
1728: l_link_min_value pay_link_input_values_f.min_value%TYPE;
1729: l_link_max_value pay_link_input_values_f.max_value%TYPE;
1730: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1731: l_pay_basis VARCHAR2(30);
1732: l_grade_basis VARCHAR2(30);
1733: l_annual_salary number;

Line 1758: from pay_link_input_values_f liv,

1754: fnd_number.canonical_to_number(iv.max_value),
1755: liv.warning_or_error,
1756: fnd_number.canonical_to_number(liv.min_value),
1757: fnd_number.canonical_to_number(liv.max_value)
1758: from pay_link_input_values_f liv,
1759: pay_input_values_f iv,
1760: pay_element_links_f el,
1761: per_pay_bases ppb
1762: where