DBA Data[Home] [Help]

APPS.PAY_SE_ABSENCE_USER dependencies on FF_DATABASE_ITEMS

Line 508: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE) IS

504: AND hoi1.organization_id = hoi2.organization_id
505: AND hoi2.ORG_INFORMATION_CONTEXT='SE_HOLIDAY_YEAR_DEFN'
506: AND hoi2.org_information1 IS NOT NULL;
507:
508: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE) IS
509: SELECT ue.creator_id
510: FROM ff_user_entities ue,
511: ff_database_items di
512: WHERE di.user_name = csr_v_Balance_Name

Line 511: ff_database_items di

507:
508: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE) IS
509: SELECT ue.creator_id
510: FROM ff_user_entities ue,
511: ff_database_items di
512: WHERE di.user_name = csr_v_Balance_Name
513: AND ue.user_entity_id = di.user_entity_id
514: AND ue.legislation_code = 'SE'
515: AND ue.business_group_id is NULL