692: WHERE EXISTS
693: (
694: -- revnue generated but unbilled transactions exist for the AP Invoice
695: SELECT 1
696: FROM pa_projects_all proj,
697: pa_tasks task,
698: pa_tasks toptask,
699: pa_expenditure_items ei,
700: pa_cust_rev_dist_lines crdl
721: -- Pending revenue generation
722: SELECT 1
723: FROM
724: pa_expenditure_items ei ,
725: pa_projects_all proj,
726: pa_tasks task,
727: pa_tasks toptask
728: WHERE
729: ei.DOCUMENT_HEADER_ID = p_invoice_id
868: -- Function : is_eligible
869: -- Type :Private
870: -- Purpose : To find if all AUTO_RELEASE_PWP_INV is yes for all
871: -- related projects.
872: -- Note : Checks if PA_PROJECTS_ALL.AUTO_RELEASE_PWP_INV is Y/N.
873: -- Assumptions :
874: -- Parameter :
875: -- Parameters Type Required Description and Purpose
876: -- --------------------------- ------ -------- --------------------------------------------------------