APPS.PO_APPROVAL_REMINDER_SV dependencies on PO_LINES_ALL

Line 3219: FROM po_lines_all POL2,

3215: POL2.expiration_date,
3216: POL2.contractor_first_name,
3217: POL2.contractor_last_name,
3218: PJ.name job_name
3219: FROM po_lines_all POL2,
3220: per_jobs_vl PJ,
3221: ( SELECT PLL.po_line_id
3222: , SUM(PLL.amount_billed) total_amount_billed
3223: FROM po_line_locations PLL

Line 3224: , po_lines_all POL

3220: per_jobs_vl PJ,
3221: ( SELECT PLL.po_line_id
3222: , SUM(PLL.amount_billed) total_amount_billed
3223: FROM po_line_locations PLL
3224: , po_lines_all POL
3225: , po_headers_all poh
3226: WHERE poh.type_lookup_code = 'STANDARD'
3227: AND poh.po_header_id = POL.po_header_id
3228: AND POL.purchase_basis = 'TEMP LABOR'

Line 3330: UPDATE po_lines_all

3326: p_expiration_date => l_tl_line_rec.expiration_date
3327: );
3328:
3329: -- SQL What: Set the "Amount Billed notification sent" flag to Y.
3330: UPDATE po_lines_all
3331: SET svc_amount_notif_sent = 'Y',
3332: last_update_date = sysdate,
3333: last_updated_by = fnd_global.user_id
3334: WHERE po_line_id = l_tl_line_rec.po_line_id;

Line 3354: UPDATE po_lines_all

3350: p_expiration_date => l_tl_line_rec.expiration_date
3351: );
3352:
3353: -- SQL What: Set the "Assignment Completion notification sent" flag to Y.
3354: UPDATE po_lines_all
3355: SET svc_completion_notif_sent = 'Y',
3356: last_update_date = sysdate,
3357: last_updated_by = fnd_global.user_id
3358: WHERE po_line_id = l_tl_line_rec.po_line_id;