APPS.PQP_GB_PSI_FUNCTIONS dependencies on BEN_EXT_DFN

Line 867: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;

863: ,p_year_end_close IN VARCHAR2 default 'N' -- /* Nuvos Changes */
864: ,p_short_time_hours_single IN VARCHAR2 default 'INCLUDE' -- For Bug 7010282
865: ) IS
866:
867: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
868: l_proc_name VARCHAR2(61):= g_proc_name||'PQP_Penserver_Extract';
869: l_errbuff VARCHAR2(3000);
870: l_retcode NUMBER;
871: l_extract_name ben_ext_dfn.name%TYPE;

Line 871: l_extract_name ben_ext_dfn.name%TYPE;

867: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
868: l_proc_name VARCHAR2(61):= g_proc_name||'PQP_Penserver_Extract';
869: l_errbuff VARCHAR2(3000);
870: l_retcode NUMBER;
871: l_extract_name ben_ext_dfn.name%TYPE;
872: l_extract_shortname VARCHAR2(80);
873: l_extract_count NUMBER;
874:
875: l_request_id fnd_concurrent_requests.request_id%TYPE;

Line 2712: FROM BEN_EXT_DFN

2708: --115.87/115.88:Bug 7291713: Start
2709: CURSOR csr_get_bas_ext_dfn_id
2710: IS
2711: SELECT ext_dfn_id
2712: FROM BEN_EXT_DFN
2713: WHERE name = 'PQP GB PenServer Periodic Changes Interface - Basic Data'
2714: AND legislation_code ='GB';
2715:
2716: CURSOR csr_get_max_asg_end_date

Line 3211: from ben_ext_dfn

3207:
3208: CURSOR csr_dfn_code
3209: IS
3210: Select output_name
3211: from ben_ext_dfn
3212: where ext_dfn_id = ben_ext_thread.g_ext_dfn_id;
3213:
3214: l_extract_code csr_dfn_code%rowtype;
3215: l_file_name VARCHAR2(100);