APPS.GHR_NFC_POSITION_EXTRACTS dependencies on BEN_EXT_DFN

Line 103: ,ben_ext_dfn dfn

99: ,c_rcd_type_cd IN VARCHAR2) IS
100: SELECT rcd.ext_rcd_id
101: FROM ben_ext_rcd rcd
102: ,ben_ext_rcd_in_file rin
103: ,ben_ext_dfn dfn
104: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
105: AND rin.ext_file_id = dfn.ext_file_id
106: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden
107: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 160: ,ben_ext_dfn dfn

156:
157: SELECT rslt.ext_rslt_dtl_id
158: FROM ben_ext_rcd rcd
159: ,ben_ext_rcd_in_file rin
160: ,ben_ext_dfn dfn
161: ,ben_ext_rslt_dtl rslt
162: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
163: AND rin.ext_file_id = dfn.ext_file_id
164: AND rin.hide_flag = c_ext_hide_flag -- Y=Hidden, N=Not Hidden

Line 2958: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;

2954: l_req_params csr_req_params%ROWTYPE;
2955: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
2956: i per_all_assignments_f.business_group_id%TYPE;
2957: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
2958: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
2959: l_return_value Varchar2(2) :='Y';
2960: l_valid_action Varchar2(2) := 'Y';
2961: l_x_valid_action Varchar2(2) := 'Y';
2962: l_value Varchar2(150) ;

Line 3347: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;

3343: l_return_value VARCHAR2(1000);
3344: i per_all_assignments_f.business_group_id%TYPE;
3345: l_period_num per_time_periods.period_num%TYPE;
3346: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
3347: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
3348: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
3349: l_position_id NUMBER;
3350: l_start_date DATE;
3351: l_end_date DATE;

Line 3471: ,ben_ext_dfn dfn

3467: ,c_ext_dfn_id IN Number ) IS
3468: SELECT dtl.*
3469: FROM ben_ext_rcd rcd
3470: ,ben_ext_rcd_in_file rin
3471: ,ben_ext_dfn dfn
3472: ,ben_ext_rslt_dtl dtl
3473: WHERE dfn.ext_dfn_id = c_ext_dfn_id
3474: AND rin.ext_file_id = dfn.ext_file_id
3475: AND rin.hide_flag = 'N' -- Y=Hidden, N=Not Hidden

Line 3488: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;

3484: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
3485: l_proc_name VARCHAR2(150):= g_proc_name||'Del_Post_Process_Recs';
3486: l_return_value NUMBER := 0; --0= Sucess, -1=Error
3487: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
3488: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
3489: i_count NUMBER;
3490: l_main_rec csr_rslt_dtl%ROWTYPE;
3491: l_val_tab ValTabTyp;
3492: l_ext_position_id NUMBER;