DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PAY_INPUT_VALUES_F

Line 379: , PAY_INPUT_VALUES_F PIV

375: , ppb.pay_basis
376: ,PET.INPUT_CURRENCY_CODE
377: , PIV.UOM
378: FROM PAY_ELEMENT_TYPES_F PET
379: , PAY_INPUT_VALUES_F PIV
380: , PER_PAY_BASES PPB
381: WHERE PPB.PAY_BASIS_ID=p_pay_basis_id
382: AND PPB.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID
383: AND p_effective_date BETWEEN

Line 443: l_uom pay_input_values_f.uom%type;

439: and fnd_asr.lookup_type(+)='PRICE DIFFERENTIALS';
440: --
441: l_rate_rec csr_asg_rates%rowtype;
442: --
443: l_uom pay_input_values_f.uom%type;
444: --
445: per_rec per_all_people_f%rowtype;
446: app_rec per_applications%rowtype;
447: pds_rec per_periods_of_service%rowtype;