eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_NL_PENSION_EXTRACTS dependencies on BEN_EXT_THREAD

Line 39: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id

35: rcd.rcd_type_cd
36: FROM ben_ext_rcd rcd
37: ,ben_ext_rcd_in_file rin
38: ,ben_ext_dfn dfn
39: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
40: AND rin.ext_file_id = dfn.ext_file_id
41: AND rin.ext_rcd_id = rcd.ext_rcd_id
42: ORDER BY rin.seq_num;
43:

Line 52: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently

48: SELECT rcd.ext_rcd_id
49: FROM ben_ext_rcd rcd
50: ,ben_ext_rcd_in_file rin
51: ,ben_ext_dfn dfn
52: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
53: AND rin.ext_file_id = dfn.ext_file_id
54: AND rin.ext_rcd_id = rcd.ext_rcd_id
55: AND rin.seq_num = c_seq;
56:

Line 258: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract

254: SELECT rcd.ext_rcd_id
255: FROM ben_ext_rcd rcd
256: ,ben_ext_rcd_in_file rin
257: ,ben_ext_dfn dfn
258: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract
259: AND rin.ext_file_id = dfn.ext_file_id
260: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden
261: AND rin.ext_rcd_id = rcd.ext_rcd_id
262: AND rcd.rcd_type_cd = c_rcd_type_cd; -- D=Detail,H=Header,F=Footer

Line 272: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id

268: SELECT rcd.ext_rcd_id
269: FROM ben_ext_rcd rcd
270: ,ben_ext_rcd_in_file rin
271: ,ben_ext_dfn dfn
272: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
273: AND rin.ext_file_id = dfn.ext_file_id
274: AND rin.ext_rcd_id = rcd.ext_rcd_id
275: AND rcd.rcd_type_cd = c_rcd_type_cd
276: ORDER BY rin.seq_num;

Line 1325: Ben_Ext_Thread.process

1321: IF g_debug THEN
1322: Hr_Utility.set_location('..Calling Benefit Ext Process'||l_proc_name, 6);
1323: END IF;
1324:
1325: Ben_Ext_Thread.process
1326: (errbuf => l_errbuff,
1327: retcode => l_retcode,
1328: p_benefit_action_id => NULL,
1329: p_ext_dfn_id => p_ext_dfn_id,

Line 1980: ,p_param1_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_dfn_id, -1))

1976: ,p_organization_id => l_org_id
1977: ,p_business_group_id => l_bgid
1978: ,p_jurisdiction_code => NULL
1979: ,p_param1 => 'EXT_DFN_ID'
1980: ,p_param1_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_dfn_id, -1))
1981: ,p_param2 => 'EXT_RSLT_ID'
1982: ,p_param2_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_rslt_id, -1))
1983: );
1984: l_ff_value := l_outputs(l_outputs.FIRST).VALUE;

Line 1982: ,p_param2_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_rslt_id, -1))

1978: ,p_jurisdiction_code => NULL
1979: ,p_param1 => 'EXT_DFN_ID'
1980: ,p_param1_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_dfn_id, -1))
1981: ,p_param2 => 'EXT_RSLT_ID'
1982: ,p_param2_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_rslt_id, -1))
1983: );
1984: l_ff_value := l_outputs(l_outputs.FIRST).VALUE;
1985: BEGIN
1986: IF i.frmt_mask_lookup_cd IS NOT NULL AND

Line 5593: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id

5589: rcd.rcd_type_cd
5590: FROM ben_ext_rcd rcd
5591: ,ben_ext_rcd_in_file rin
5592: ,ben_ext_dfn dfn
5593: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
5594: AND rin.ext_file_id = dfn.ext_file_id
5595: AND rin.ext_rcd_id = rcd.ext_rcd_id
5596: ORDER BY rin.seq_num;
5597:

Line 5647: l_ext_rslt_id := Ben_Ext_Thread.g_ext_rslt_id;

5643: BEGIN
5644:
5645: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
5646: i := p_business_group_id;
5647: l_ext_rslt_id := Ben_Ext_Thread.g_ext_rslt_id;
5648: l_ext_dfn_id := Ben_Ext_Thread.g_ext_dfn_id;
5649:
5650: IF NOT g_extract_params.EXISTS(i) THEN
5651: Hr_Utility.set_location('..Exract Params PL/SQL not populated ', 7);

Line 5648: l_ext_dfn_id := Ben_Ext_Thread.g_ext_dfn_id;

5644:
5645: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
5646: i := p_business_group_id;
5647: l_ext_rslt_id := Ben_Ext_Thread.g_ext_rslt_id;
5648: l_ext_dfn_id := Ben_Ext_Thread.g_ext_dfn_id;
5649:
5650: IF NOT g_extract_params.EXISTS(i) THEN
5651: Hr_Utility.set_location('..Exract Params PL/SQL not populated ', 7);
5652: -- Get the extract type, Changes extract or Full Profile

Line 6046: Ben_Ext_Thread.g_err_num := p_error_NUMBER;

6042: Nvl(Ben_Ext_Person.g_elmt_name
6043: ,Ben_Ext_Fmt.g_elmt_name)||'. '||
6044: p_error_text;
6045: ELSE
6046: Ben_Ext_Thread.g_err_num := p_error_NUMBER;
6047: Ben_Ext_Thread.g_err_name := p_error_text;
6048: l_error_text :=
6049: Ben_Ext_Fmt.get_error_msg(To_Number(Substr(p_error_text, 5, 5)),
6050: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );

Line 6047: Ben_Ext_Thread.g_err_name := p_error_text;

6043: ,Ben_Ext_Fmt.g_elmt_name)||'. '||
6044: p_error_text;
6045: ELSE
6046: Ben_Ext_Thread.g_err_num := p_error_NUMBER;
6047: Ben_Ext_Thread.g_err_name := p_error_text;
6048: l_error_text :=
6049: Ben_Ext_Fmt.get_error_msg(To_Number(Substr(p_error_text, 5, 5)),
6050: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );
6051:

Line 6102: l_ext_rslt_id := Ben_Ext_Thread.g_ext_rslt_id;

6098: l_ext_rslt_id Number;
6099:
6100: BEGIN
6101:
6102: l_ext_rslt_id := Ben_Ext_Thread.g_ext_rslt_id;
6103: RETURN l_ext_rslt_id;
6104:
6105: EXCEPTION
6106: WHEN e_extract_process_not_running THEN

Line 12413: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

12409: CLOSE c_get_rcd_id;
12410:
12411: --first fetch the data from the result detail record
12412: OPEN csr_rslt_dtl(c_person_id => g_person_id
12413: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
12414: ,c_ext_dtl_rcd_id => l_rcd_id
12415: );
12416:
12417: FETCH csr_rslt_dtl INTO l_main_rec;

Line 12547: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

12543: FETCH c_get_rcd_id INTO l_rcd_id;
12544: CLOSE c_get_rcd_id;
12545:
12546: OPEN csr_rslt_dtl(c_person_id => g_person_id
12547: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
12548: ,c_ext_dtl_rcd_id => l_rcd_id);
12549: FETCH csr_rslt_dtl INTO l_main_rec;
12550: CLOSE csr_rslt_dtl;
12551:

Line 12732: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

12728: FETCH c_get_rcd_id INTO l_rcd_id;
12729: CLOSE c_get_rcd_id;
12730:
12731: OPEN csr_rslt_dtl(c_person_id => g_person_id
12732: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
12733: ,c_ext_dtl_rcd_id => l_rcd_id);
12734: FETCH csr_rslt_dtl INTO l_main_rec;
12735: CLOSE csr_rslt_dtl;
12736:

Line 12855: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

12851: FETCH c_get_rcd_id INTO l_rcd_id;
12852: CLOSE c_get_rcd_id;
12853:
12854: OPEN csr_rslt_dtl(c_person_id => g_person_id
12855: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
12856: ,c_ext_dtl_rcd_id => l_rcd_id
12857: );
12858: FETCH csr_rslt_dtl INTO l_main_rec;
12859: CLOSE csr_rslt_dtl;

Line 12927: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

12923: FETCH c_get_rcd_id INTO l_rcd_id;
12924: CLOSE c_get_rcd_id;
12925:
12926: OPEN csr_rslt_dtl(c_person_id => g_person_id
12927: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
12928: ,c_ext_dtl_rcd_id => l_rcd_id
12929: );
12930:
12931: FETCH csr_rslt_dtl INTO l_main_rec;

Line 13065: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

13061: CLOSE c_get_rcd_id;
13062:
13063: --first fetch the data from the result detail record
13064: OPEN csr_rslt_dtl(c_person_id => g_person_id
13065: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
13066: ,c_ext_dtl_rcd_id => l_rcd_id
13067: );
13068:
13069: FETCH csr_rslt_dtl INTO l_main_rec;

Line 13131: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

13127: FETCH c_get_rcd_id INTO l_rcd_id;
13128: CLOSE c_get_rcd_id;
13129:
13130: OPEN csr_rslt_dtl(c_person_id => g_person_id
13131: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
13132: ,c_ext_dtl_rcd_id => l_rcd_id
13133: );
13134: FETCH csr_rslt_dtl INTO l_main_rec;
13135: CLOSE csr_rslt_dtl;

Line 13192: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

13188: CLOSE c_get_rcd_id;
13189:
13190: --first fetch the data from the result detail record
13191: OPEN csr_rslt_dtl(c_person_id => g_person_id
13192: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
13193: ,c_ext_dtl_rcd_id => l_rcd_id
13194: );
13195:
13196: FETCH csr_rslt_dtl INTO l_main_rec;

Line 13267: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

13263: FETCH c_get_rcd_id INTO l_rcd_id;
13264: CLOSE c_get_rcd_id;
13265:
13266: OPEN csr_rslt_dtl(c_person_id => g_person_id
13267: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
13268: ,c_ext_dtl_rcd_id => l_rcd_id
13269: );
13270: FETCH csr_rslt_dtl INTO l_main_rec;
13271: CLOSE csr_rslt_dtl;

Line 13305: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

13301: FETCH c_get_rcd_id INTO l_rcd_id;
13302: CLOSE c_get_rcd_id;
13303:
13304: OPEN csr_rslt_dtl(c_person_id => g_person_id
13305: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
13306: ,c_ext_dtl_rcd_id => l_rcd_id
13307: );
13308: FETCH csr_rslt_dtl INTO l_main_rec;
13309: CLOSE csr_rslt_dtl;

Line 14387: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

14383: '21','22','30','31','40','41','41h') THEN
14384: l_record_num := g_ext_rcds(l_ext_rcd_id).record_number;
14385: OPEN csr_rslt_dtl
14386: (c_person_id => p_person_id
14387: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
14388: ,c_ext_dtl_rcd_id => l_ext_rcd_id
14389: );
14390: FETCH csr_rslt_dtl INTO l_main_rec;
14391:

Line 14400: l_main_rec.ext_rslt_id := ben_ext_thread.g_ext_rslt_id;

14396: FETCH cur_per_info INTO l_national_ident,l_last_name,l_prefix,l_dob;
14397: CLOSE cur_per_info;
14398:
14399: l_main_rec := NULL;
14400: l_main_rec.ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
14401: l_main_rec.business_group_id := p_business_group_id;
14402: l_main_rec.ext_rcd_id := l_ext_rcd_id;
14403: l_main_rec.person_id := p_person_id;
14404: l_main_rec.val_01 := l_record_num;

Line 14554: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

14550: -- Loop through each detail record for the extract
14551: LOOP
14552: OPEN csr_rslt_dtl
14553: (c_person_id => l_person_id
14554: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
14555: ,c_ext_dtl_rcd_id => csr_rcd_rec.ext_rcd_id
14556: );
14557: FETCH csr_rslt_dtl INTO l_main_rec;
14558: WHILE csr_rslt_dtl%FOUND

Line 14578: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

14574: -- Loop through each detail record for the extract
14575: LOOP
14576: OPEN csr_rslt_dtl
14577: (c_person_id => l_person_id
14578: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
14579: ,c_ext_dtl_rcd_id => csr_rcd_rec.ext_rcd_id
14580: );
14581: FETCH csr_rslt_dtl INTO l_main_rec;
14582: WHILE csr_rslt_dtl%FOUND

Line 16244: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id

16240: ,c_recordid_2 IN NUMBER
16241: ,c_emr_id IN NUMBER ) IS
16242: SELECT Count(dtl.ext_rslt_dtl_id)
16243: FROM ben_ext_rslt_dtl dtl
16244: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
16245: AND ext_rcd_id NOT IN(c_recordid_1,c_recordid_2)
16246: AND val_25 = c_emr_id;
16247:
16248: l_proc_name VARCHAR2(150) := g_proc_name ||'.Get_All_Records_Count';

Line 16286: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

16282: ,c_recordid_3 IN Number
16283: ,c_emr_id IN Number ) IS
16284: SELECT Count(dtl.ext_rslt_dtl_id)
16285: FROM ben_ext_rslt_dtl dtl
16286: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
16287: AND ext_rcd_id IN(c_recordid_1,c_recordid_2,c_recordid_3)
16288: AND val_25=c_emr_id;
16289:
16290: l_proc_name Varchar2(150) := g_proc_name ||'.Get_Trailer_Record_Count';

Line 16356: WHERE ext_rslt_id=Ben_Ext_Thread.g_ext_rslt_id

16352: -- Cursor to get the person existence flag
16353: CURSOR csr_get_person_exist(c_org_id IN Number) IS
16354: SELECT 'x'
16355: FROM ben_ext_rslt_dtl
16356: WHERE ext_rslt_id=Ben_Ext_Thread.g_ext_rslt_id
16357: AND val_25=c_org_id;
16358:
16359: --
16360: -- Cursor to get the record id for Rec 05

Line 16367: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id

16363: SELECT rcd.ext_rcd_id,rin.seq_num
16364: FROM ben_ext_rcd rcd
16365: ,ben_ext_rcd_in_file rin
16366: ,ben_ext_dfn dfn
16367: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
16368: AND rin.ext_file_id = dfn.ext_file_id
16369: AND rin.ext_rcd_id = rcd.ext_rcd_id
16370: AND rin.seq_num = 5;
16371:

Line 16378: WHERE ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

16374: --
16375: CURSOR csr_rec05_del (p_ext_rcd_id IN NUMBER) IS
16376: SELECT ext_rslt_dtl_id
16377: FROM ben_ext_rslt_dtl
16378: WHERE ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
16379: AND ext_rcd_id = p_ext_rcd_id
16380: AND val_05 = '00000000'
16381: AND val_06 = '00000000'
16382: AND val_07 = '00000000'

Line 16464: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

16460: LOOP
16461: -- Delete all detail records for the record
16462: DELETE ben_ext_rslt_dtl
16463: WHERE ext_rcd_id = csr_rcd_rec.ext_rcd_id
16464: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
16465: AND business_group_id = p_business_group_id;
16466: END LOOP; -- FOR csr_rcd_rec
16467:
16468: --

Line 16483: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )

16479:
16480: -- All orgs,fill up the temp. table with the org ids in order of
16481: --the sort value
16482: FOR val IN csr_get_rslt1
16483: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )
16484: LOOP
16485: hr_utility.set_location('val 26 : '||val.val_26,10);
16486: IF g_org_list.EXISTS(val.val_25) THEN
16487: IF NOT g_ord_details1.EXISTS(val.val_25) THEN

Line 16513: OPEN csr_get_trailer_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

16509: --create our own trailer records for each org based on these
16510: FOR csr_rcd_rec IN csr_ext_rcd_id(c_hide_flag => 'N'
16511: ,c_rcd_type_cd => 'T')-- T-Trailer
16512: LOOP
16513: OPEN csr_get_trailer_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
16514: ,c_ext_dtl_rcd_id => csr_rcd_rec.ext_rcd_id);
16515: FETCH csr_get_trailer_rslt INTO l_trailer_main_rec;
16516: CLOSE csr_get_trailer_rslt;
16517: IF g_rcd_dtls(94).ext_rcd_id = csr_rcd_rec.ext_rcd_id THEN

Line 16536: OPEN csr_get_header_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

16532: --header record created by benefits needs to be deleted later
16533: FOR csr_rcd_rec IN csr_ext_rcd_id(c_hide_flag => 'N'
16534: ,c_rcd_type_cd => 'H')-- H-Header
16535: LOOP
16536: OPEN csr_get_header_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
16537: ,c_ext_dtl_rcd_id => csr_rcd_rec.ext_rcd_id);
16538: FETCH csr_get_header_rslt INTO l_header_main_rec;
16539: CLOSE csr_get_header_rslt;
16540: IF g_rcd_dtls(00).ext_rcd_id = csr_rcd_rec.ext_rcd_id THEN

Line 16556: OPEN csr_get_header_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

16552: --Loop through Header records
16553: FOR csr_rcd_rec IN csr_ext_rcd_id(c_hide_flag => 'N'
16554: ,c_rcd_type_cd => 'H')-- H-Header
16555: LOOP
16556: OPEN csr_get_header_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
16557: ,c_ext_dtl_rcd_id => csr_rcd_rec.ext_rcd_id);
16558: FETCH csr_get_header_rslt INTO l_header_main_rec;
16559: CLOSE csr_get_header_rslt;
16560: l_header_new_rec := l_header_main_rec;

Line 16612: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )

16608: Hr_Utility.set_location('Current Org Id:---------'||g_employer_child_list(l_group_org_index).gre_org_id, 25);
16609: -- Get all rows/persons for this orgid
16610: FOR val IN csr_get_rslt
16611: (c_org_id => g_employer_child_list(l_group_org_index).gre_org_id
16612: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )
16613: LOOP
16614: --Hr_Utility.set_location('val'||val.EXT_RSLT_DTL_ID ,26);
16615: -- Get the individual row using sortid key
16616: -- So we will get only one record related data per person

Line 16619: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

16615: -- Get the individual row using sortid key
16616: -- So we will get only one record related data per person
16617: FOR ind_dtl IN csr_rslt_dtl_sort
16618: (c_val_26 => val.val_26
16619: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
16620: )
16621: LOOP
16622: l_main_rec := ind_dtl;
16623: l_main_rec.object_version_NUMBER := Nvl(l_main_rec.object_version_NUMBER,0) + 1;

Line 16811: OPEN csr_get_trailer_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

16807: FOR csr_rcd_rec IN csr_ext_rcd_id(c_hide_flag => 'N'
16808: ,c_rcd_type_cd => 'T')-- T-Trailer
16809: LOOP
16810: l_insert_trailer := 1;
16811: OPEN csr_get_trailer_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
16812: ,c_ext_dtl_rcd_id => csr_rcd_rec.ext_rcd_id);
16813: FETCH csr_get_trailer_rslt INTO l_trailer_main_rec;
16814: CLOSE csr_get_trailer_rslt;
16815: l_trailer_new_rec := l_trailer_main_rec;

Line 16985: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

16981: END IF;
16982:
16983: DELETE
16984: FROM ben_ext_rslt_dtl dtl
16985: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
16986: AND dtl.ext_rcd_id = csr_rcd_rec.ext_rcd_id
16987: AND dtl.ext_rslt_dtl_id = l_ext_rslt_dtl_id
16988: AND business_group_id = p_business_group_id;
16989:

Line 17001: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

16997: END IF;
16998:
16999: DELETE
17000: FROM ben_ext_rslt_dtl dtl
17001: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
17002: AND dtl.ext_rcd_id = csr_rcd_rec.ext_rcd_id
17003: AND dtl.ext_rslt_dtl_id = l_ext_rslt_dtl_id
17004: AND business_group_id = p_business_group_id;
17005: