APPS.BEN_EXT_THREAD dependencies on BEN_EXT_RSLT_ERR

Line 2073: from ben_ext_rslt_err err

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

Line 5528: ben_Ext_rslt_err

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

Line 6622: from ben_ext_rslt_err

6618:
6619: cursor c_xrer (c_person_id number) is
6620: select ext_rslt_err_id,
6621: object_version_number
6622: from ben_ext_rslt_err
6623: where person_id = c_person_id
6624: and ext_rslt_id = p_ext_rslt_id ;
6625:
6626: ---

Line 6668: ben_EXT_RSLT_ERR_api.delete_EXT_RSLT_ERR

6664: hr_utility.set_location ('deleting error'||pact.person_id, 177);
6665: end if;
6666:
6667: l_object_version_number := xrer.object_version_number ;
6668: ben_EXT_RSLT_ERR_api.delete_EXT_RSLT_ERR
6669: (p_ext_rslt_err_id => xrer.ext_rslt_err_id
6670: ,p_object_version_number => l_object_version_number
6671: ,p_effective_date => p_effective_date
6672: );