DBA Data[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 3589: ,pay_element_entries_f e_ni

3585: ,pay_run_result_values target
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

Line 3674: FROM pay_element_entries_f e,

3670: p_end_year DATE) IS
3671: SELECT v.screen_entry_value ni_cat,
3672: substr(hr_general.decode_lookup('GB_SCON',scon.screen_entry_value)
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

Line 3820: FROM pay_element_entries_f e,

3816: pay_previous,
3817: 100 * max(decode(iv.name,'Tax Previous',
3818: fnd_number.canonical_to_number(screen_entry_value),NULL))
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