APPS.PAY_SE_SALARY_STRUCTURE_STATS dependencies on FF_DATABASE_ITEMS

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

543: )
544: IS
545:
546:
547: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
548: IS
549: SELECT ue.creator_id
550: FROM ff_user_entities ue,
551: ff_database_items di

Line 551: ff_database_items di

547: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
548: IS
549: SELECT ue.creator_id
550: FROM ff_user_entities ue,
551: ff_database_items di
552: WHERE di.user_name = csr_v_Balance_Name
553: AND ue.user_entity_id = di.user_entity_id
554: AND ue.legislation_code = 'SE'
555: AND ue.business_group_id is NULL

Line 1765: FROM ff_user_entities u, ff_database_items d

1761: /* Cursor to retrieve Defined Balance Id */
1762: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1763: IS
1764: SELECT u.creator_id
1765: FROM ff_user_entities u, ff_database_items d
1766: WHERE d.user_name = p_user_name
1767: AND u.user_entity_id = d.user_entity_id
1768: AND (u.legislation_code = 'SE')
1769: AND (u.business_group_id IS NULL)

Line 1810: FROM ff_user_entities u, ff_database_items d

1806: /* Cursor to retrieve Defined Balance Id */
1807: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1808: IS
1809: SELECT u.creator_id
1810: FROM ff_user_entities u, ff_database_items d
1811: WHERE d.user_name = p_user_name
1812: AND u.user_entity_id = d.user_entity_id
1813: AND (u.legislation_code = 'SE')
1814: AND (u.business_group_id IS NULL)