DBA Data[Home] [Help]

APPS.PA_PWP_INVOICE_REL dependencies on PA_PROJECTS_ALL

Line 696: FROM pa_projects_all proj,

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

Line 725: pa_projects_all proj,

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

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

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: -- --------------------------- ------ -------- --------------------------------------------------------