APPS.PER_PYP_BUS dependencies on PAY_INPUT_VALUES_F

Line 255: , pay_input_values_f piv

251: cursor csr_element_effective_end_date is
252: select max(peef.effective_end_date)
253: from pay_element_entries_f peef
254: , pay_element_links_f pel
255: , pay_input_values_f piv
256: , per_pay_bases ppb
257: , per_all_assignments_f asg
258: where asg.assignment_id = p_assignment_id
259: and asg.pay_basis_id=ppb.pay_basis_id

Line 327: pay_input_values_f iv

323: SELECT pet.post_termination_rule
324: FROM pay_element_types_f pet,
325: per_all_assignments_f asg,
326: per_pay_bases ppb,
327: pay_input_values_f iv
328: WHERE pet.element_type_id = iv.element_type_id
329: AND iv.input_value_id = ppb.input_value_id
330: AND ppb.pay_basis_id = asg.pay_basis_id
331: AND asg.assignment_id = p_assignment_id

Line 1724: l_ele_w_or_e pay_input_values_f.warning_or_error%TYPE;

1720: l_pyp_working_hours hr_all_positions_f.working_hours%TYPE;
1721: l_pyp_working_hours_frequency hr_all_positions_f.frequency%TYPE;
1722: l_minimum NUMBER;
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;

Line 1725: l_ele_min_value pay_input_values_f.min_value%TYPE;

1721: l_pyp_working_hours_frequency hr_all_positions_f.frequency%TYPE;
1722: l_minimum NUMBER;
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;

Line 1726: l_ele_max_value pay_input_values_f.max_value%TYPE;

1722: l_minimum NUMBER;
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;

Line 1759: pay_input_values_f iv,

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
1763: p_pay_basis_id=ppb.pay_basis_id

Line 1826: , PAY_INPUT_VALUES_F PIV

1822: , PPB.RATE_BASIS
1823: , PET.ELEMENT_TYPE_ID
1824: , PIV.UOM
1825: FROM PAY_ELEMENT_TYPES_F PET
1826: , PAY_INPUT_VALUES_F PIV
1827: , PER_PAY_BASES PPB
1828: --
1829: WHERE PPB.PAY_BASIS_ID=P_PAY_BASIS_ID
1830: --