APPS.PA_RETENTION_UTIL dependencies on PA_DRAFT_INVOICE_ITEMS

Line 64: SELECT null FROM pa_draft_invoice_items dii

60: FROM pa_draft_invoices di
61: WHERE di.project_id = p_project_id
62: AND di.retention_invoice_flag = 'Y'
63: AND EXISTS(
64: SELECT null FROM pa_draft_invoice_items dii
65: WHERE dii.draft_invoice_num = di.draft_invoice_num
66: AND dii.project_id = di.project_id
67: AND dii.task_id = p_task_id);
68: IF g1_debug_mode = 'Y' THEN

Line 98: SELECT null FROM pa_draft_invoice_items dii

94: SELECT MIN(di.bill_through_date)
95: INTO last_bill_thru_date
96: FROM pa_draft_invoices di
97: WHERE EXISTS (
98: SELECT null FROM pa_draft_invoice_items dii
99: WHERE dii.draft_invoice_num = di.draft_invoice_num
100: AND dii.project_id = di.project_id
101: AND di.project_id = p_project_id
102: AND dii.invoice_line_type = 'RETENTION');

Line 114: SELECT null FROM pa_draft_invoice_items dii

110: SELECT MIN(di.bill_through_date)
111: INTO last_bill_thru_date
112: FROM pa_draft_invoices di
113: WHERE EXISTS (
114: SELECT null FROM pa_draft_invoice_items dii
115: WHERE dii.draft_invoice_num = di.draft_invoice_num
116: AND dii.project_id = di.project_id
117: AND dii.task_id = p_task_id
118: AND dii.invoice_line_type = 'RETENTION');