DBA Data[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 3454: ,pay_element_entries_f e_ni

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

Line 3536: FROM pay_element_entries_f e,

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

Line 3679: FROM pay_element_entries_f e,

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