DBA Data[Home] [Help]

APPS.HR_CA_FF_UDFS dependencies on PER_PAY_BASES

Line 727: per_pay_bases PYB,

723: INTO v_inpval_id,
724: v_pay_basis,
725: v_pay_basis_code
726: FROM per_assignments_f ASG,
727: per_pay_bases PYB,
728: hr_lookups FCL
729: WHERE FCL.lookup_code = PYB.pay_basis
730: AND FCL.lookup_type = 'PAY_BASIS'
731: AND FCL.application_id = 800

Line 4384: ,per_pay_bases ppb

4380: ,pay_element_entries_f pee
4381: ,pay_element_links_f pel
4382: ,pay_element_types_f pet
4383: ,pay_input_values_f piv
4384: ,per_pay_bases ppb
4385: ,per_all_assignments_f paa
4386: WHERE paa.assignment_id = p_assignment_id
4387: AND paa.business_group_id = p_bus_grp_id
4388: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date