APPS.PA_CUSTOMER_INFO dependencies on PA_PROJECT_CONTACTS

Line 781: FROM Pa_Project_Contacts

777: SELECT 'Y'
778: INTO l_bill_to_contact_exists
779: FROM dual
780: WHERE EXISTS (SELECT 'Y'
781: FROM Pa_Project_Contacts
782: WHERE Project_Id = X_Project_Id
783: AND Customer_Id = X_Customer_Id
784: AND Contact_Id = X_Bill_To_Contact_Id
785: AND PROJECT_CONTACT_TYPE_CODE = l_billing

Line 796: FROM Pa_Project_Contacts

792: SELECT 'Y'
793: INTO l_ship_to_contact_exists
794: FROM dual
795: WHERE EXISTS (SELECT 'Y'
796: FROM Pa_Project_Contacts
797: WHERE Project_Id = X_Project_Id
798: AND Customer_Id = X_Customer_Id
799: AND Contact_Id = X_Ship_To_Contact_Id
800: AND PROJECT_CONTACT_TYPE_CODE = l_shipping

Line 811: Insert Into Pa_Project_Contacts

807:
808:
809: If X_Bill_To_Contact_Id is not null then
810: If l_bill_to_contact_exists = 'N' then /* for bug 5554475 */
811: Insert Into Pa_Project_Contacts
812: ( Project_Id,
813: Customer_Id,
814: bill_ship_customer_id, /* For Bug 2731449 */
815: Contact_Id,

Line 841: Insert Into Pa_Project_Contacts

837: END if;
838:
839: If X_Ship_To_Contact_Id is not null then
840: If l_ship_to_contact_exists = 'N' then /* for bug 5554475 */
841: Insert Into Pa_Project_Contacts
842: ( Project_Id,
843: Customer_Id,
844: bill_ship_customer_id, /* For Bug 2731449 */
845: Contact_Id,