DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 1886: ,pay_element_entries_f pee

1882: ,pap.accrual_plan_id
1883: FROM pay_accrual_plans pap
1884: ,pay_element_types_f pet
1885: ,pay_element_links_f pel
1886: ,pay_element_entries_f pee
1887: ,pay_assignment_actions paa
1888: ,pay_payroll_actions ppa
1889: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
1890: AND pel.element_type_id = pet.element_type_id

Line 3104: ,pay_element_entries_f ee

3100: ,per_all_people_f per
3101: ,pay_element_links_f el
3102: ,pay_element_types_f et
3103: ,pay_input_values_f iv1
3104: ,pay_element_entries_f ee
3105: ,pay_element_entry_values_f eev1
3106: WHERE asg1.assignment_id = p_assignment_id
3107: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3108: AND p_date_earned BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 3132: ,pay_element_entries_f ee

3128: FROM per_all_assignments_f asg1
3129: ,pay_element_links_f el
3130: ,pay_element_types_f et
3131: ,pay_input_values_f iv1
3132: ,pay_element_entries_f ee
3133: ,pay_element_entry_values_f eev1
3134: WHERE asg1.assignment_id = p_assignment_id
3135: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3136: AND et.element_name = 'Tax'