APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on BEN_EXT_RCD

Line 209: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

205: -- Table of Table solution.
206: g_per_asg_leaver_dates t_leaver_dates_type;
207:
208: -- Added the following global variable for extended criteria
209: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
210:
211: -- this global will hold the set of leaver and restarter dates of the primary assignment.
212: -- PS : this global can only hold one primary asg at a time and is used inside multiple
213: -- service lines functionality, but it should not be refered to elsewhere

Line 1061: FROM ben_ext_rcd rcd

1057: CURSOR csr_ext_rcd_id(p_hide_flag IN VARCHAR2
1058: ,p_rcd_type_cd IN VARCHAR2
1059: ) IS
1060: SELECT rcd.ext_rcd_id
1061: FROM ben_ext_rcd rcd
1062: ,ben_ext_rcd_in_file RinF
1063: ,ben_ext_dfn dfn
1064: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
1065: AND RinF.ext_file_id = dfn.ext_file_id

Line 1062: ,ben_ext_rcd_in_file RinF

1058: ,p_rcd_type_cd IN VARCHAR2
1059: ) IS
1060: SELECT rcd.ext_rcd_id
1061: FROM ben_ext_rcd rcd
1062: ,ben_ext_rcd_in_file RinF
1063: ,ben_ext_dfn dfn
1064: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
1065: AND RinF.ext_file_id = dfn.ext_file_id
1066: AND RinF.hide_flag = p_hide_flag