APPS.PQP_GB_TP_EXT_PROCESS dependencies on BEN_EXT_RSLT_DTL

Line 214: FROM ben_ext_rslt_dtl xrd

210: --
211: CURSOR csr_get_dtl_cnt
212: IS
213: SELECT COUNT(*)
214: FROM ben_ext_rslt_dtl xrd
215: WHERE xrd.ext_rslt_id = p_ext_rslt_id;
216: --
217: -- Cursor to get person record count
218: --

Line 222: FROM ben_ext_rslt_dtl xrd

218: --
219: CURSOR csr_get_per_cnt
220: IS
221: SELECT COUNT(DISTINCT person_id)
222: FROM ben_ext_rslt_dtl xrd
223: WHERE xrd.ext_rslt_id = p_ext_rslt_id
224: AND person_id not in (0, 999999999999);
225: --
226: -- Cursor to get error record count

Line 497: FROM ben_ext_rslt_dtl

493: val_73,
494: val_74,
495: val_75,
496: business_group_id
497: FROM ben_ext_rslt_dtl
498: WHERE ext_rslt_id = c_ext_rslt_id;
499:
500: l_ext_rslt_dtl_rec csr_get_ext_rslt_dtl%ROWTYPE;
501:

Line 621: ben_ext_rslt_dtl_api.create_ext_rslt_dtl

617: DEBUG (l_proc_name, l_proc_step);
618: END IF;
619:
620: -- Create a copy
621: ben_ext_rslt_dtl_api.create_ext_rslt_dtl
622: (p_validate => FALSE
623: ,p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
624: ,p_prmy_sort_val => l_ext_rslt_dtl_rec.prmy_sort_val
625: ,p_scnd_sort_val => l_ext_rslt_dtl_rec.scnd_sort_val

Line 854: l_val_02 ben_ext_rslt_dtl.val_02%TYPE;

850: l_err_count NUMBER := 0;
851: l_tot_count NUMBER := 0;
852: l_output_name VARCHAR2(200); -- Do not use type
853: l_request_id NUMBER;
854: l_val_02 ben_ext_rslt_dtl.val_02%TYPE;
855: l_val_03 ben_ext_rslt_dtl.val_03%TYPE;
856: l_proc_name VARCHAR2 (80) := g_proc_name
857: || 'copy_extract_results';
858: l_proc_step NUMBER;

Line 855: l_val_03 ben_ext_rslt_dtl.val_03%TYPE;

851: l_tot_count NUMBER := 0;
852: l_output_name VARCHAR2(200); -- Do not use type
853: l_request_id NUMBER;
854: l_val_02 ben_ext_rslt_dtl.val_02%TYPE;
855: l_val_03 ben_ext_rslt_dtl.val_03%TYPE;
856: l_proc_name VARCHAR2 (80) := g_proc_name
857: || 'copy_extract_results';
858: l_proc_step NUMBER;
859:

Line 1069: UPDATE ben_ext_rslt_dtl rslt

1065: l_proc_step := 90;
1066: DEBUG (l_proc_name, l_proc_step);
1067: END IF;
1068:
1069: UPDATE ben_ext_rslt_dtl rslt
1070: SET val_02 = l_val_02
1071: ,val_03 = l_val_03
1072: WHERE ext_rslt_id = l_master_ext_rslt_id
1073: AND EXISTS ( SELECT 1 FROM ben_ext_rcd rcd