APPS.PA_PROJECTS_MAINT_PUB dependencies on PA_PROJECT_OPP_ATTRS

Line 1615: l_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;

1611: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
1612: l_project_type pa_projects_all.project_type%TYPE;
1613: l_expected_approval_date DATE;
1614: l_opportunity_value NUMBER;
1615: l_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;
1616:
1617: CURSOR c1
1618: IS
1619: Select pr.project_type, pr.probability_member_id, pr.expected_approval_date,

Line 1621: From pa_projects_all pr, pa_project_opp_attrs op

1617: CURSOR c1
1618: IS
1619: Select pr.project_type, pr.probability_member_id, pr.expected_approval_date,
1620: op.opportunity_value, op.opp_value_currency_code
1621: From pa_projects_all pr, pa_project_opp_attrs op
1622: Where pr.project_id = op.project_id
1623: AND pr.project_id = p_project_id;
1624:
1625: v_c1 c1%ROWTYPE;