APPS.PA_CUSTOMERS_CONTACTS_UTILS dependencies on PA_LOOKUPS

Line 614: FROM pa_lookups

610:
611:
612: CURSOR c_ids IS
613: SELECT lookup_code
614: FROM pa_lookups
615: WHERE upper(meaning) = upper(p_project_contact_type_name) AND
616: lookup_type = 'PROJECT CONTACT TYPE' AND
617: trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate));
618:

Line 625: FROM pa_lookups

621: (p_project_contact_type_code is NULL) then
622: if (p_project_contact_type_name is not NULL) then
623: SELECT lookup_code
624: INTO x_project_contact_type_code
625: FROM pa_lookups
626: WHERE upper(meaning) = upper(p_project_contact_type_name) AND
627: lookup_type = 'PROJECT CONTACT TYPE' AND
628: trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate));
629: else

Line 637: FROM pa_lookups

633: else
634: if p_check_id_flag = 'Y' then
635: SELECT lookup_code
636: INTO x_project_contact_type_code
637: FROM pa_lookups
638: WHERE lookup_code = p_project_contact_type_code AND
639: lookup_type = 'PROJECT CONTACT TYPE' AND
640: trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate));
641: