APPS.PQP_NL_PENSION_EXTRACTS dependencies on PER_CONTACT_RELATIONSHIPS

Line 6587: FROM per_contact_relationships

6583: SELECT last_name
6584: FROM per_all_people_f
6585: WHERE person_id IN
6586: ( SELECT contact_person_id
6587: FROM per_contact_relationships
6588: WHERE person_id = c_person_id
6589: AND business_group_id = p_business_group_id
6590: AND contact_type IN ('S','D')
6591: AND c_date_earned

Line 6689: FROM per_contact_relationships

6685: SELECT pre_name_adjunct
6686: FROM per_all_people_f
6687: WHERE person_id IN
6688: (SELECT contact_person_id
6689: FROM per_contact_relationships
6690: WHERE person_id = g_person_id
6691: AND business_group_id = p_business_group_id
6692: AND contact_type IN('S','D')
6693: AND c_date_earned

Line 8275: FROM per_contact_relationships

8271: -- Cursor to fetch the partner's person id
8272: --
8273: CURSOR c_get_partner IS
8274: SELECT contact_person_id
8275: FROM per_contact_relationships
8276: WHERE person_id = g_person_id
8277: AND p_effective_date BETWEEN date_start
8278: AND Nvl(date_end,Hr_Api.g_eot)
8279: AND contact_type IN ('S','D')

Line 8324: l_partner_id per_contact_relationships.contact_person_id%TYPE;

8320: l_chg_evt_exists VARCHAR2(2);
8321: l_rows_exist NUMBER := 0;
8322: l_return_value NUMBER := -1;
8323: l_new_hire NUMBER := 0;
8324: l_partner_id per_contact_relationships.contact_person_id%TYPE;
8325: l_proc_name VARCHAR2(150) := g_proc_name ||'Record02_Display_Criteria';
8326: l_hire_dt DATE;
8327: l_chk_hire_dt_chg NUMBER := 0;
8328: l_old_hire_date DATE;