APPS.PO_WAGE_DETERMINATION_ONLINE dependencies on FND_DOCUMENTS_TL

Line 69: FROM fnd_attached_documents attach, fnd_documents_tl doc

65: attach.PROGRAM_UPDATE_DATE,
66: attach.REQUEST_ID,
67: attach.CATEGORY_ID,
68: ORIG_ATTACH_DOC_ID
69: FROM fnd_attached_documents attach, fnd_documents_tl doc
70: WHERE pk1_value = l_attachment_pk1
71: AND attach.document_id = doc.document_id
72: AND doc.title = p_input_url
73: AND doc.LANGUAGE = 'US'

Line 315: FROM fnd_attached_documents attach, fnd_documents_tl doc

311: attach.PROGRAM_UPDATE_DATE,
312: attach.REQUEST_ID,
313: attach.CATEGORY_ID,
314: ORIG_ATTACH_DOC_ID
315: FROM fnd_attached_documents attach, fnd_documents_tl doc
316: WHERE pk1_value = l_attachment_pk1
317: AND attach.document_id = doc.document_id
318: AND doc.title = l_input_url
319: AND doc.LANGUAGE = 'US'

Line 437: UPDATE fnd_documents_tl

433: COMMIT;
434:
435:
436: FOR c2 IN c_last_attachment LOOP
437: UPDATE fnd_documents_tl
438: SET title = 'Wage Determination Statement',
439: description = 'WD Statement URL'
440: WHERE document_id = c2.DOCUMENT_ID;
441:

Line 554: FROM fnd_attached_documents attach, fnd_documents_tl doc

550: l_enable_wdol VARCHAR2(1);
551:
552: CURSOR c_wdol_attachment_exists IS
553: SELECT 'Y'
554: FROM fnd_attached_documents attach, fnd_documents_tl doc
555: WHERE pk1_value = To_Char(p_auction_header_id)
556: AND attach.document_id = doc.document_id
557: AND doc.title = 'Wage Determination Statement'
558: AND doc.description = 'WD Statement URL'