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 1099: FROM per_assignments_f b,

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

Line 1114: FROM per_assignments_f paf,

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

Line 1161: FROM per_assignments_f a, pay_payrolls_f b

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

Line 1211: FROM pay_payrolls_f a, per_assignments_f b

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

Line 2725: FROM per_assignments_f paf,

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