DBA Data[Home] [Help]

APPS.PA_PWP_INVOICE_REL dependencies on PA_PROJECTS_ALL

Line 693: FROM pa_projects_all proj,

689: WHERE EXISTS
690: (
691: -- revnue generated but unbilled transactions exist for the AP Invoice
692: SELECT 1
693: FROM pa_projects_all proj,
694: pa_tasks task,
695: pa_tasks toptask,
696: pa_expenditure_items ei,
697: pa_cust_rev_dist_lines crdl

Line 722: pa_projects_all proj,

718: -- Pending revenue generation
719: SELECT 1
720: FROM
721: pa_expenditure_items ei ,
722: pa_projects_all proj,
723: pa_tasks task,
724: pa_tasks toptask
725: WHERE
726: ei.DOCUMENT_HEADER_ID = p_invoice_id

Line 864: -- Note : Checks if PA_PROJECTS_ALL.AUTO_RELEASE_PWP_INV is Y/N.

860: -- Function : is_eligible
861: -- Type :Private
862: -- Purpose : To find if all AUTO_RELEASE_PWP_INV is yes for all
863: -- related projects.
864: -- Note : Checks if PA_PROJECTS_ALL.AUTO_RELEASE_PWP_INV is Y/N.
865: -- Assumptions :
866: -- Parameter :
867: -- Parameters Type Required Description and Purpose
868: -- --------------------------- ------ -------- --------------------------------------------------------