eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on HR_API

Line 3287: AND DECODE(NVL(TRIM(p_type),hr_api.g_varchar2)

3283: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
3284: --AND rcd.ext_rcd_id = dtl.ext_rcd_id
3285: --AND rcd.rcd_type_cd = 'D'
3286: AND dtl.ext_rcd_id = p_ext_rcd_id
3287: AND DECODE(NVL(TRIM(p_type),hr_api.g_varchar2)
3288: ,hr_api.g_varchar2,hr_api.g_varchar2
3289: ,dtl.val_01
3290: ) = NVL(TRIM(p_type),hr_api.g_varchar2)
3291: AND dtl.val_01 <> 'DELETE';

Line 3288: ,hr_api.g_varchar2,hr_api.g_varchar2

3284: --AND rcd.ext_rcd_id = dtl.ext_rcd_id
3285: --AND rcd.rcd_type_cd = 'D'
3286: AND dtl.ext_rcd_id = p_ext_rcd_id
3287: AND DECODE(NVL(TRIM(p_type),hr_api.g_varchar2)
3288: ,hr_api.g_varchar2,hr_api.g_varchar2
3289: ,dtl.val_01
3290: ) = NVL(TRIM(p_type),hr_api.g_varchar2)
3291: AND dtl.val_01 <> 'DELETE';
3292:

Line 3290: ) = NVL(TRIM(p_type),hr_api.g_varchar2)

3286: AND dtl.ext_rcd_id = p_ext_rcd_id
3287: AND DECODE(NVL(TRIM(p_type),hr_api.g_varchar2)
3288: ,hr_api.g_varchar2,hr_api.g_varchar2
3289: ,dtl.val_01
3290: ) = NVL(TRIM(p_type),hr_api.g_varchar2)
3291: AND dtl.val_01 <> 'DELETE';
3292:
3293: l_count NUMBER:= 0;
3294: l_count_099999 VARCHAR2(6):= '000000';