APPS.GHR_US_NFC_EXTRACTS dependencies on BEN_EXT_DFN

Line 63: ,ben_ext_dfn dfn

59: ,c_rcd_type_cd IN VARCHAR2) IS
60: SELECT rcd.ext_rcd_id
61: FROM ben_ext_rcd rcd
62: ,ben_ext_rcd_in_file rin
63: ,ben_ext_dfn dfn
64: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
65: AND rin.ext_file_id = dfn.ext_file_id
66: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden
67: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 177: ,ben_ext_dfn dfn

173: ) is
174: SELECT rcd.ext_rcd_id
175: FROM ben_ext_rcd rcd
176: ,ben_ext_rcd_in_file rin
177: ,ben_ext_dfn dfn
178: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
179: AND rin.ext_file_id = dfn.ext_file_id
180: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden
181: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 5246: ,ben_ext_dfn dfn

5242: ,rif.seq_num
5243: ,rif.sprs_cd
5244: ,rif.rqd_flag
5245: from ben_ext_rcd_in_file rif
5246: ,ben_ext_dfn dfn
5247: where rif.ext_file_id = dfn.ext_file_id
5248: and rif.ext_rcd_id = c_rcd_id
5249: and dfn.ext_dfn_id = c_ext_dfn_id;
5250: --

Line 6150: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;

6146: l_Has_Award_Actions boolean;
6147: l_Has_Add_chgs boolean;
6148: l_Asg_has_Rem boolean;
6149: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
6150: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
6151: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
6152: l_req_params csr_req_params%ROWTYPE;
6153: j per_all_assignments_f.business_group_id%TYPE;
6154: l_value Varchar2(150) ;

Line 6708: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;

6704: l_return_value VARCHAR2(1000);
6705: i per_all_assignments_f.business_group_id%TYPE;
6706: l_period_num per_time_periods.period_num%TYPE;
6707: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
6708: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
6709: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
6710: l_start_date DATE;
6711: l_end_date DATE;
6712: l_position_id NUMBER;