APPS.PA_RETENTION_UTIL dependencies on PA_DRAFT_INVOICES

Line 49: FROM pa_draft_invoices

45: IF NVL(p_task_id,0) = 0 THEN
46:
47: SELECT MAX(bill_through_date)
48: INTO last_bill_thru_date
49: FROM pa_draft_invoices
50: WHERE project_id = p_project_id
51: AND retention_invoice_flag = 'Y';
52:
53: IF g1_debug_mode = 'Y' THEN

Line 60: FROM pa_draft_invoices di

56: END IF;
57: ELSE
58: SELECT MAX(di.bill_through_date)
59: INTO last_bill_thru_date
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

Line 96: FROM pa_draft_invoices di

92: IF NVL(p_task_id,0) = 0 THEN
93:
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

Line 112: FROM pa_draft_invoices di

108:
109: ELSE
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