DBA Data[Home] [Help]

APPS.PSP_GENERAL dependencies on HR_ORGANIZATION_INFORMATION

Line 485: FROM hr_organization_information hoi,

481: AND NVL(PUC.legislation_code, l_legislation_code) = l_legislation_code
482: AND PUC.user_table_id = PUT.user_table_id (+)
483: AND ( PUT.user_table_id IS NULL
484: OR PUT.user_table_name = (SELECT put.user_table_name
485: FROM hr_organization_information hoi,
486: pay_user_tables put
487: WHERE hoi.organization_id = l_business_group_id
488: AND hoi.org_information_context ='Work Schedule'
489: AND hoi.org_information1 = put.user_table_id));