DBA Data[Home] [Help]

APPS.PAY_ECU_BUS dependencies on PAY_RUN_TYPES_F

Line 211: from pay_run_types_f prt

207: ) IS
208: --
209: CURSOR csr_chk_user_run_type(p_leg_code varchar2) is
210: select 'Y'
211: from pay_run_types_f prt
212: where prt.run_type_id = p_run_type_id
213: and p_effective_date between prt.effective_start_date
214: and prt.effective_end_date
215: and ((prt.business_group_id is not null

Line 224: from pay_run_types_f prt

220: and prt.legislation_code is null));
221: --
222: CURSOR csr_chk_startup_run_type is
223: select 'Y'
224: from pay_run_types_f prt
225: where prt.run_type_id = p_run_type_id
226: and p_effective_date between prt.effective_start_date
227: and prt.effective_end_date
228: and prt.business_group_id is null

Line 235: from pay_run_types_f prt

231: or (prt.legislation_code is null));
232: --
233: CURSOR csr_chk_generic_run_type is
234: select 'Y'
235: from pay_run_types_f prt
236: where prt.run_type_id = p_run_type_id
237: and p_effective_date between prt.effective_start_date
238: and prt.effective_end_date
239: and prt.business_group_id is null