DBA Data[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on PAY_ELEMENT_LINKS_F

Line 3455: ,pay_element_links_f el_ni

3451: ,pay_run_results rr
3452: ,pay_element_entry_values_f ev_scon
3453: ,pay_element_entry_values_f ev_cat
3454: ,pay_element_entries_f e_ni
3455: ,pay_element_links_f el_ni
3456: ,pay_payroll_actions pact
3457: ,pay_assignment_actions assact
3458: ,pay_payroll_actions bact
3459: ,per_time_periods bptp

Line 3539: pay_element_links_f link

3535: ,1,9) ni_scon
3536: FROM pay_element_entries_f e,
3537: pay_element_entry_values_f v,
3538: pay_element_entry_values_f scon,
3539: pay_element_links_f link
3540: WHERE e.assignment_id = p_asgid
3541: AND v.input_value_id + 0 = g_category_input_id
3542: AND v.effective_start_date = scon.effective_start_date
3543: AND v.effective_end_date = scon.effective_end_date

Line 3682: pay_element_links_f link

3678: tax_previous
3679: FROM pay_element_entries_f e,
3680: pay_element_entry_values_f v,
3681: pay_input_values_f iv,
3682: pay_element_links_f link
3683: WHERE e.assignment_id = p_assignment_id
3684: AND link.element_type_id = g_paye_details_id
3685: AND e.element_link_id = link.element_link_id
3686: AND e.element_entry_id = v.element_entry_id