DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE_EHOL dependencies on FF_DATABASE_ITEMS

Line 1382: CURSOR csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE) IS

1378: OR (BUSINESS_GROUP_ID = p_business_group_id)));
1379:
1380: rg_csr_asg_terminator csr_asg_terminator%rowtype;
1381:
1382: CURSOR csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE) IS
1383: SELECT ue.creator_id
1384: FROM ff_user_entities ue, ff_database_items di
1385: WHERE di.user_name = csr_v_Balance_Name
1386: AND ue.user_entity_id = di.user_entity_id

Line 1384: FROM ff_user_entities ue, ff_database_items di

1380: rg_csr_asg_terminator csr_asg_terminator%rowtype;
1381:
1382: CURSOR csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE) IS
1383: SELECT ue.creator_id
1384: FROM ff_user_entities ue, ff_database_items di
1385: WHERE di.user_name = csr_v_Balance_Name
1386: AND ue.user_entity_id = di.user_entity_id
1387: AND ue.legislation_code = 'DK'
1388: AND ue.business_group_id is NULL