APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on BEN_EXT_RSLT_DTL

Line 27: g_header_system_element ben_ext_rslt_dtl.val_01%type;

23: g_lea_number VARCHAR2(3):=RPAD(' ',3,' ');
24: g_crossbg_enabled VARCHAR2(1) := 'N';
25: g_estb_number VARCHAR2(4):='0000';
26: g_originators_title VARCHAR2(16);
27: g_header_system_element ben_ext_rslt_dtl.val_01%type;
28:
29: -- flag to check if there are more than one lea with the same lea numebr in tha same BG.
30: -- This flag will be set while setting the globals. and for the first valid assignment
31: -- warning msg will be displayed.

Line 553: ,ben_ext_rslt_dtl rdtl

549: ,p_business_group_id NUMBER DEFAULT NULL
550: ) IS
551: SELECT MIN(to_date(rdtl.VAL_13, 'DDMMYY')) prev_start_date
552: FROM ben_ext_rslt rslt
553: ,ben_ext_rslt_dtl rdtl
554: ,ben_ext_rcd drcd
555: ,pqp_extract_attributes pqea
556: WHERE pqea.ext_dfn_type = g_extract_type
557: AND rslt.ext_dfn_id = pqea.ext_dfn_id