APPS.PAY_PYUCSLIS_PKG dependencies on PER_SECURITY_ORGANIZATIONS

Line 494: FROM per_security_organizations pso

490: p_program_id,
491: p_program_application_id,
492: l_update_date,
493: pso.organization_id
494: FROM per_security_organizations pso
495: WHERE pso.entry_type = 'I'
496: AND pso.security_profile_id = l_security_profile_id
497: AND NOT EXISTS
498: (SELECT NULL

Line 608: FROM per_security_organizations

604: WHERE security_profile_id = l_security_profile_id
605: AND user_id IS NULL
606: AND organization_id IN
607: (SELECT organization_id
608: FROM per_security_organizations
609: WHERE security_profile_id = l_security_profile_id
610: AND entry_type = 'E');
611: --
612: -- BUSINESS_GROUP_ID's should be excluded from PER_ORGANIZATION_LIST for a