DBA Data[Home] [Help]

APPS.PA_PROJECT_REQUEST_PVT dependencies on PA_PROJECT_OPP_ATTRS

Line 1662: pa_project_opp_attrs a

1658: FROM
1659: pa_projects_all p,
1660: pa_project_statuses s ,
1661: pa_probability_members m ,
1662: pa_project_opp_attrs a
1663: WHERE p.project_status_code = s.project_status_code
1664: AND p.probability_member_id = m.probability_member_id(+)
1665: AND a.project_id = p.project_id
1666: AND p.project_id = p_project_id;

Line 1705: l_opportunity_value pa_project_opp_attrs.opportunity_value%TYPE;

1701: l_project_value pa_projects_all.project_value%TYPE;
1702: l_probability pa_probability_members.probability_percentage%TYPE;
1703: l_probability_list_id pa_probability_members.probability_list_id%TYPE;
1704: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
1705: l_opportunity_value pa_project_opp_attrs.opportunity_value%TYPE;
1706: l_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;
1707: l_expected_approval_date pa_projects_all.expected_approval_date%TYPE;
1708:
1709: -- New pipeline project info.

Line 1706: l_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;

1702: l_probability pa_probability_members.probability_percentage%TYPE;
1703: l_probability_list_id pa_probability_members.probability_list_id%TYPE;
1704: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
1705: l_opportunity_value pa_project_opp_attrs.opportunity_value%TYPE;
1706: l_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;
1707: l_expected_approval_date pa_projects_all.expected_approval_date%TYPE;
1708:
1709: -- New pipeline project info.
1710: l_new_probability pa_probability_members.probability_percentage%TYPE;

Line 1712: l_new_opportunity_value pa_project_opp_attrs.opportunity_value%TYPE;

1708:
1709: -- New pipeline project info.
1710: l_new_probability pa_probability_members.probability_percentage%TYPE;
1711: l_new_probability_member_id pa_probability_members.probability_member_id%TYPE;
1712: l_new_opportunity_value pa_project_opp_attrs.opportunity_value%TYPE;
1713: l_new_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;
1714: l_new_expected_approval_date pa_projects_all.expected_approval_date%TYPE;
1715:
1716: l_recipient_tab pa_plsql_datatypes.Char240TabTyp;

Line 1713: l_new_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;

1709: -- New pipeline project info.
1710: l_new_probability pa_probability_members.probability_percentage%TYPE;
1711: l_new_probability_member_id pa_probability_members.probability_member_id%TYPE;
1712: l_new_opportunity_value pa_project_opp_attrs.opportunity_value%TYPE;
1713: l_new_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;
1714: l_new_expected_approval_date pa_projects_all.expected_approval_date%TYPE;
1715:
1716: l_recipient_tab pa_plsql_datatypes.Char240TabTyp;
1717: l_project_id_tab PA_PLSQL_DATATYPES.IdTabTyp;