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.IGS_SV_BATCH_PROCESS_PKG dependencies on HZ_RELATIONSHIPS

Line 4572: HZ_RELATIONSHIPS rel

4568: dep.REMARKS comments,
4569: rel.COMMENTS rel_remarks,
4570: decode (RELATIONSHIP_CODE,'PARENT_OF','02','SPOUSE_OF','01','XX' ) relationship
4571: FROM igs_pe_depd_active dep,
4572: HZ_RELATIONSHIPS rel
4573: WHERE subject_id = p_person_rec.person_id
4574: AND rel.relationship_id = dep.relationship_id
4575: AND (p_person_rec.record_status = 'C' OR dep.action_code ='A') --In the new mode report only about active dependents
4576: AND RELATIONSHIP_CODE IN ('PARENT_OF','SPOUSE_OF' )

Line 11545: FROM hz_relationships rel

11541: AND pr.record_status <> 'E' AND prs.person_id = fr.person_id)
11542: ) AND fr.sevis_school_identifier = p_org_party_id AND
11543: ( (p_dso_id IS NULL AND
11544: (EXISTS (SELECT rel.object_id
11545: FROM hz_relationships rel
11546: WHERE rel.object_id = fr.person_id AND
11547: --rel.DIRECTIONAL_FLAG = 'F' AND fix for bug 5258405
11548: sysdate between rel.start_date AND nvl(end_date, sysdate) AND
11549: rel.RELATIONSHIP_CODE = 'DSO_FOR') ))

Line 11551: fr.person_id IN (SELECT rel.object_id FROM hz_relationships rel

11547: --rel.DIRECTIONAL_FLAG = 'F' AND fix for bug 5258405
11548: sysdate between rel.start_date AND nvl(end_date, sysdate) AND
11549: rel.RELATIONSHIP_CODE = 'DSO_FOR') ))
11550: OR
11551: fr.person_id IN (SELECT rel.object_id FROM hz_relationships rel
11552: WHERE rel.subject_id = p_dso_party_id
11553: --AND rel.DIRECTIONAL_FLAG = 'F' fix for bug 5258405
11554: AND sysdate between rel.start_date AND nvl(end_date, sysdate)
11555: AND rel.RELATIONSHIP_CODE = 'DSO_FOR')

Line 11577: FROM hz_relationships rel

11573: ) )
11574: AND fr.sevis_school_identifier = p_org_party_id AND
11575: ( (p_dso_id IS NULL AND
11576: (EXISTS (SELECT rel.object_id
11577: FROM hz_relationships rel
11578: WHERE rel.object_id = fr.person_id AND
11579: --rel.DIRECTIONAL_FLAG = 'F' AND fix for bug 5258405
11580: sysdate between rel.start_date AND nvl(end_date, sysdate) AND
11581: rel.RELATIONSHIP_CODE = 'DSO_FOR') ))

Line 11584: FROM hz_relationships rel

11580: sysdate between rel.start_date AND nvl(end_date, sysdate) AND
11581: rel.RELATIONSHIP_CODE = 'DSO_FOR') ))
11582: OR
11583: fr.person_id IN (SELECT rel.object_id
11584: FROM hz_relationships rel
11585: WHERE rel.subject_id = p_dso_party_id and
11586: --rel.DIRECTIONAL_FLAG = 'F' AND fix for bug 5258405
11587: sysdate between rel.start_date AND nvl(end_date, sysdate) AND
11588: rel.RELATIONSHIP_CODE = 'DSO_FOR')

Line 11643: FROM hz_relationships rel, igs_pe_alt_pers_id alt

11639:
11640: CURSOR c_get_dso_id(c_person_id igs_pe_ev_form.person_id%TYPE)
11641: IS
11642: SELECT alt.api_person_id, alt.pe_person_id
11643: FROM hz_relationships rel, igs_pe_alt_pers_id alt
11644: WHERE rel.subject_id = c_person_id and
11645: rel.object_id = alt.pe_person_id AND
11646: sysdate between alt.start_dt and nvl(alt.end_dt,sysdate+1) AND
11647: sysdate between rel.start_date AND nvl(end_date, sysdate) AND

Line 13829: FROM hz_relationships

13825: WHERE group_id = p_group_id AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);
13826:
13827: CURSOR c_dso_relation(cp_person_id NUMBER) IS
13828: SELECT subject_id
13829: FROM hz_relationships
13830: WHERE object_id = cp_person_id AND
13831: SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE)
13832: AND relationship_code = 'DSO_FOR';
13833: -- AND directional_flag = 'F'; fix for bug 5258405

Line 13837: FROM hz_relationships

13833: -- AND directional_flag = 'F'; fix for bug 5258405
13834:
13835: CURSOR c_old_dso_rel(cp_person_id NUMBER) IS
13836: SELECT object_id, relationship_id, comments, object_version_number, directional_flag
13837: FROM hz_relationships
13838: WHERE subject_id = cp_person_id AND
13839: SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE+1)
13840: AND relationship_code = 'DSO_FOR';
13841: -- AND directional_flag = 'F'; fix for bug 5258405

Line 13843: CURSOR c_old_rel_values(cp_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE, cp_dir_flag HZ_RELATIONSHIPS.DIRECTIONAL_FLAG%TYPE) IS

13839: SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE+1)
13840: AND relationship_code = 'DSO_FOR';
13841: -- AND directional_flag = 'F'; fix for bug 5258405
13842:
13843: CURSOR c_old_rel_values(cp_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE, cp_dir_flag HZ_RELATIONSHIPS.DIRECTIONAL_FLAG%TYPE) IS
13844: SELECT directional_flag, primary, secondary, joint_salutation, next_to_kin, rep_faculty, rep_staff,
13845: rep_student, rep_alumni, emergency_contact_flag
13846: FROM igs_pe_hz_rel
13847: WHERE relationship_id = cp_rel_id

Line 13858: lv_party_relationship_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE ;

13854:
13855: lv_return_status VARCHAR2(1) ;
13856: lv_msg_count NUMBER;
13857: lv_msg_data VARCHAR2(2000);
13858: lv_party_relationship_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE ;
13859: lv_party_id HZ_PARTIES.PARTY_ID%TYPE ;
13860: lv_party_number HZ_PARTIES.PARTY_NUMBER%TYPE ;
13861: lv_last_update_date HZ_PARTIES.LAST_UPDATE_DATE%TYPE ;
13862: lv_object_version_number HZ_RELATIONSHIPS.OBJECT_VERSION_NUMBER%TYPE;

Line 13862: lv_object_version_number HZ_RELATIONSHIPS.OBJECT_VERSION_NUMBER%TYPE;

13858: lv_party_relationship_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE ;
13859: lv_party_id HZ_PARTIES.PARTY_ID%TYPE ;
13860: lv_party_number HZ_PARTIES.PARTY_NUMBER%TYPE ;
13861: lv_last_update_date HZ_PARTIES.LAST_UPDATE_DATE%TYPE ;
13862: lv_object_version_number HZ_RELATIONSHIPS.OBJECT_VERSION_NUMBER%TYPE;
13863:
13864: l_subject HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;
13865: l_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
13866: l_old_rel_values c_old_rel_values%ROWTYPE;

Line 13864: l_subject HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;

13860: lv_party_number HZ_PARTIES.PARTY_NUMBER%TYPE ;
13861: lv_last_update_date HZ_PARTIES.LAST_UPDATE_DATE%TYPE ;
13862: lv_object_version_number HZ_RELATIONSHIPS.OBJECT_VERSION_NUMBER%TYPE;
13863:
13864: l_subject HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;
13865: l_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
13866: l_old_rel_values c_old_rel_values%ROWTYPE;
13867:
13868: l_file_name igs_pe_persid_group_all.file_name%TYPE;

Line 13865: l_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;

13861: lv_last_update_date HZ_PARTIES.LAST_UPDATE_DATE%TYPE ;
13862: lv_object_version_number HZ_RELATIONSHIPS.OBJECT_VERSION_NUMBER%TYPE;
13863:
13864: l_subject HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;
13865: l_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
13866: l_old_rel_values c_old_rel_values%ROWTYPE;
13867:
13868: l_file_name igs_pe_persid_group_all.file_name%TYPE;
13869: l_str VARCHAR2(32767);

Line 13883: l_obj_id HZ_RELATIONSHIPS.OBJECT_ID%TYPE;

13879:
13880: l_new_dso_id VARCHAR2(20) := substr(p_new_dso_id,1,instr(p_new_dso_id,'-',-1)-1) ;
13881: l_new_dso_partyid NUMBER := to_number(substr(p_new_dso_id,instr(p_new_dso_id,'-',-1)+1));
13882:
13883: l_obj_id HZ_RELATIONSHIPS.OBJECT_ID%TYPE;
13884:
13885: TYPE c_person_det IS RECORD
13886: (
13887: person_num hz_parties.party_number%TYPE,