APPS.PER_PYP_BUS dependencies on PER_PAY_BASES

Line 257: , per_pay_bases ppb

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

Line 327: per_pay_bases ppb,

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

Line 1650: per_pay_bases ppb

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

Line 1681: per_pay_bases ppb

1677: from
1678: hr_all_organization_units bus, HR_ORGANIZATION_INFORMATION b2 ,
1679: hr_all_organization_units org, HR_ORGANIZATION_INFORMATION O2 ,
1680: pay_grade_rules_f pgr,
1681: per_pay_bases ppb
1682: where
1683: org.organization_id = p_organization_id
1684: and org.ORGANIZATION_ID = O2.ORGANIZATION_ID (+)
1685: and O2.ORG_INFORMATION_CONTEXT (+) = 'Work Day Information'

Line 1716: , PER_PAY_BASES PPB

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