APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_TIME_DEFINITIONS_S

Line 2565: (p_short_name pay_time_definitions.short_name%TYPE

2561: -- then the other fields will be updated.
2562: -- else a new time definition will be created.
2563: --------------------------------------------------------------------------
2564: FUNCTION create_time_definitions
2565: (p_short_name pay_time_definitions.short_name%TYPE
2566: ,p_definition_name pay_time_definitions.definition_name%TYPE
2567: ,p_period_type pay_time_definitions.period_type%TYPE
2568: ,p_period_unit pay_time_definitions.period_unit%TYPE
2569: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE

Line 2586: SELECT pay_time_definitions_s.nextval

2582: AND legislation_code = g_legislation_code;
2583: --
2584: CURSOR csr_get_time_definition
2585: IS
2586: SELECT pay_time_definitions_s.nextval
2587: from dual;
2588: --
2589: BEGIN
2590: --

Line 2899: (p_short_name pay_time_definitions.short_name%TYPE

2895: -- Private Function to get time definitions
2896: -- Bug#5556042
2897: --------------------------------------------------------------------------
2898: FUNCTION get_time_definitions
2899: (p_short_name pay_time_definitions.short_name%TYPE
2900: )
2901: RETURN NUMBER
2902: IS
2903: --