DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_RUN_TYPES_F

Line 471: from pay_run_types_f

467: ,p_legislation_code in varchar2
468: ,p_run_type in varchar2
469: ) is
470: select run_type_id
471: from pay_run_types_f
472: where upper(run_type_name) = p_run_type
473: and p_effective_date between
474: effective_start_date and nvl(effective_end_date, hr_api.g_eot)
475: and