eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_REQUEST_PVT dependencies on PA_PROBABILITY_MEMBERS

Line 1661: pa_probability_members m ,

1657: p.org_id -- Added for Bug#3798344
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

Line 1702: l_probability pa_probability_members.probability_percentage%TYPE;

1698: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1699:
1700: -- Old pipeline project info.
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;

Line 1703: l_probability_list_id pa_probability_members.probability_list_id%TYPE;

1699:
1700: -- Old pipeline project info.
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;

Line 1704: l_probability_member_id pa_probability_members.probability_member_id%TYPE;

1700: -- Old pipeline project info.
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:

Line 1710: l_new_probability pa_probability_members.probability_percentage%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;
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;

Line 1711: l_new_probability_member_id pa_probability_members.probability_member_id%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;
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: