DBA Data[Home] [Help]

APPS.PA_PLAN_REVENUE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 61: from per_org_structure_elements

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