APPS.PQP_GB_PSI_FUNCTIONS dependencies on BEN_EXT_DFN

Line 250: ben_ext_dfn bed

246: pay_event_updates peu
247: where pde.event_group_id in (select becv.val_1
248: from ben_ext_crit_val becv,
249: ben_ext_crit_typ bect,
250: ben_ext_dfn bed
251: where becv.ext_crit_typ_id = bect.ext_crit_typ_id
252: and bect.ext_crit_prfl_id = bed.ext_crit_prfl_id
253: and bed.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
254: and bect.crit_typ_cd = 'CPE')

Line 931: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;

927: ,p_year_end_close IN VARCHAR2 default 'N' -- /* Nuvos Changes */
928: ,p_short_time_hours_single IN VARCHAR2 default 'INCLUDE' -- For Bug 7010282
929: ) IS
930:
931: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
932: l_proc_name VARCHAR2(61):= g_proc_name||'PQP_Penserver_Extract';
933: l_errbuff VARCHAR2(3000);
934: l_retcode NUMBER;
935: l_extract_name ben_ext_dfn.name%TYPE;

Line 935: l_extract_name ben_ext_dfn.name%TYPE;

931: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
932: l_proc_name VARCHAR2(61):= g_proc_name||'PQP_Penserver_Extract';
933: l_errbuff VARCHAR2(3000);
934: l_retcode NUMBER;
935: l_extract_name ben_ext_dfn.name%TYPE;
936: l_extract_shortname VARCHAR2(80);
937: l_extract_count NUMBER;
938:
939: l_request_id fnd_concurrent_requests.request_id%TYPE;

Line 2776: FROM BEN_EXT_DFN

2772: --115.87/115.88:Bug 7291713: Start
2773: CURSOR csr_get_bas_ext_dfn_id
2774: IS
2775: SELECT ext_dfn_id
2776: FROM BEN_EXT_DFN
2777: WHERE name = 'PQP GB PenServer Periodic Changes Interface - Basic Data'
2778: AND legislation_code ='GB';
2779:
2780: CURSOR csr_get_max_asg_end_date

Line 3275: from ben_ext_dfn

3271:
3272: CURSOR csr_dfn_code
3273: IS
3274: Select output_name
3275: from ben_ext_dfn
3276: where ext_dfn_id = ben_ext_thread.g_ext_dfn_id;
3277:
3278: l_extract_code csr_dfn_code%rowtype;
3279: l_file_name VARCHAR2(100);