APPS.PJI_UTILS dependencies on DUAL

Line 1646: FROM dual;

1642: FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),
1643: FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')
1644: INTO l_pji_report_msg,l_pji_head1,l_pji_head2,l_pji_head3,l_pji_head4,l_pji_head5,
1645: l_pji_foot1,l_pji_foot2,l_pji_foot3,l_pji_foot4,l_p_curr_rep_not
1646: FROM dual;
1647:
1648: select
1649: RPAD(l_separator,Length(l_separator)+Length(l_pji_report_msg),'*'),
1650: RPAD(l_pji_line2,length(l_pji_head2),'-'),

Line 1656: from dual;

1652: RPAD(l_pji_line4,length(l_pji_head4),'-'),
1653: RPAD(l_pji_line5,length(l_pji_head5),'-')
1654: into
1655: l_separator,l_pji_line2,l_pji_line3,l_pji_line4,l_pji_line5
1656: from dual;
1657:
1658: -- Audit Report printing starts
1659: l_pji_report_msg := ' '||l_pji_report_msg;
1660:

Line 1964: from dual

1960: if (PJI_UTILS.GET_PARAMETER('PJI_PTC_UPGRADE') = 'P') then
1961:
1962: select 'Y'
1963: into l_return
1964: from dual
1965: where exists (SELECT 1
1966: FROM pa_proj_element_versions pa
1967: ,pa_proj_element_versions pap
1968: ,pa_pji_proj_events_log log

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

1994: IS
1995: l_status VARCHAR2(1);
1996: l_count NUMBER(10);
1997: begin
1998: select PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') into l_status from dual;
1999: IF l_status = 'P' THEN
2000: select count(1) into l_count from PJI_SYSTEM_CONFIG_HIST
2001: where PROCESS_NAME = 'STAGE3'
2002: and END_DATE is null and RUN_TYPE = 'CLEANALL';