DBA Data[Home] [Help]

APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on PER_PEOPLE_F

Line 1353: per_people_f p, /* per_all_people_f p, --Commented during MOAC uptake for bug#6341012*/

1349: -- AND fu.employee_id = he.employee_id;
1350: SELECT fu.user_id
1351: INTO l_user_id
1352: FROM fnd_user fu,
1353: per_people_f p, /* per_all_people_f p, --Commented during MOAC uptake for bug#6341012*/
1354: per_all_assignments_f a,
1355: per_assignment_status_types past
1356: WHERE fu.user_id = p_cc_header_rec.cc_owner_user_id
1357: AND sysdate BETWEEN NVL(fu.start_date, sysdate)

Line 1406: per_people_f p, /* per_all_people_f p, --Commented for Bug#6341012

1402:
1403: SELECT fu.user_id
1404: INTO l_user_id
1405: FROM fnd_user fu,
1406: per_people_f p, /* per_all_people_f p, --Commented for Bug#6341012
1407: during MOAC uptake*/
1408: per_all_assignments_f a,
1409: per_assignment_status_types past
1410: WHERE fu.user_id = p_cc_header_rec.cc_preparer_user_id