DBA Data[Home] [Help]

APPS.HR_CA_FF_UDFS dependencies on PER_PAY_BASES

Line 721: per_pay_bases PYB,

717: INTO v_inpval_id,
718: v_pay_basis,
719: v_pay_basis_code
720: FROM per_assignments_f ASG,
721: per_pay_bases PYB,
722: hr_lookups FCL
723: WHERE FCL.lookup_code = PYB.pay_basis
724: AND FCL.lookup_type = 'PAY_BASIS'
725: AND FCL.application_id = 800

Line 4347: ,per_pay_bases ppb

4343: ,pay_element_entries_f pee
4344: ,pay_element_links_f pel
4345: ,pay_element_types_f pet
4346: ,pay_input_values_f piv
4347: ,per_pay_bases ppb
4348: ,per_all_assignments_f paa
4349: WHERE paa.assignment_id = p_assignment_id
4350: AND paa.business_group_id = p_bus_grp_id
4351: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date