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_CUSTOMER_INFO dependencies on PA_PROJECT_CONTACTS

Line 790: FROM Pa_Project_Contacts

786: SELECT 'Y'
787: INTO l_bill_to_contact_exists
788: FROM dual
789: WHERE EXISTS (SELECT 'Y'
790: FROM Pa_Project_Contacts
791: WHERE Project_Id = X_Project_Id
792: AND Customer_Id = X_Customer_Id
793: AND Contact_Id = X_Bill_To_Contact_Id
794: AND PROJECT_CONTACT_TYPE_CODE = l_billing

Line 805: FROM Pa_Project_Contacts

801: SELECT 'Y'
802: INTO l_ship_to_contact_exists
803: FROM dual
804: WHERE EXISTS (SELECT 'Y'
805: FROM Pa_Project_Contacts
806: WHERE Project_Id = X_Project_Id
807: AND Customer_Id = X_Customer_Id
808: AND Contact_Id = X_Ship_To_Contact_Id
809: AND PROJECT_CONTACT_TYPE_CODE = l_shipping

Line 820: Insert Into Pa_Project_Contacts

816:
817:
818: If X_Bill_To_Contact_Id is not null then
819: If l_bill_to_contact_exists = 'N' then /* for bug 5554475 */
820: Insert Into Pa_Project_Contacts
821: ( Project_Id,
822: Customer_Id,
823: bill_ship_customer_id, /* For Bug 2731449 */
824: Contact_Id,

Line 850: Insert Into Pa_Project_Contacts

846: END if;
847:
848: If X_Ship_To_Contact_Id is not null then
849: If l_ship_to_contact_exists = 'N' then /* for bug 5554475 */
850: Insert Into Pa_Project_Contacts
851: ( Project_Id,
852: Customer_Id,
853: bill_ship_customer_id, /* For Bug 2731449 */
854: Contact_Id,