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

Line 22: per_all_assignments_f asg

18: select
19: greatest(min(asg.effective_start_date)
20: ,min(ptp.start_date))
21: from
22: per_all_assignments_f asg
23: ,per_time_periods ptp
24: where asg.assignment_id = p_assignment_id
25: and ptp.payroll_id = asg.payroll_id
26: and ptp.start_date <= asg.effective_end_date;

Line 83: FROM per_all_assignments_f ass

79: (p_assignment_id NUMBER
80: ,p_upload_date DATE
81: ) IS
82: SELECT ptp.start_date
83: FROM per_all_assignments_f ass
84: ,per_time_periods ptp
85: WHERE ass.assignment_id = p_assignment_id
86: AND ass.effective_start_date <= p_upload_date
87: AND ass.effective_end_date >= p_upload_date

Line 93: l_business_group_id PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID%TYPE;

89: AND p_upload_date BETWEEN ptp.start_date
90: AND ptp.end_date;
91:
92: l_expiry_date DATE;
93: l_business_group_id PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID%TYPE;
94: l_itd_start_date date;
95: --l_oe_start_date date;
96: l_holiday_year date;
97: BEGIN