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.PSP_PREGEN dependencies on PER_ASSIGNMENTS_F

Line 1096: FROM per_assignments_f b,

1092: WHERE a.Person_ID = x_person_id
1093: -- AND a.current_employee_flag ='Y' --Added for bug 2624259. Commented for Bug 3424494
1094: AND (x_effective_date BETWEEN a.EFFECTIVE_START_DATE and a.EFFECTIVE_END_DATE)
1095: AND x_effective_date <= ( SELECT max(b.effective_end_date)
1096: FROM per_assignments_f b,
1097: pay_payrolls_f c
1098: WHERE a.person_id = b.person_id
1099: AND b.business_group_id = x_business_group_id
1100: AND c.payroll_id = b.payroll_id

Line 1111: FROM per_assignments_f paf,

1107: FROM per_people_f ppf
1108: WHERE ppf.person_id = x_person_id
1109: AND (x_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date)
1110: AND x_effective_date <= (SELECT MAX(paf.effective_end_date)
1111: FROM per_assignments_f paf,
1112: pay_payrolls_f ppf2
1113: WHERE paf.person_id = x_person_id
1114: AND paf.business_group_id = x_business_group_id
1115: AND ppf2.payroll_id = paf.payroll_id

Line 1158: FROM per_assignments_f a, pay_payrolls_f b

1154: X_business_group_id IN NUMBER,
1155: X_set_of_books_id IN NUMBER) IS
1156: CURSOR check_assg_csr IS
1157: SELECT assignment_id
1158: FROM per_assignments_f a, pay_payrolls_f b
1159: WHERE assignment_id = x_assignment_id
1160: AND a.assignment_type ='E' --Added for bug 2624259.
1161: and a.payroll_id=b.payroll_id
1162: AND x_effective_date between a.effective_start_date and a.effective_end_date

Line 1208: FROM pay_payrolls_f a, per_assignments_f b

1204: X_business_group_id IN Number,
1205: X_set_of_books_id IN Number) IS
1206: CURSOR check_payroll_csr IS
1207: SELECT a.payroll_id
1208: FROM pay_payrolls_f a, per_assignments_f b
1209: WHERE a.payroll_id = x_payroll_id
1210: AND x_effective_date between a.effective_start_date and a.effective_end_date
1211: AND a.payroll_id = b.payroll_id
1212: AND b.assignment_id = X_assignment_id

Line 2722: FROM per_assignments_f paf,

2718: p_return_status out NOCOPY varchar2) Is
2719: CURSOR org_name_cur IS
2720: SELECT hou.organization_id,
2721: hou.name
2722: FROM per_assignments_f paf,
2723: hr_organization_units hou
2724: WHERE paf.business_group_id = p_business_group_id
2725: AND paf.assignment_id = p_assignment_id
2726: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date