APPS.PA_RETN_BILLING_PKG dependencies on PA_PROJECTS

Line 20: pa_projects_all pr

16: NVL(fmtdet.right_justify_flag,'N') right_justify_flag
17: FROM pa_invoice_group_columns grp,
18: pa_invoice_formats fmt,
19: pa_invoice_format_details fmtdet,
20: pa_projects_all pr
21: WHERE pr.retn_billing_inv_format_id = fmt.invoice_format_id
22: AND fmt.invoice_format_id = fmtdet.invoice_format_id
23: AND grp.invoice_group_column_id = fmtdet.invoice_group_column_id
24: and pr.project_id =p_project_id

Line 264: pa_projects pr,

260: ar_customer_profiles cp,
261: ra_site_uses ras,
262: pa_project_customers c,
263: pa_agreements_all a,
264: pa_projects pr,
265: ra_site_uses ras1,
266: ra_addresses addr
267: */
268: from hz_customer_profiles hz_cp1,

Line 275: pa_projects pr,

271: hz_customer_profiles hz_cp,
272: hz_cust_site_uses hz_site,
273: pa_project_customers c,
274: pa_agreements_all a,
275: pa_projects pr,
276: hz_cust_site_uses hz_site1,
277: hz_cust_acct_sites addr
278: where a.agreement_id = p_agreement_id
279: and pr.project_id = p_project_id

Line 1283: FROM pa_project_customers pc, pa_projects_all pr, ra_customers c

1279: pc.customer_id customer_id,
1280: pc.retention_level_code retention_level,
1281: NVL(pr.RETN_BILLING_INV_FORMAT_ID,0) RETN_BILLING_INV_FORMAT_ID
1282: /* TCA changes
1283: FROM pa_project_customers pc, pa_projects_all pr, ra_customers c
1284: */
1285: FROM pa_project_customers pc, pa_projects_all pr, hz_parties hz_p, hz_cust_accounts hz_c
1286: WHERE EXISTS(
1287: SELECT NULL FROM pa_summary_project_retn spr,

Line 1285: FROM pa_project_customers pc, pa_projects_all pr, hz_parties hz_p, hz_cust_accounts hz_c

1281: NVL(pr.RETN_BILLING_INV_FORMAT_ID,0) RETN_BILLING_INV_FORMAT_ID
1282: /* TCA changes
1283: FROM pa_project_customers pc, pa_projects_all pr, ra_customers c
1284: */
1285: FROM pa_project_customers pc, pa_projects_all pr, hz_parties hz_p, hz_cust_accounts hz_c
1286: WHERE EXISTS(
1287: SELECT NULL FROM pa_summary_project_retn spr,
1288: pa_proj_retn_bill_rules rt
1289: WHERE rt.project_id = spr.project_id

Line 1405: pa_projects_all pr

1401: (NVL(spr.total_retained,0)- NVL(spr.total_billed,0)) Remain_Retained_Amt,
1402: pr.inv_by_bill_trans_curr_flag inv_by_bill_trans_curr_flag
1403: FROM pa_summary_project_retn spr,
1404: pa_agreements_all agr,
1405: pa_projects_all pr
1406: WHERE agr.agreement_id = spr.agreement_id
1407: AND agr.customer_id = TmpCustomerID
1408: AND spr.project_id = TmpProjectId
1409: AND spr.project_id = pr.project_id

Line 2009: FROM pa_projects pr, pa_project_types t

2005: p_start_proj_number IN VARCHAR2,
2006: p_end_proj_number IN VARCHAR2) IS
2007: CURSOR cur_select_projects IS
2008: SELECT pr.project_id project_id
2009: FROM pa_projects pr, pa_project_types t
2010: WHERE NOT EXISTS (SELECT null
2011: FROM pa_draft_invoices_all di
2012: WHERE di.request_id = p_request_id
2013: AND di.project_id = pr.project_id