APPS.PER_PYP_BUS dependencies on PER_PAY_BASES

Line 256: , per_pay_bases ppb

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
260: and ppb.input_value_id=piv.input_value_id

Line 326: per_pay_bases ppb,

322: ,p_change_date IN DATE) IS
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

Line 1761: per_pay_bases ppb

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
1764: and ppb.input_value_id=iv.input_value_id and
1765: p_change_date BETWEEN

Line 1792: per_pay_bases ppb

1788: from
1789: hr_all_organization_units bus, HR_ORGANIZATION_INFORMATION b2 ,
1790: hr_all_organization_units org, HR_ORGANIZATION_INFORMATION O2 ,
1791: pay_grade_rules_f pgr,
1792: per_pay_bases ppb
1793: where
1794: org.organization_id = p_organization_id
1795: and org.ORGANIZATION_ID = O2.ORGANIZATION_ID (+)
1796: and O2.ORG_INFORMATION_CONTEXT (+) = 'Work Day Information'

Line 1827: , PER_PAY_BASES PPB

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: --
1831: AND PPB.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID