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_CUSTOMERS_CONTACTS_PUB dependencies on PA_PROJECT_CUSTOMERS

Line 839: -- Changed reference from pa_project_customers_v (view) to pa_project_customers (base table)

835: SELECT project_currency_code
836: FROM pa_projects_all
837: WHERE project_id = c_project_id;
838:
839: -- Changed reference from pa_project_customers_v (view) to pa_project_customers (base table)
840: -- for Performance Bug 4878827 SQL ID 14907728
841: CURSOR C5 IS
842: SELECT bill_to_customer_id, ship_to_customer_id
843: FROM pa_project_customers

Line 843: FROM pa_project_customers

839: -- Changed reference from pa_project_customers_v (view) to pa_project_customers (base table)
840: -- for Performance Bug 4878827 SQL ID 14907728
841: CURSOR C5 IS
842: SELECT bill_to_customer_id, ship_to_customer_id
843: FROM pa_project_customers
844: WHERE project_id = p_project_id
845: AND customer_id = p_customer_id
846: AND record_version_number = p_record_version_number;
847:

Line 1772: select bill_to_address_id into l_address_id from pa_project_customers where project_id = p_project_id and customer_id=p_customer_id;

1768: if p_calling_module <> 'FORM' then
1769: -- Added the following of condition for Bug 2964227
1770: IF l_project_contact_type_code = 'BILLING' THEN
1771: begin
1772: select bill_to_address_id into l_address_id from pa_project_customers where project_id = p_project_id and customer_id=p_customer_id;
1773: exception when others then
1774: l_address_id := null;
1775: end;
1776: ELSIF l_project_contact_type_code = 'SHIPPING' THEN

Line 1778: select ship_to_address_id into l_address_id from pa_project_customers where project_id = p_project_id and customer_id=p_customer_id;

1774: l_address_id := null;
1775: end;
1776: ELSIF l_project_contact_type_code = 'SHIPPING' THEN
1777: begin
1778: select ship_to_address_id into l_address_id from pa_project_customers where project_id = p_project_id and customer_id=p_customer_id;
1779: exception when others then
1780: l_address_id := null;
1781: end;
1782: END IF;

Line 2138: select bill_to_address_id into l_address_id from pa_project_customers where project_id = p_project_id and customer_id=p_customer_id;

2134: if p_calling_module <> 'FORM' then
2135: -- Added the following of condition for Bug 2964227
2136: IF l_project_contact_type_code = 'BILLING' THEN
2137: begin
2138: select bill_to_address_id into l_address_id from pa_project_customers where project_id = p_project_id and customer_id=p_customer_id;
2139: exception when others then
2140: l_address_id := null;
2141: end;
2142: ELSIF l_project_contact_type_code = 'SHIPPING' THEN

Line 2144: select ship_to_address_id into l_address_id from pa_project_customers where project_id = p_project_id and customer_id=p_customer_id;

2140: l_address_id := null;
2141: end;
2142: ELSIF l_project_contact_type_code = 'SHIPPING' THEN
2143: begin
2144: select ship_to_address_id into l_address_id from pa_project_customers where project_id = p_project_id and customer_id=p_customer_id;
2145: exception when others then
2146: l_address_id := null;
2147: end;
2148: END IF;