DBA Data[Home] [Help]

APPS.PA_PLAN_REVENUE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 62: from per_org_structure_elements

58: cursor c_parent_rule (p_proj_org_version_id IN NUMBER) is
59: SELECT b.rate,b.markup_percentage,b.bill_rate_unit,b.rate_currency_code
60: From pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b,
61: ( select organization_id_parent PARENT_ORGANIZATION_ID,level parent_level
62: from per_org_structure_elements
63: where org_structure_version_id = p_proj_org_version_id
64: connect by prior organization_id_parent=organization_id_child
65: and prior org_structure_version_id = org_structure_version_id
66: start with organization_id_child=p_res_class_org_id