APPS.BEN_EXT_THREAD dependencies on BEN_EXT_RSLT_ERR

Line 2075: from ben_ext_rslt_err err

2071: and person_id not in (0, 999999999999);
2072: --
2073: cursor get_err_cnt is
2074: select count(*)
2075: from ben_ext_rslt_err err
2076: where err.ext_rslt_id = p_ext_rslt_id;
2077: --
2078: begin
2079: --

Line 5531: ben_Ext_rslt_err

5527: ;
5528: --
5529: cursor c_Ext_err_only (c_ext_rslt_id number) is
5530: select 'x' from
5531: ben_Ext_rslt_err
5532: where typ_cd = 'E'
5533: and ext_rslt_id = c_ext_rslt_id
5534: ;
5535: --

Line 6663: from ben_ext_rslt_err

6659:
6660: cursor c_xrer (c_person_id number) is
6661: select ext_rslt_err_id,
6662: object_version_number
6663: from ben_ext_rslt_err
6664: where person_id = c_person_id
6665: and ext_rslt_id = p_ext_rslt_id ;
6666:
6667: ---

Line 6709: ben_EXT_RSLT_ERR_api.delete_EXT_RSLT_ERR

6705: hr_utility.set_location ('deleting error'||pact.person_id, 177);
6706: end if;
6707:
6708: l_object_version_number := xrer.object_version_number ;
6709: ben_EXT_RSLT_ERR_api.delete_EXT_RSLT_ERR
6710: (p_ext_rslt_err_id => xrer.ext_rslt_err_id
6711: ,p_object_version_number => l_object_version_number
6712: ,p_effective_date => p_effective_date
6713: );