APPS.PJI_UTILS dependencies on DUAL

Line 1810: FROM dual;

1806: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),
1807: FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')
1808: INTO l_pji_report_msg,l_pji_head1,l_pji_head2,l_pji_head3,l_pji_head4,l_pji_head5,
1809: l_pji_foot1,l_pji_foot2,l_pji_foot3,l_pji_foot4,l_p_curr_rep_not
1810: FROM dual;
1811:
1812: select
1813: RPAD(l_separator,Length(l_separator)+Length(l_pji_report_msg),'*'),
1814: RPAD(l_pji_line2,length(l_pji_head2),'-'),

Line 1820: from dual;

1816: RPAD(l_pji_line4,length(l_pji_head4),'-'),
1817: RPAD(l_pji_line5,length(l_pji_head5),'-')
1818: into
1819: l_separator,l_pji_line2,l_pji_line3,l_pji_line4,l_pji_line5
1820: from dual;
1821:
1822: -- Audit Report printing starts
1823: l_pji_report_msg := ' '||l_pji_report_msg;
1824:

Line 2133: from dual

2129: if (PJI_UTILS.GET_PARAMETER('PJI_PTC_UPGRADE') = 'P') then
2130:
2131: select 'Y'
2132: into l_return
2133: from dual
2134: where exists (SELECT 1
2135: FROM pa_proj_element_versions pa
2136: ,pa_proj_element_versions pap
2137: ,pa_pji_proj_events_log log

Line 2167: select PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') into l_status from dual;

2163: IS
2164: l_status VARCHAR2(1);
2165: l_count NUMBER(10);
2166: begin
2167: select PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') into l_status from dual;
2168: IF l_status = 'P' THEN
2169: select count(1) into l_count from PJI_SYSTEM_CONFIG_HIST
2170: where PROCESS_NAME = 'STAGE3'
2171: and END_DATE is null and RUN_TYPE = 'CLEANALL';