APPS.PAY_SE_WAGES_SALARIES dependencies on FF_DATABASE_ITEMS

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

463: AND eev2.effective_end_date >= csr_v_start_date;
464:
465:
466:
467: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
468: IS
469: SELECT ue.creator_id
470: FROM ff_user_entities ue,
471: ff_database_items di

Line 471: ff_database_items di

467: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
468: IS
469: SELECT ue.creator_id
470: FROM ff_user_entities ue,
471: ff_database_items di
472: WHERE di.user_name = csr_v_Balance_Name
473: AND ue.user_entity_id = di.user_entity_id
474: AND ue.legislation_code = 'SE'
475: AND ue.business_group_id is NULL

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

1000: AND eev2.effective_end_date >= csr_v_start_date;
1001:
1002:
1003:
1004: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
1005: IS
1006: SELECT ue.creator_id
1007: FROM ff_user_entities ue,
1008: ff_database_items di

Line 1008: ff_database_items di

1004: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
1005: IS
1006: SELECT ue.creator_id
1007: FROM ff_user_entities ue,
1008: ff_database_items di
1009: WHERE di.user_name = csr_v_Balance_Name
1010: AND ue.user_entity_id = di.user_entity_id
1011: AND ue.legislation_code = 'SE'
1012: AND ue.business_group_id is NULL

Line 3345: FROM ff_user_entities u, ff_database_items d

3341: /* Cursor to retrieve Defined Balance Id */
3342: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
3343: IS
3344: SELECT u.creator_id
3345: FROM ff_user_entities u, ff_database_items d
3346: WHERE d.user_name = p_user_name
3347: AND u.user_entity_id = d.user_entity_id
3348: AND (u.legislation_code = 'SE')
3349: AND (u.business_group_id IS NULL)

Line 3390: FROM ff_user_entities u, ff_database_items d

3386: /* Cursor to retrieve Defined Balance Id */
3387: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
3388: IS
3389: SELECT u.creator_id
3390: FROM ff_user_entities u, ff_database_items d
3391: WHERE d.user_name = p_user_name
3392: AND u.user_entity_id = d.user_entity_id
3393: AND (u.legislation_code = 'SE')
3394: AND (u.business_group_id IS NULL)