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.PER_CONTACT_RELATIONSHIPS_PKG dependencies on PER_PERSON_TYPE_USAGES

Line 91: person_type_id from per_person_type_usages

87: call to ensure security list maintenance
88: gets properly updated.
89: 06-Sep-02 vramanai 115.30 2533935 modified the cursor defination of check_person_changed
90: in update_contact procedure, to get the value of
91: person_type_id from per_person_type_usages
92: 16-Sep-02 vramanai 115.31 2533935 moddified the earlier fix as there was some
93: problem with the fix.
94: 05-Dec-02 pkakar 115.32 added nocopy to parameters
95: 10-Dec-02 mbocutt 115.33 2690302 Added code to INSERT_ROW routine

Line 2578: FROM per_all_people_f ppf,per_person_type_usages ptu

2574: --
2575: --
2576: CURSOR Check_Person_Changed IS
2577: SELECT /*+ NO_EXPAND */ 'Y'
2578: FROM per_all_people_f ppf,per_person_type_usages ptu
2579: WHERE ppf.person_id=X_Contact_Person_id
2580: AND X_Session_Date BETWEEN
2581: ppf.effective_start_date AND ppf.effective_end_date
2582: AND ppf.last_name = X_Last_Name