DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_TIME_DEFINITIONS_S

Line 2834: (p_short_name pay_time_definitions.short_name%TYPE

2830: -- then the other fields will be updated.
2831: -- else a new time definition will be created.
2832: --------------------------------------------------------------------------
2833: FUNCTION create_time_definitions
2834: (p_short_name pay_time_definitions.short_name%TYPE
2835: ,p_definition_name pay_time_definitions.definition_name%TYPE
2836: ,p_period_type pay_time_definitions.period_type%TYPE
2837: ,p_period_unit pay_time_definitions.period_unit%TYPE
2838: ,p_day_adjustment pay_time_definitions.day_adjustment%TYPE

Line 2855: SELECT pay_time_definitions_s.nextval

2851: AND legislation_code = g_legislation_code;
2852: --
2853: CURSOR csr_get_time_definition
2854: IS
2855: SELECT pay_time_definitions_s.nextval
2856: from dual;
2857: --
2858: BEGIN
2859: --

Line 3168: (p_short_name pay_time_definitions.short_name%TYPE

3164: -- Private Function to get time definitions
3165: -- Bug#5556042
3166: --------------------------------------------------------------------------
3167: FUNCTION get_time_definitions
3168: (p_short_name pay_time_definitions.short_name%TYPE
3169: )
3170: RETURN NUMBER
3171: IS
3172: --