APPS.PO_APPROVAL_REMINDER_SV dependencies on PO_LINES_ALL

Line 3253: FROM po_lines_all POL2,

3249: POL2.expiration_date,
3250: POL2.contractor_first_name,
3251: POL2.contractor_last_name,
3252: PJ.name job_name
3253: FROM po_lines_all POL2,
3254: per_jobs_vl PJ,
3255: ( SELECT PLL.po_line_id
3256: , SUM(PLL.amount_billed) total_amount_billed
3257: FROM po_line_locations PLL

Line 3258: , po_lines_all POL

3254: per_jobs_vl PJ,
3255: ( SELECT PLL.po_line_id
3256: , SUM(PLL.amount_billed) total_amount_billed
3257: FROM po_line_locations PLL
3258: , po_lines_all POL
3259: , po_headers_all poh
3260: WHERE poh.type_lookup_code = 'STANDARD'
3261: AND poh.po_header_id = POL.po_header_id
3262: AND POL.purchase_basis = 'TEMP LABOR'

Line 3364: UPDATE po_lines_all

3360: p_expiration_date => l_tl_line_rec.expiration_date
3361: );
3362:
3363: -- SQL What: Set the "Amount Billed notification sent" flag to Y.
3364: UPDATE po_lines_all
3365: SET svc_amount_notif_sent = 'Y',
3366: last_update_date = sysdate,
3367: last_updated_by = fnd_global.user_id
3368: WHERE po_line_id = l_tl_line_rec.po_line_id;

Line 3388: UPDATE po_lines_all

3384: p_expiration_date => l_tl_line_rec.expiration_date
3385: );
3386:
3387: -- SQL What: Set the "Assignment Completion notification sent" flag to Y.
3388: UPDATE po_lines_all
3389: SET svc_completion_notif_sent = 'Y',
3390: last_update_date = sysdate,
3391: last_updated_by = fnd_global.user_id
3392: WHERE po_line_id = l_tl_line_rec.po_line_id;