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_NL_TAXOFFICE_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 2112: FROM pay_element_types_f pet

2108: BEGIN
2109:
2110: SELECT peev.screen_entry_value
2111: INTO l_comp_car
2112: FROM pay_element_types_f pet
2113: ,pay_input_values_f piv
2114: ,pay_element_entries_f peef
2115: ,pay_element_entry_values_f peev
2116: WHERE pet.element_name = 'Company Car Private Usage'

Line 2433: pay_element_types_f pet,

2429: /* select decode(prrv.result_value,'NL_NONE','0','1') code,ppa.date_earned,paa.assignment_action_id,ptp.start_date --,prrv.result_value
2430: from
2431: pay_payroll_actions ppa,
2432: pay_assignment_actions paa,
2433: pay_element_types_f pet,
2434: pay_input_values_f piv,
2435: pay_run_results prr,
2436: pay_run_result_values prrv,
2437: per_time_periods ptp

Line 2459: pay_element_types_f pet,

2455: select /*+ORDERED INDEX(ptp PER_TIME_PERIODS_PK) */ decode(prrv.result_value,'NL_NONE','0','1') code,ppa.date_earned,paa.assignment_action_id,ptp.start_date --,prrv.result_value
2456: from
2457: pay_assignment_actions paa,
2458: pay_payroll_actions ppa,
2459: pay_element_types_f pet,
2460: pay_input_values_f piv,
2461: pay_run_results prr,
2462: pay_run_result_values prrv,
2463: per_time_periods ptp

Line 2639: pay_element_types_f pet,

2635: /* select count(prrv.result_value) counter,prrv.result_value
2636: from
2637: pay_payroll_actions ppa,
2638: pay_assignment_actions paa,
2639: pay_element_types_f pet,
2640: pay_input_values_f piv,
2641: pay_run_results prr,
2642: pay_run_result_values prrv
2643: where

Line 2664: pay_element_types_f pet,

2660: select /*+ ORDERED */ count(prrv.result_value) counter,prrv.result_value
2661: from
2662: pay_assignment_actions paa,
2663: pay_payroll_actions ppa,
2664: pay_element_types_f pet,
2665: pay_input_values_f piv,
2666: pay_run_results prr,
2667: pay_run_result_values prrv
2668: where

Line 2730: ,pay_element_types_f pet

2726: where exists
2727: (select /*+ USE_NL(paa, ppa, pet,prr) */ prr.run_result_id,ppa.date_earned from pay_payroll_actions ppa
2728: ,pay_assignment_actions paa
2729: ,pay_run_results prr
2730: ,pay_element_types_f pet
2731: where ppa.payroll_action_id = paa.payroll_action_id
2732: and paa.assignment_id = p_assignment_id
2733: and paa.assignment_action_id = paa.assignment_action_id
2734: and ppa.date_earned between p_tax_year_start_date and p_tax_year_end_date