DBA Data[Home] [Help]

APPS.PAY_ES_RUN_TYPES dependencies on PAY_RUN_TYPES_F

Line 97: FROM pay_run_types_f prt

93: --
94: CURSOR get_run_types(c_element_type_id NUMBER) IS
95: SELECT prt.run_type_id
96: ,prt.shortname
97: FROM pay_run_types_f prt
98: WHERE legislation_code = 'ES'
99: AND prt.shortname = 'TAX_WITHHOLDING_RATE'
100: AND p_effective_date between effective_start_date and effective_end_date
101: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL

Line 122: FROM pay_run_types_f_tl prt

118: AND c_effective_date BETWEEN pet.effective_start_date and pet.effective_end_date;
119:
120: CURSOR csr_get_run_type_print_info(c_run_type_id NUMBER) IS
121: SELECT prt.run_type_name run_type_name
122: FROM pay_run_types_f_tl prt
123: WHERE prt.run_type_id = c_run_type_id
124: AND prt.language = USERENV('LANG');
125:
126: l_usage_exist varchar2(1);