APPS.PA_REV_CA dependencies on PA_BILLING_EXTENSIONS

Line 6: -- pa_billing_extensions table

2: /*$Header: PAXICOSB.pls 120.1.12010000.2 2008/09/25 08:56:47 dlella ship $*/
3:
4: /*****************************************************************************
5: -- Global variables to store the attribute12 - 15 columns of
6: -- pa_billing_extensions table
7: ****************************************************************************/
8:
9: g_ca_event_type VARCHAR2(30);
10: g_ca_contra_event_type VARCHAR2(30);

Line 277: FROM pa_billing_extensions

273: INTO l_cost_budget_type_code,
274: l_rev_budget_type_code,
275: l_cost_plan_type_id,
276: l_rev_plan_type_id
277: FROM pa_billing_extensions
278: WHERE billing_extension_id=pa_billing.GetBillingExtensionId;
279:
280: END IF;
281:

Line 1123: FROM pa_billing_extensions

1119: -- cost accrual , cost accrual contra and cost WIP
1120:
1121: SELECT attribute12 , attribute13 , attribute14 , attribute15
1122: INTO g_ca_event_type ,g_ca_contra_event_type,g_ca_wip_event_type,g_ca_budget_type
1123: FROM pa_billing_extensions
1124: WHERE billing_extension_id = X_billing_extension_id;
1125:
1126: IF g1_debug_mode = 'Y' THEN
1127: PA_MCB_INVOICE_PKG.log_message('Before pa_billing_extn_params_v select pa_rev_ca.calc_ca_amt :');

Line 1820: from pa_billing_extensions be,

1816: l_ca_event_type,
1817: l_ca_contra_event_type,
1818: l_ca_wip_event_type,
1819: l_ca_budget_type
1820: from pa_billing_extensions be,
1821: pa_billing_assignments_all bea,
1822: pa_projects_all p
1823: where p.project_id = p_project_id
1824: and bea.active_flag = 'Y'

Line 1856: from pa_billing_extensions be,

1852: l_ca_event_type,
1853: l_ca_contra_event_type,
1854: l_ca_wip_event_type,
1855: l_ca_budget_type
1856: from pa_billing_extensions be,
1857: pa_billing_assignments_all bea
1858: where bea.active_flag = 'Y'
1859: and bea.billing_extension_id = be.billing_extension_id
1860: and be.attribute11 = 'COST-ACCRUAL'