DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on BEN_EXTRACT

Line 2230: p_ext_rslt_id => Ben_Extract.g_ext_rslt_id);

2226: p_err_name => l_err_name,
2227: p_typ_cd => 'W',
2228: p_person_id => g_person_id,
2229: p_business_group_id => g_business_group_id,
2230: p_ext_rslt_id => Ben_Extract.g_ext_rslt_id);
2231: END IF;
2232: --
2233: Hr_Utility.set_location('Exiting'||l_proc, 15);
2234: --

Line 2252: WHERE ext_rslt_id = ben_extract.g_ext_rslt_id

2248: l_err_num NUMBER(15);
2249: --
2250: CURSOR err_cnt_c IS
2251: SELECT count(*) FROM ben_ext_rslt_err
2252: WHERE ext_rslt_id = ben_extract.g_ext_rslt_id
2253: AND typ_cd <> 'W';
2254: --
2255: BEGIN
2256: --

Line 2289: p_ext_rslt_id => Ben_Extract.g_ext_rslt_id);

2285: p_err_name => l_err_name,
2286: p_typ_cd => 'E',
2287: p_person_id => g_person_id,
2288: p_business_group_id => g_business_group_id,
2289: p_ext_rslt_id => Ben_Extract.g_ext_rslt_id);
2290: END IF;
2291: --
2292: Hr_Utility.set_location('Exiting'||l_proc, 15);
2293: --