APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on DUAL

Line 2916: FROM DUAL;

2912: ,-1,TO_CHAR(ADD_MONTHS(g_effective_run_date,-12),'YYYY')
2913: ,TO_CHAR(g_effective_run_date,'YYYY'))
2914: ,'DD-MM-YYYY')
2915: INTO g_pension_year_start_date
2916: FROM DUAL;
2917:
2918: -- Changed by Raju T. on 08/05/2002 as a development bugfix
2919: -- The last eff date and header sys element is now being created
2920: -- differently for Type 1 and being overwritten in the Type 4 Pkg

Line 7165: from dual;

7161: ,'Y'
7162: ,g_sf_rate_type
7163: ,g_sal_rate_type)
7164: into l_rate_name
7165: from dual;
7166:
7167: debug('l_rate_name :'||l_rate_name, 40);
7168:
7169: l_return := rates_history

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

12081:
12082: END IF; -- l_leaver = 'Y' AND l_leaver_date < g_effective_run_date THEN
12083:
12084:
12085: /* Replacing this with assignment statements for individual elements as
12086: there is a plan to extent the assignment cursor to include more cols.
12087:
12088: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id) := l_asg_details;
12089:

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

14982:
14983: -- nocopy changes
14984: l_dtl_rec_nc := p_dtl_rec;
14985:
14986: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
14987:
14988: INSERT INTO ben_ext_rslt_dtl
14989: (EXT_RSLT_DTL_ID
14990: ,EXT_RSLT_ID