DBA Data[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on DBMS_UTILITY

Line 11526: l_start_time := dbms_utility.get_time;

11522: -- the date a person becomes a leaver, if he becomes a leaver that is.
11523:
11524: --PROFILE changes
11525: IF(NVL(g_trace,'N') = 'Y') THEN
11526: l_start_time := dbms_utility.get_time;
11527: END IF ;
11528:
11529: l_inclusion_flag := chk_has_tchr_elected_pension
11530: (p_business_group_id => p_business_group_id

Line 11539: l_end_time := dbms_utility.get_time;

11535: );
11536:
11537: --PROFILE changes
11538: IF (NVL(g_trace,'N') = 'Y') THEN
11539: l_end_time := dbms_utility.get_time;
11540: debug('EXECUTION_TIME: chk_has_tchr_elected_pension: '||to_char(ABS(l_end_time - l_start_time)),15) ;
11541: END IF ;
11542:
11543: IF l_inclusion_flag = 'Y' THEN