DBA Data[Home] [Help]

APPS.PAY_GB_RTI_EYU dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 636: pay_element_entry_values_f v,

632: CURSOR csr_paye_details(p_assignment_id NUMBER) IS
633: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
634: max(decode(iv.name,'Tax Basis',DECODE(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- kvinayku bug no 14774165
635: FROM pay_element_entries_f e,
636: pay_element_entry_values_f v,
637: pay_input_values_f iv,
638: pay_element_links_f link
639: WHERE e.assignment_id = p_assignment_id
640: AND link.element_type_id = g_paye_details_id

Line 680: l_tax_code pay_element_entry_values_f.screen_entry_value%type;

676: l_ovn_extra_info NUMBER;
677: l_asg_info_id NUMBER;
678: l_person_id NUMBER;
679: l_min_active_start_date DATE;
680: l_tax_code pay_element_entry_values_f.screen_entry_value%type;
681: l_tax_basis pay_element_entry_values_f.screen_entry_value%type;
682: l_rti_sent_flag VARCHAR2(15);
683: l_paye_rr_id number;
684: l_paye_details_rr_id number;

Line 681: l_tax_basis pay_element_entry_values_f.screen_entry_value%type;

677: l_asg_info_id NUMBER;
678: l_person_id NUMBER;
679: l_min_active_start_date DATE;
680: l_tax_code pay_element_entry_values_f.screen_entry_value%type;
681: l_tax_basis pay_element_entry_values_f.screen_entry_value%type;
682: l_rti_sent_flag VARCHAR2(15);
683: l_paye_rr_id number;
684: l_paye_details_rr_id number;
685: