APPS.PA_RETN_BILLING_PKG dependencies on PA_PROJECTS_ALL

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