DBA Data[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on PAY_ELEMENT_LINKS_F

Line 3590: ,pay_element_links_f el_ni

3586: ,pay_run_results rr
3587: ,pay_element_entry_values_f ev_scon
3588: ,pay_element_entry_values_f ev_cat
3589: ,pay_element_entries_f e_ni
3590: ,pay_element_links_f el_ni
3591: ,pay_payroll_actions pact
3592: ,pay_assignment_actions assact
3593: ,pay_payroll_actions bact
3594: ,per_time_periods bptp

Line 3677: pay_element_links_f link

3673: ,1,9) ni_scon
3674: FROM pay_element_entries_f e,
3675: pay_element_entry_values_f v,
3676: pay_element_entry_values_f scon,
3677: pay_element_links_f link
3678: WHERE e.assignment_id = p_asgid
3679: AND v.input_value_id + 0 = g_category_input_id
3680: AND v.effective_start_date = scon.effective_start_date
3681: AND v.effective_end_date = scon.effective_end_date

Line 3823: pay_element_links_f link

3819: tax_previous
3820: FROM pay_element_entries_f e,
3821: pay_element_entry_values_f v,
3822: pay_input_values_f iv,
3823: pay_element_links_f link
3824: WHERE e.assignment_id = p_assignment_id
3825: AND link.element_type_id = g_paye_details_id
3826: AND e.element_link_id = link.element_link_id
3827: AND e.element_entry_id = v.element_entry_id