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_VIEWS_PKG dependencies on PER_ASSIGNMENTS_F

Line 12: from PER_ASSIGNMENTS_F a,

8: a.effective_end_date,
9: a.business_group_id,
10: b.DATE_START,
11: b.ACTUAL_TERMINATION_DATE
12: from PER_ASSIGNMENTS_F a,
13: PER_PERIODS_OF_SERVICE b
14: where a.assignment_id = P_assignment_id
15: and P_calculation_date between a.effective_start_date and
16: a.effective_end_date

Line 127: v_PAY_BASIS_ID per_assignments_f.pay_basis_id%type;

123: v_working_hours NUMBER;
124: v_frequency VARCHAR2(80);
125: v_adj_mid NUMBER;
126: --changes for bug no 5945278 starts here
127: v_PAY_BASIS_ID per_assignments_f.pay_basis_id%type;
128: v_PAY_ANNUALIZATION_FACTOR PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%type;
129: v_GRADE_ANNUALIZATION_FACTOR PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%type;
130: v_proposed_salary number;
131: --changes for bug no 5945278 ends here

Line 144: , per_assignments_f a

140: --changes for bug no 5945278 starts here
141: , a.PAY_BASIS_ID
142: --changes for bug no 5945278 ends here
143: from pay_grade_rules_f gr
144: , per_assignments_f a
145: , per_pay_proposals pp
146: where gr.grade_or_spinal_point_id = a.grade_id
147: and pp.change_date between gr.effective_start_date
148: and gr.effective_end_date

Line 1185: from per_assignments_f a,

1181: CURSOR csr_all_asg_status is
1182: select a.effective_start_date,
1183: a.effective_end_date,
1184: b.PER_SYSTEM_STATUS
1185: from per_assignments_f a,
1186: per_assignment_status_types b
1187: where a.assignment_id = P_assignment_id
1188: and a.effective_end_date between p_first_p_start_date and
1189: hr_general.end_of_time