APPS.IGI_EXP_APPROVAL_PKG dependencies on PER_EMPLOYEES_CURRENT_X

Line 1211: CURSOR c_get_position(p_emp_id per_employees_current_x.employee_id%TYPE)

1207: actid IN NUMBER,
1208: funcmode IN VARCHAR2,
1209: result OUT NOCOPY VARCHAR2) IS
1210:
1211: CURSOR c_get_position(p_emp_id per_employees_current_x.employee_id%TYPE)
1212: IS
1213: SELECT hap.position_id,
1214: hap.name,
1215: hap.business_group_id,

Line 1219: per_employees_current_x pec

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
1223: AND pec.assignment_id = paa.assignment_id

Line 1240: l_transmitter_emp_id per_employees_current_x.employee_id%TYPE;

1236: l_position_id hr_all_positions_f.position_id%TYPE;
1237: l_position_name hr_all_positions_f.name%TYPE;
1238: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
1239: l_organization_id hr_all_positions_f.organization_id%TYPE;
1240: l_transmitter_emp_id per_employees_current_x.employee_id%TYPE;
1241:
1242: BEGIN
1243:
1244: -- =============== START DEBUG LOG ================

Line 2179: per_employees_current_x pec,

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
2183: AND fu.employee_id IS NOT NULL