DBA Data[Home] [Help]

APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on PER_ALL_ASSIGNMENTS_F

Line 1354: per_all_assignments_f a,

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)
1358: AND NVL(fu.end_date, sysdate)

Line 1408: per_all_assignments_f a,

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
1411: AND sysdate BETWEEN NVL(fu.start_date, sysdate)
1412: AND NVL(fu.end_date, sysdate)