APPS.PA_XLA_INTERFACE_PKG dependencies on PA_PROJECTS_ALL

Line 67: g_project_org_id pa_projects_all.org_id%type; -- Project operating unit.

63: g_data_set_id Number; -- Cincurrent request id, budget version id etc.
64: g_imp_cr_ccid Number; -- Default supplier cost credit account
65:
66: g_entity_code Varchar2(30);
67: g_project_org_id pa_projects_all.org_id%type; -- Project operating unit.
68:
69: -- static global pl/sql tables for holding event type info
70: g_tab_module TEventInfo10;
71: g_tab_event_type_code TEventInfo35;

Line 1827: l_project_number pa_projects_all.segment1%type;

1823: -- Following variables used to build transaction number for budget
1824: -- Transaction number: 'project number' - 'budget type' - 'budget version number'
1825:
1826: l_budget_type pa_budget_types.budget_type%type;
1827: l_project_number pa_projects_all.segment1%type;
1828: l_budget_version_number pa_budget_versions.version_number%type;
1829: l_rev_budget_version_number pa_budget_versions.version_number%type;
1830:
1831: Begin

Line 1889: from pa_projects_all pp,

1885: select pp.org_id,pp.segment1,
1886: pbv.version_number,pbt.budget_type
1887: into g_project_org_id,l_project_number,
1888: l_budget_version_number,l_budget_type
1889: from pa_projects_all pp,
1890: pa_budget_versions pbv,
1891: pa_budget_types pbt
1892: where pbv.budget_version_id = g_data_set_id
1893: and pp.project_id = pbv.project_id