APPS.PA_SECURITY dependencies on PA_PROJECT_PLAYERS

Line 462: FROM pa_project_players

458:
459: BEGIN
460: SELECT 1
461: INTO dummy
462: FROM pa_project_players
463: WHERE project_id = X_project_id
464: AND person_id = X_person_id
465: AND TRUNC(sysdate) >= trunc(start_date_active)
466: AND TRUNC(sysdate) <= trunc(NVL(end_date_active, sysdate+1));

Line 518: , pa_project_players pp

514: SELECT 1
515: INTO dummy
516: --FROM pa_project_role_types rt --bug 4004821
517: FROM pa_project_role_types_b rt
518: , pa_project_players pp
519: , pa_role_controls rc -- Added for bug 3058844
520: WHERE rt.project_role_type = pp.project_role_type
521: /* Below code added for bug 3058844 */
522: AND rt.project_role_id = rc.project_role_id

Line 637: FROM pa_project_players

633:
634: BEGIN
635: SELECT 1
636: INTO dummy
637: FROM pa_project_players
638: WHERE project_id = X_project_id
639: AND person_id = X_person_id;
640:
641: RETURN( 'Y' );