DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on PER_SECURITY_ORGANIZATIONS

Line 430: FROM per_security_organizations pso

426: p_program_id,
427: p_program_application_id,
428: l_update_date,
429: pso.organization_id
430: FROM per_security_organizations pso
431: WHERE pso.entry_type = 'I'
432: AND pso.security_profile_id = l_security_profile_id
433: AND NOT EXISTS
434: (SELECT NULL

Line 544: FROM per_security_organizations

540: WHERE security_profile_id = l_security_profile_id
541: AND user_id IS NULL
542: AND organization_id IN
543: (SELECT organization_id
544: FROM per_security_organizations
545: WHERE security_profile_id = l_security_profile_id
546: AND entry_type = 'E');
547: --
548: -- BUSINESS_GROUP_ID's should be excluded from PER_ORGANIZATION_LIST for a