APPS.PER_PYP_BUS dependencies on PAY_INPUT_VALUES_F

Line 256: , pay_input_values_f piv

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

Line 328: pay_input_values_f iv

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

Line 1614: l_ele_w_or_e pay_input_values_f.warning_or_error%TYPE;

1610: l_pyp_working_hours hr_all_positions_f.working_hours%TYPE;
1611: l_pyp_working_hours_frequency hr_all_positions_f.frequency%TYPE;
1612: l_minimum NUMBER;
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;

Line 1615: l_ele_min_value pay_input_values_f.min_value%TYPE;

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

Line 1616: l_ele_max_value pay_input_values_f.max_value%TYPE;

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

Line 1648: pay_input_values_f iv,

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

Line 1715: , PAY_INPUT_VALUES_F PIV

1711: , PPB.RATE_BASIS
1712: , PET.ELEMENT_TYPE_ID
1713: , PIV.UOM
1714: FROM PAY_ELEMENT_TYPES_F PET
1715: , PAY_INPUT_VALUES_F PIV
1716: , PER_PAY_BASES PPB
1717: --
1718: WHERE PPB.PAY_BASIS_ID=P_PAY_BASIS_ID
1719: --