DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PYSA dependencies on PAY_ELEMENT_ENTRIES_F

Line 1456: ,pay_element_entries_f pee

1452: ,pap.accrual_plan_id
1453: FROM pay_accrual_plans pap
1454: ,pay_element_types_f pet
1455: ,pay_element_links_f pel
1456: ,pay_element_entries_f pee
1457: ,pay_assignment_actions paa
1458: ,pay_payroll_actions ppa
1459: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
1460: AND pel.element_type_id = pet.element_type_id

Line 1820: ,pay_element_entries_f ee

1816: ,per_all_people_f per
1817: ,pay_element_links_f el
1818: ,pay_element_types_f et
1819: ,pay_input_values_f iv1
1820: ,pay_element_entries_f ee
1821: ,pay_element_entry_values_f eev1
1822: WHERE asg1.assignment_id = p_assignment_id
1823: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
1824: AND p_date_earned BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 1848: ,pay_element_entries_f ee

1844: FROM per_all_assignments_f asg1
1845: ,pay_element_links_f el
1846: ,pay_element_types_f et
1847: ,pay_input_values_f iv1
1848: ,pay_element_entries_f ee
1849: ,pay_element_entry_values_f eev1
1850: WHERE asg1.assignment_id = p_assignment_id
1851: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
1852: AND et.element_name = 'Tax'