eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_P45_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 415: pay_element_entry_values_f peev

411: FROM pay_element_types_f pet,
412: pay_element_links_f pel,
413: pay_element_entries_f pee,
414: pay_input_values_f piv,
415: pay_element_entry_values_f peev
416: WHERE pee.assignment_id = x_assignment_id
417: AND upper(pet.element_name) = 'STUDENT LOAN'
418: AND upper(piv.name) = 'END DATE'
419: AND pet.business_group_id IS NULL

Line 437: l_end_date pay_element_entry_values_f.screen_entry_value%TYPE;

433: AND piv.effective_end_date
434: AND x_termination_date BETWEEN peev.effective_start_date
435: AND peev.effective_end_date;
436: --
437: l_end_date pay_element_entry_values_f.screen_entry_value%TYPE;
438: l_flag VARCHAR2(1);
439: l_term_date DATE;
440: l_found BOOLEAN;
441: --

Line 623: pay_element_entry_values_f v,

619: max(decode(iv.name,'Tax Basis',screen_entry_value)) tax_basis,
620: max(decode(iv.name,'Pay Previous',screen_entry_value)) pay_previous,
621: max(decode(iv.name,'Tax Previous',screen_entry_value)) tax_previous
622: FROM pay_element_entries_f e,
623: pay_element_entry_values_f v,
624: pay_input_values_f iv,
625: pay_element_links_f link
626: WHERE e.assignment_id = p_assignment_id
627: AND link.element_type_id = g_paye_details_id

Line 2806: l_tax_code pay_element_entry_values_f.screen_entry_value%TYPE;

2802: l_student_loan_flag VARCHAR2(1);
2803: --
2804: l_period_no per_time_periods.period_num%TYPE;
2805: l_tax_reference VARCHAR2(20);
2806: l_tax_code pay_element_entry_values_f.screen_entry_value%TYPE;
2807: l_tax_basis pay_element_entry_values_f.screen_entry_value%TYPE;
2808: l_prev_pay_char pay_element_entry_values_f.screen_entry_value%TYPE;
2809: l_prev_tax_char pay_element_entry_values_f.screen_entry_value%TYPE;
2810: l_tax_code_t pay_element_entry_values_f.screen_entry_value%TYPE;

Line 2807: l_tax_basis pay_element_entry_values_f.screen_entry_value%TYPE;

2803: --
2804: l_period_no per_time_periods.period_num%TYPE;
2805: l_tax_reference VARCHAR2(20);
2806: l_tax_code pay_element_entry_values_f.screen_entry_value%TYPE;
2807: l_tax_basis pay_element_entry_values_f.screen_entry_value%TYPE;
2808: l_prev_pay_char pay_element_entry_values_f.screen_entry_value%TYPE;
2809: l_prev_tax_char pay_element_entry_values_f.screen_entry_value%TYPE;
2810: l_tax_code_t pay_element_entry_values_f.screen_entry_value%TYPE;
2811: l_tax_basis_t pay_element_entry_values_f.screen_entry_value%TYPE;

Line 2808: l_prev_pay_char pay_element_entry_values_f.screen_entry_value%TYPE;

2804: l_period_no per_time_periods.period_num%TYPE;
2805: l_tax_reference VARCHAR2(20);
2806: l_tax_code pay_element_entry_values_f.screen_entry_value%TYPE;
2807: l_tax_basis pay_element_entry_values_f.screen_entry_value%TYPE;
2808: l_prev_pay_char pay_element_entry_values_f.screen_entry_value%TYPE;
2809: l_prev_tax_char pay_element_entry_values_f.screen_entry_value%TYPE;
2810: l_tax_code_t pay_element_entry_values_f.screen_entry_value%TYPE;
2811: l_tax_basis_t pay_element_entry_values_f.screen_entry_value%TYPE;
2812: l_prev_pay_char_t pay_element_entry_values_f.screen_entry_value%TYPE;

Line 2809: l_prev_tax_char pay_element_entry_values_f.screen_entry_value%TYPE;

2805: l_tax_reference VARCHAR2(20);
2806: l_tax_code pay_element_entry_values_f.screen_entry_value%TYPE;
2807: l_tax_basis pay_element_entry_values_f.screen_entry_value%TYPE;
2808: l_prev_pay_char pay_element_entry_values_f.screen_entry_value%TYPE;
2809: l_prev_tax_char pay_element_entry_values_f.screen_entry_value%TYPE;
2810: l_tax_code_t pay_element_entry_values_f.screen_entry_value%TYPE;
2811: l_tax_basis_t pay_element_entry_values_f.screen_entry_value%TYPE;
2812: l_prev_pay_char_t pay_element_entry_values_f.screen_entry_value%TYPE;
2813: l_prev_tax_char_t pay_element_entry_values_f.screen_entry_value%TYPE;

Line 2810: l_tax_code_t pay_element_entry_values_f.screen_entry_value%TYPE;

2806: l_tax_code pay_element_entry_values_f.screen_entry_value%TYPE;
2807: l_tax_basis pay_element_entry_values_f.screen_entry_value%TYPE;
2808: l_prev_pay_char pay_element_entry_values_f.screen_entry_value%TYPE;
2809: l_prev_tax_char pay_element_entry_values_f.screen_entry_value%TYPE;
2810: l_tax_code_t pay_element_entry_values_f.screen_entry_value%TYPE;
2811: l_tax_basis_t pay_element_entry_values_f.screen_entry_value%TYPE;
2812: l_prev_pay_char_t pay_element_entry_values_f.screen_entry_value%TYPE;
2813: l_prev_tax_char_t pay_element_entry_values_f.screen_entry_value%TYPE;
2814: --

Line 2811: l_tax_basis_t pay_element_entry_values_f.screen_entry_value%TYPE;

2807: l_tax_basis pay_element_entry_values_f.screen_entry_value%TYPE;
2808: l_prev_pay_char pay_element_entry_values_f.screen_entry_value%TYPE;
2809: l_prev_tax_char pay_element_entry_values_f.screen_entry_value%TYPE;
2810: l_tax_code_t pay_element_entry_values_f.screen_entry_value%TYPE;
2811: l_tax_basis_t pay_element_entry_values_f.screen_entry_value%TYPE;
2812: l_prev_pay_char_t pay_element_entry_values_f.screen_entry_value%TYPE;
2813: l_prev_tax_char_t pay_element_entry_values_f.screen_entry_value%TYPE;
2814: --
2815: l_taxable NUMBER;

Line 2812: l_prev_pay_char_t pay_element_entry_values_f.screen_entry_value%TYPE;

2808: l_prev_pay_char pay_element_entry_values_f.screen_entry_value%TYPE;
2809: l_prev_tax_char pay_element_entry_values_f.screen_entry_value%TYPE;
2810: l_tax_code_t pay_element_entry_values_f.screen_entry_value%TYPE;
2811: l_tax_basis_t pay_element_entry_values_f.screen_entry_value%TYPE;
2812: l_prev_pay_char_t pay_element_entry_values_f.screen_entry_value%TYPE;
2813: l_prev_tax_char_t pay_element_entry_values_f.screen_entry_value%TYPE;
2814: --
2815: l_taxable NUMBER;
2816: l_paye NUMBER;

Line 2813: l_prev_tax_char_t pay_element_entry_values_f.screen_entry_value%TYPE;

2809: l_prev_tax_char pay_element_entry_values_f.screen_entry_value%TYPE;
2810: l_tax_code_t pay_element_entry_values_f.screen_entry_value%TYPE;
2811: l_tax_basis_t pay_element_entry_values_f.screen_entry_value%TYPE;
2812: l_prev_pay_char_t pay_element_entry_values_f.screen_entry_value%TYPE;
2813: l_prev_tax_char_t pay_element_entry_values_f.screen_entry_value%TYPE;
2814: --
2815: l_taxable NUMBER;
2816: l_paye NUMBER;
2817: --

Line 2953: pay_element_entry_values_f v,

2949: pay_previous,
2950: max(decode(iv.name,'Tax Previous',screen_entry_value))
2951: tax_previous
2952: FROM pay_element_entries_f e,
2953: pay_element_entry_values_f v,
2954: pay_input_values_f iv,
2955: pay_element_links_f link
2956: WHERE e.assignment_id = p_assignment_id
2957: AND link.element_type_id = g_paye_details_id