DBA Data[Home] [Help]

APPS.PER_PYP_BUS dependencies on PAY_LINK_INPUT_VALUES_F

Line 1617: l_link_w_or_e pay_link_input_values_f.warning_or_error%TYPE;

1613: l_maximum NUMBER;
1614: l_ele_w_or_e pay_input_values_f.warning_or_error%TYPE;
1615: l_ele_min_value pay_input_values_f.min_value%TYPE;
1616: l_ele_max_value pay_input_values_f.max_value%TYPE;
1617: l_link_w_or_e pay_link_input_values_f.warning_or_error%TYPE;
1618: l_link_min_value pay_link_input_values_f.min_value%TYPE;
1619: l_link_max_value pay_link_input_values_f.max_value%TYPE;
1620: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1621: l_pay_basis VARCHAR2(30);

Line 1618: l_link_min_value pay_link_input_values_f.min_value%TYPE;

1614: l_ele_w_or_e pay_input_values_f.warning_or_error%TYPE;
1615: l_ele_min_value pay_input_values_f.min_value%TYPE;
1616: l_ele_max_value pay_input_values_f.max_value%TYPE;
1617: l_link_w_or_e pay_link_input_values_f.warning_or_error%TYPE;
1618: l_link_min_value pay_link_input_values_f.min_value%TYPE;
1619: l_link_max_value pay_link_input_values_f.max_value%TYPE;
1620: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1621: l_pay_basis VARCHAR2(30);
1622: l_grade_basis VARCHAR2(30);

Line 1619: l_link_max_value pay_link_input_values_f.max_value%TYPE;

1615: l_ele_min_value pay_input_values_f.min_value%TYPE;
1616: l_ele_max_value pay_input_values_f.max_value%TYPE;
1617: l_link_w_or_e pay_link_input_values_f.warning_or_error%TYPE;
1618: l_link_min_value pay_link_input_values_f.min_value%TYPE;
1619: l_link_max_value pay_link_input_values_f.max_value%TYPE;
1620: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1621: l_pay_basis VARCHAR2(30);
1622: l_grade_basis VARCHAR2(30);
1623: l_annual_salary number;

Line 1647: from pay_link_input_values_f liv,

1643: fnd_number.canonical_to_number(iv.max_value),
1644: liv.warning_or_error,
1645: fnd_number.canonical_to_number(liv.min_value),
1646: fnd_number.canonical_to_number(liv.max_value)
1647: from pay_link_input_values_f liv,
1648: pay_input_values_f iv,
1649: pay_element_links_f el,
1650: per_pay_bases ppb
1651: where