APPS.PQP_NL_PENSION_EXTRACTS dependencies on PER_CONTACT_RELATIONSHIPS

Line 6249: FROM per_contact_relationships

6245: SELECT last_name
6246: FROM per_all_people_f
6247: WHERE person_id IN
6248: ( SELECT contact_person_id
6249: FROM per_contact_relationships
6250: WHERE person_id = c_person_id
6251: AND business_group_id = p_business_group_id
6252: AND contact_type IN ('S','D')
6253: AND c_date_earned

Line 6351: FROM per_contact_relationships

6347: SELECT pre_name_adjunct
6348: FROM per_all_people_f
6349: WHERE person_id IN
6350: (SELECT contact_person_id
6351: FROM per_contact_relationships
6352: WHERE person_id = g_person_id
6353: AND business_group_id = p_business_group_id
6354: AND contact_type IN('S','D')
6355: AND c_date_earned

Line 7936: FROM per_contact_relationships

7932: -- Cursor to fetch the partner's person id
7933: --
7934: CURSOR c_get_partner IS
7935: SELECT contact_person_id
7936: FROM per_contact_relationships
7937: WHERE person_id = g_person_id
7938: AND p_effective_date BETWEEN date_start
7939: AND Nvl(date_end,Hr_Api.g_eot)
7940: AND contact_type IN ('S','D')

Line 7985: l_partner_id per_contact_relationships.contact_person_id%TYPE;

7981: l_chg_evt_exists VARCHAR2(2);
7982: l_rows_exist NUMBER := 0;
7983: l_return_value NUMBER := -1;
7984: l_new_hire NUMBER := 0;
7985: l_partner_id per_contact_relationships.contact_person_id%TYPE;
7986: l_proc_name VARCHAR2(150) := g_proc_name ||'Record02_Display_Criteria';
7987: l_hire_dt DATE;
7988: l_chk_hire_dt_chg NUMBER := 0;
7989: l_old_hire_date DATE;