APPS.PAY_KW_PAYROLL_REGISTER dependencies on FND_LOBS

Line 1996: /* trying to use FND_LOBS_N1 index */

1992: IS
1993: BEGIN
1994: If p_report = 'MAIN' then
1995: /*Changing thequery for performance issue for bug 7632337 */
1996: /* trying to use FND_LOBS_N1 index */
1997: /*SELECT file_data
1998: INTO p_pdf_blob
1999: FROM fnd_lobs
2000: WHERE file_id = (SELECT MAX(file_id)

Line 1999: FROM fnd_lobs

1995: /*Changing thequery for performance issue for bug 7632337 */
1996: /* trying to use FND_LOBS_N1 index */
1997: /*SELECT file_data
1998: INTO p_pdf_blob
1999: FROM fnd_lobs
2000: WHERE file_id = (SELECT MAX(file_id)
2001: FROM fnd_lobs
2002: WHERE file_name like '%PAY_PRG_ar_KW.pdf'); */
2003: SELECT file_data

Line 2001: FROM fnd_lobs

1997: /*SELECT file_data
1998: INTO p_pdf_blob
1999: FROM fnd_lobs
2000: WHERE file_id = (SELECT MAX(file_id)
2001: FROM fnd_lobs
2002: WHERE file_name like '%PAY_PRG_ar_KW.pdf'); */
2003: SELECT file_data
2004: INTO p_pdf_blob
2005: FROM fnd_lobs

Line 2005: FROM fnd_lobs

2001: FROM fnd_lobs
2002: WHERE file_name like '%PAY_PRG_ar_KW.pdf'); */
2003: SELECT file_data
2004: INTO p_pdf_blob
2005: FROM fnd_lobs
2006: WHERE file_id =
2007: ( SELECT MAX(file_id)
2008: from FND_LOBS
2009: WHERE PROGRAM_NAME = 'PAY_PRG_ar_KW.pdf'

Line 2008: from FND_LOBS

2004: INTO p_pdf_blob
2005: FROM fnd_lobs
2006: WHERE file_id =
2007: ( SELECT MAX(file_id)
2008: from FND_LOBS
2009: WHERE PROGRAM_NAME = 'PAY_PRG_ar_KW.pdf'
2010: and program_tag= 'TMP:XDO:XDOTMPLATE1:SEED'
2011: and nvl(EXPIRATION_DATE ,trunc(sysdate)) = trunc(sysdate)
2012: );

Line 2016: FROM fnd_lobs

2012: );
2013: /* Else
2014: SELECT file_data
2015: INTO p_pdf_blob
2016: FROM fnd_lobs
2017: WHERE file_id = (SELECT MAX(file_id)
2018: FROM fnd_lobs
2019: WHERE file_name like '%PAY_PRG_SUMMARY_ar_KW.pdf');*/
2020: End If;

Line 2018: FROM fnd_lobs

2014: SELECT file_data
2015: INTO p_pdf_blob
2016: FROM fnd_lobs
2017: WHERE file_id = (SELECT MAX(file_id)
2018: FROM fnd_lobs
2019: WHERE file_name like '%PAY_PRG_SUMMARY_ar_KW.pdf');*/
2020: End If;
2021: EXCEPTION
2022: when no_data_found then