DBA Data[Home] [Help]

APPS.IGI_EXP_APPROVAL_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 1218: per_all_assignments_f paa,

1214: hap.name,
1215: hap.business_group_id,
1216: hap.organization_id
1217: FROM hr_all_positions_f hap,
1218: per_all_assignments_f paa,
1219: per_employees_current_x pec
1220: WHERE pec.employee_id = p_emp_id
1221: AND NVL(pec.inactive_date,SYSDATE) >= SYSDATE
1222: AND pec.business_group_id = paa.business_group_id

Line 2178: per_all_assignments_f paa,

2174: ,p_organization_id hr_all_positions_f.organization_id%TYPE)
2175: IS
2176: SELECT fu.user_name
2177: FROM hr_all_positions_f hap,
2178: per_all_assignments_f paa,
2179: per_employees_current_x pec,
2180: fnd_user fu
2181: WHERE fu.start_date <= SYSDATE
2182: AND NVL(fu.end_date,SYSDATE) >= SYSDATE