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.PQP_GB_PSI_WPS_HISTORY dependencies on PER_ALL_ASSIGNMENTS_F

Line 17: g_assignment_dtl per_all_assignments_f%rowtype;

13: g_person_id NUMBER := NULL;
14: g_business_group_id NUMBER := NULL; -- IMPORTANT TO KEEP NULL
15: g_assignment_id NUMBER := NULL; -- IMPORTANT TO KEEP NULL
16: g_person_dtl per_all_people_f%rowtype;
17: g_assignment_dtl per_all_assignments_f%rowtype;
18: g_altkey VARCHAR2(12):= NULL;
19: g_current_run varchar2(20) := NULL;
20: g_prev_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
21: g_notional_pay NUMBER; -- used while calculating actual pay

Line 45: g_curr_assg_dtls per_all_assignments_f%ROWTYPE;

41:
42: g_curr_person_dtls per_all_people_f%ROWTYPE;
43: -- this contains the person details on effective date
44:
45: g_curr_assg_dtls per_all_assignments_f%ROWTYPE;
46:
47: -- uniformed grade override flag configuration values.
48: g_unigrade_source VARCHAR2(30);
49: g_assignment_context VARCHAR2(80);

Line 225: FROM per_all_assignments_f

221: CURSOR get_assgn_eff_end_date(p_assignment_id in number
222: ,p_effective_date in date
223: )
224: IS SELECT effective_end_date
225: FROM per_all_assignments_f
226: WHERE assignment_id = p_assignment_id
227: AND effective_end_date = p_effective_date
228: AND assignment_status_type_id = 1;
229: