APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on DUAL

Line 2888: FROM DUAL;

2884: ,-1,TO_CHAR(ADD_MONTHS(g_effective_run_date,-12),'YYYY')
2885: ,TO_CHAR(g_effective_run_date,'YYYY'))
2886: ,'DD-MM-YYYY')
2887: INTO g_pension_year_start_date
2888: FROM DUAL;
2889:
2890: -- Changed by Raju T. on 08/05/2002 as a development bugfix
2891: -- The last eff date and header sys element is now being created
2892: -- differently for Type 1 and being overwritten in the Type 4 Pkg

Line 7137: from dual;

7133: ,'Y'
7134: ,g_sf_rate_type
7135: ,g_sal_rate_type)
7136: into l_rate_name
7137: from dual;
7138:
7139: debug('l_rate_name :'||l_rate_name, 40);
7140:
7141: l_return := rates_history

Line 11887: /* Replacing this with assignment statements for individual elements as

11883:
11884: END IF; -- l_leaver = 'Y' AND l_leaver_date < g_effective_run_date THEN
11885:
11886:
11887: /* Replacing this with assignment statements for individual elements as
11888: there is a plan to extent the assignment cursor to include more cols.
11889:
11890: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id) := l_asg_details;
11891:

Line 14787: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;

14783:
14784: -- nocopy changes
14785: l_dtl_rec_nc := p_dtl_rec;
14786:
14787: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
14788:
14789: INSERT INTO ben_ext_rslt_dtl
14790: (EXT_RSLT_DTL_ID
14791: ,EXT_RSLT_ID