APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on BEN_EXT_RCD

Line 206: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

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

Line 1052: FROM ben_ext_rcd rcd

1048: CURSOR csr_ext_rcd_id(p_hide_flag IN VARCHAR2
1049: ,p_rcd_type_cd IN VARCHAR2
1050: ) IS
1051: SELECT rcd.ext_rcd_id
1052: FROM ben_ext_rcd rcd
1053: ,ben_ext_rcd_in_file RinF
1054: ,ben_ext_dfn dfn
1055: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
1056: AND RinF.ext_file_id = dfn.ext_file_id

Line 1053: ,ben_ext_rcd_in_file RinF

1049: ,p_rcd_type_cd IN VARCHAR2
1050: ) IS
1051: SELECT rcd.ext_rcd_id
1052: FROM ben_ext_rcd rcd
1053: ,ben_ext_rcd_in_file RinF
1054: ,ben_ext_dfn dfn
1055: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
1056: AND RinF.ext_file_id = dfn.ext_file_id
1057: AND RinF.hide_flag = p_hide_flag