DBA Data[Home] [Help]

APPS.PA_PWP_SUMM_PKG dependencies on PA_IMPLEMENTATIONS

Line 22: FROM pa_implementations;

18: FROM PA_PWP_CUSTOMER_SUMM WHERE project_id = P_Project_Id ;
19:
20: SELECT org_id
21: INTO l_org_id
22: FROM pa_implementations;
23:
24:
25: --Insert the Invoice level attributes to the temp Table
26: INSERT

Line 169: , pa_implementations pa

165: , end_date
166: INTO l_start_date
167: ,l_end_date
168: FROM gl_period_statuses GL1
169: , pa_implementations pa
170: WHERE GL1.set_of_books_id = pa.set_of_books_id
171: AND GL1.APPLICATION_ID = 101 --bug 8208525
172: AND GL1.CLOSING_STATUS = 'O'
173: AND start_date =