DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_RETRO_COMPONENTS_S

Line 2417: (p_short_name in pay_retro_components.short_name%TYPE

2413: -- then the details will be updated.
2414: -- else a new retro component will be created.
2415: --------------------------------------------------------------------------
2416: FUNCTION create_retro_components
2417: (p_short_name in pay_retro_components.short_name%TYPE
2418: ,p_component_name in pay_retro_components.component_name%TYPE
2419: ,p_retro_type in pay_retro_components.retro_type%TYPE
2420: ,p_recalc_style in pay_retro_components.recalculation_style%TYPE
2421: ,p_date_override_proc in pay_retro_components.date_override_procedure%TYPE

Line 2437: SELECT pay_retro_components_s.nextval

2433: AND legislation_code = g_legislation_code;
2434: --
2435: CURSOR csr_get_comp_id
2436: IS
2437: SELECT pay_retro_components_s.nextval
2438: FROM dual;
2439: --
2440: BEGIN
2441: --