APPS.PAY_SE_ABSENCE dependencies on FF_DATABASE_ITEMS

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

778: AND ee.effective_end_date = l_end_dt
779: AND eev1.effective_start_date = l_start_dt
780: AND eev1.effective_end_date = l_end_dt ;
781:
782: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
783: IS
784: SELECT ue.creator_id
785: FROM ff_user_entities ue,
786: ff_database_items di

Line 786: ff_database_items di

782: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
783: IS
784: SELECT ue.creator_id
785: FROM ff_user_entities ue,
786: ff_database_items di
787: WHERE di.user_name = csr_v_Balance_Name
788: AND ue.user_entity_id = di.user_entity_id
789: AND ue.legislation_code = 'SE'
790: AND ue.business_group_id is NULL

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

3270: AND GLOBAL_NAME=csr_v_global_name --'SE_BASIC_AMOUNT'
3271: AND csr_v_effective_date /*'28-feb-2007'*/ BETWEEN effective_start_date
3272: AND effective_end_date;
3273:
3274: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
3275: IS
3276: SELECT ue.creator_id
3277: FROM ff_user_entities ue,
3278: ff_database_items di

Line 3278: ff_database_items di

3274: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
3275: IS
3276: SELECT ue.creator_id
3277: FROM ff_user_entities ue,
3278: ff_database_items di
3279: WHERE di.user_name = csr_v_Balance_Name
3280: AND ue.user_entity_id = di.user_entity_id
3281: AND ue.legislation_code = 'SE'
3282: AND ue.business_group_id is NULL