APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 2130: FROM pay_element_types_f pet

2126: BEGIN
2127:
2128: SELECT peev.screen_entry_value
2129: INTO l_comp_car
2130: FROM pay_element_types_f pet
2131: ,pay_input_values_f piv
2132: ,pay_element_entries_f peef
2133: ,pay_element_entry_values_f peev
2134: WHERE pet.element_name = 'Company Car Private Usage'

Line 2451: pay_element_types_f pet,

2447: /* select decode(prrv.result_value,'NL_NONE','0','1') code,ppa.date_earned,paa.assignment_action_id,ptp.start_date --,prrv.result_value
2448: from
2449: pay_payroll_actions ppa,
2450: pay_assignment_actions paa,
2451: pay_element_types_f pet,
2452: pay_input_values_f piv,
2453: pay_run_results prr,
2454: pay_run_result_values prrv,
2455: per_time_periods ptp

Line 2478: pay_element_types_f pet,

2474: from
2475: pay_payrolls_f ppf,
2476: pay_assignment_actions paa,
2477: pay_payroll_actions ppa,
2478: pay_element_types_f pet,
2479: pay_input_values_f piv,
2480: pay_run_results prr,
2481: pay_run_result_values prrv,
2482: per_time_periods ptp

Line 2662: pay_element_types_f pet,

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

Line 2688: pay_element_types_f pet,

2684: from
2685: pay_payrolls_f ppf,
2686: pay_assignment_actions paa,
2687: pay_payroll_actions ppa,
2688: pay_element_types_f pet,
2689: pay_input_values_f piv,
2690: pay_run_results prr,
2691: pay_run_result_values prrv
2692: where

Line 2760: ,pay_element_types_f pet

2756: pay_payrolls_f ppf
2757: ,pay_payroll_actions ppa
2758: ,pay_assignment_actions paa
2759: ,pay_run_results prr
2760: ,pay_element_types_f pet
2761: where ppa.payroll_action_id = paa.payroll_action_id
2762: and paa.assignment_id = p_assignment_id
2763: and paa.assignment_action_id = paa.assignment_action_id
2764: --11854614