APPS.PAY_SE_EMPLOYMENT_STATISTICS dependencies on FF_USER_ENTITIES

Line 1749: FROM ff_user_entities u, ff_database_items d

1745: /* Cursor to retrieve Defined Balance Id */
1746: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1747: IS
1748: SELECT u.creator_id
1749: FROM ff_user_entities u, ff_database_items d
1750: WHERE d.user_name = p_user_name
1751: AND u.user_entity_id = d.user_entity_id
1752: AND (u.legislation_code = 'SE')
1753: AND (u.business_group_id IS NULL)

Line 1756: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

1752: AND (u.legislation_code = 'SE')
1753: AND (u.business_group_id IS NULL)
1754: AND u.creator_type = 'B';
1755:
1756: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1757: BEGIN
1758: IF g_debug
1759: THEN
1760: hr_utility.set_location

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: l_return_balance_value NUMBER;
1803: BEGIN
1804: IF g_debug
1805: THEN