APPS.PA_SECURITY dependencies on PA_PROJECT_PLAYERS

Line 378: FROM pa_project_players

374:
375: BEGIN
376: SELECT 1
377: INTO dummy
378: FROM pa_project_players
379: WHERE project_id = X_project_id
380: AND person_id = X_person_id
381: AND TRUNC(sysdate) >= trunc(start_date_active)
382: AND TRUNC(sysdate) <= trunc(NVL(end_date_active, sysdate+1));

Line 434: , pa_project_players pp

430: SELECT 1
431: INTO dummy
432: --FROM pa_project_role_types rt --bug 4004821
433: FROM pa_project_role_types_b rt
434: , pa_project_players pp
435: , pa_role_controls rc -- Added for bug 3058844
436: WHERE rt.project_role_type = pp.project_role_type
437: /* Below code added for bug 3058844 */
438: AND rt.project_role_id = rc.project_role_id

Line 553: FROM pa_project_players

549:
550: BEGIN
551: SELECT 1
552: INTO dummy
553: FROM pa_project_players
554: WHERE project_id = X_project_id
555: AND person_id = X_person_id;
556:
557: RETURN( 'Y' );