DBA Data[Home] [Help]

APPS.PAY_IN_FF_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 540: pay_element_entries_f pee,

536: ,p_effective_date DATE
537: ,p_plan_category VARCHAR2) IS
538: SELECT pap.accrual_plan_id
539: FROM pay_accrual_plans pap,
540: pay_element_entries_f pee,
541: pay_element_links_f pel,
542: pay_element_types_f pet
543: WHERE pee.assignment_id = p_assignment_id
544: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date

Line 782: pay_element_entries_f pee,

778:
779: CURSOR c_80dd_80_percent is
780: SELECT count (*)
781: FROM pay_element_entry_values_f pev,
782: pay_element_entries_f pee,
783: pay_element_types_f pet,
784: pay_input_values_f piv
785: WHERE pet.element_name like 'Deduction under Section 80DD'
786: AND pet.legislation_code = 'IN'

Line 1349: From pay_element_entries_f

1345: RETURN NUMBER IS
1346: Cursor c_ovn
1347: IS
1348: Select object_version_number
1349: From pay_element_entries_f
1350: Where element_type_id = p_element_type_id
1351: And assignment_id = p_assignment_id
1352: And p_date Between effective_start_date and effective_end_date;
1353: