APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on BEN_EXT_THREAD

Line 2564: AND ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH2

2560: ,last_update_date = SYSDATE
2561: ,last_update_login = fnd_global.login_id
2562: ,object_version_number = (object_version_number + 1)
2563: WHERE record_type = 'X'
2564: AND ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH2
2565: AND lea_number = g_lea_number; --ENH1
2566:
2567: END IF;
2568:

Line 10838: AND emd.ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH3

10834: SELECT *
10835: FROM pqp_ext_cross_person_records emd
10836: WHERE emd.record_type = 'X'
10837: AND emd.national_identifier = p_national_identifier
10838: AND emd.ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH3
10839: AND emd.lea_number = g_lea_number --ENH3
10840: FOR UPDATE OF processing_status NOWAIT;
10841:
10842:

Line 10926: ,ben_ext_thread.g_ext_dfn_id --ENH3

10922: ,object_version_number
10923: )
10924: VALUES
10925: ('X'
10926: ,ben_ext_thread.g_ext_dfn_id --ENH3
10927: ,pqp_gb_tp_pension_extracts.g_lea_number --ENH3
10928: ,p_business_group_id
10929: ,p_person_id
10930: ,p_national_identifier

Line 15895: debug('ben_ext_thread.g_ext_rslt_id :'||to_char(ben_ext_thread.g_ext_rslt_id),10);

15891: BEGIN -- create_new_lines
15892:
15893: debug_enter(l_proc_name);
15894:
15895: debug('ben_ext_thread.g_ext_rslt_id :'||to_char(ben_ext_thread.g_ext_rslt_id),10);
15896: debug('g_ext_dtl_rcd_id :'||to_char(g_ext_dtl_rcd_id),20);
15897: debug('person id :'||to_char(g_ext_asg_details(p_assignment_id).person_id),30);
15898: debug('assignment id :'||to_char(p_assignment_id),40);
15899:

Line 15903: ,p_ext_rslt_id => ben_ext_thread.g_ext_rslt_id

15899:
15900: -- Get the main detail record
15901: OPEN csr_rslt_dtl
15902: (p_person_id => g_ext_asg_details(p_assignment_id).person_id
15903: ,p_ext_rslt_id => ben_ext_thread.g_ext_rslt_id
15904: );
15905: FETCH csr_rslt_dtl INTO l_main_rec;
15906: IF csr_rslt_dtl%NOTFOUND THEN
15907: debug('No Data Found in csr_rslt_dtl', 50);

Line 16711: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id

16707: CLOSE csr_ext_rcd_id;
16708:
16709: DELETE
16710: FROM ben_ext_rslt_dtl dtl
16711: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
16712: AND dtl.ext_rcd_id = l_ext_dtl_rcd_id
16713: AND dtl.val_01 = 'DELETE';
16714:
16715: debug('Number of Dummy Records Deleted :'||to_char(SQL%ROWCOUNT));