APPS.PAY_SE_SALARY_STRUCTURE_STATS dependencies on FF_USER_ENTITIES

Line 550: FROM ff_user_entities ue,

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
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'

Line 1794: FROM ff_user_entities u, ff_database_items d

1790: /* Cursor to retrieve Defined Balance Id */
1791: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1792: IS
1793: SELECT u.creator_id
1794: FROM ff_user_entities u, ff_database_items d
1795: WHERE d.user_name = p_user_name
1796: AND u.user_entity_id = d.user_entity_id
1797: AND (u.legislation_code = 'SE')
1798: AND (u.business_group_id IS NULL)

Line 1801: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

1797: AND (u.legislation_code = 'SE')
1798: AND (u.business_group_id IS NULL)
1799: AND u.creator_type = 'B';
1800:
1801: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1802: BEGIN
1803: IF g_debug
1804: THEN
1805: hr_utility.set_location

Line 1839: FROM ff_user_entities u, ff_database_items d

1835: /* Cursor to retrieve Defined Balance Id */
1836: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1837: IS
1838: SELECT u.creator_id
1839: FROM ff_user_entities u, ff_database_items d
1840: WHERE d.user_name = p_user_name
1841: AND u.user_entity_id = d.user_entity_id
1842: AND (u.legislation_code = 'SE')
1843: AND (u.business_group_id IS NULL)

Line 1846: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

1842: AND (u.legislation_code = 'SE')
1843: AND (u.business_group_id IS NULL)
1844: AND u.creator_type = 'B';
1845:
1846: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1847: l_return_balance_value NUMBER;
1848: BEGIN
1849: IF g_debug
1850: THEN