APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_ORG_HIERARCHY_DENORM

Line 404: FROM pa_org_hierarchy_denorm

400: -- organization in the organization hierarchy
401: CURSOR get_all_child_orgs_in_hier IS
402: -- SELECT child_organization_id, pa_expenditures_utils.GetOrgTlName(child_organization_id) -- Commented for Bug 4866284
403: SELECT child_organization_id, pa_resource_utils.get_organization_name(child_organization_id) -- Added for Bug 4866284
404: FROM pa_org_hierarchy_denorm
405: WHERE org_hierarchy_version_id = p_org_hierarchy_version_id
406: AND parent_organization_id = p_starting_organization_id
407: AND pa_org_use_type = 'EXPENDITURES';
408:

Line 550: FROM pa_org_hierarchy_denorm ohd

546: -- organization in the organization hierarchy that have not been published to
547: CURSOR get_child_orgs_in_hier(c_org_hierarchy_version_id NUMBER, c_start_org_id NUMBER) IS
548: -- SELECT ohd.child_organization_id, pa_expenditures_utils.GetOrgTlName(ohd.child_organization_id) -- Commented for Bug 4866284
549: SELECT ohd.child_organization_id, pa_resource_utils.get_organization_name(ohd.child_organization_id) -- Added for Bug 4866284
550: FROM pa_org_hierarchy_denorm ohd
551: WHERE ohd.org_hierarchy_version_id = c_org_hierarchy_version_id
552: AND ohd.parent_organization_id = c_start_org_id
553: AND ohd.pa_org_use_type = 'EXPENDITURES'
554: MINUS

Line 557: FROM pa_org_hierarchy_denorm ohd,

553: AND ohd.pa_org_use_type = 'EXPENDITURES'
554: MINUS
555: -- SELECT ohd.child_organization_id, pa_expenditures_utils.GetOrgTlName(ohd.child_organization_id) -- Commented for Bug 4866284
556: SELECT ohd.child_organization_id, pa_resource_utils.get_organization_name(ohd.child_organization_id) -- Added for Bug 4866284
557: FROM pa_org_hierarchy_denorm ohd,
558: pa_action_set_line_aud asla
559: WHERE ohd.org_hierarchy_version_id = c_org_hierarchy_version_id
560: AND ohd.parent_organization_id = c_start_org_id
561: AND ohd.pa_org_use_type = 'EXPENDITURES'