APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on HR_API

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

3269: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
3270: --AND rcd.ext_rcd_id = dtl.ext_rcd_id
3271: --AND rcd.rcd_type_cd = 'D'
3272: AND dtl.ext_rcd_id = p_ext_rcd_id
3273: AND DECODE(NVL(TRIM(p_type),hr_api.g_varchar2)
3274: ,hr_api.g_varchar2,hr_api.g_varchar2
3275: ,dtl.val_01
3276: ) = NVL(TRIM(p_type),hr_api.g_varchar2)
3277: AND dtl.val_01 <> 'DELETE';

Line 3274: ,hr_api.g_varchar2,hr_api.g_varchar2

3270: --AND rcd.ext_rcd_id = dtl.ext_rcd_id
3271: --AND rcd.rcd_type_cd = 'D'
3272: AND dtl.ext_rcd_id = p_ext_rcd_id
3273: AND DECODE(NVL(TRIM(p_type),hr_api.g_varchar2)
3274: ,hr_api.g_varchar2,hr_api.g_varchar2
3275: ,dtl.val_01
3276: ) = NVL(TRIM(p_type),hr_api.g_varchar2)
3277: AND dtl.val_01 <> 'DELETE';
3278:

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

3272: AND dtl.ext_rcd_id = p_ext_rcd_id
3273: AND DECODE(NVL(TRIM(p_type),hr_api.g_varchar2)
3274: ,hr_api.g_varchar2,hr_api.g_varchar2
3275: ,dtl.val_01
3276: ) = NVL(TRIM(p_type),hr_api.g_varchar2)
3277: AND dtl.val_01 <> 'DELETE';
3278:
3279: l_count NUMBER:= 0;
3280: l_count_099999 VARCHAR2(6):= '000000';