APPS.PAY_SE_INCOME_STATEMENT dependencies on FF_USER_ENTITIES

Line 881: FROM ff_user_entities ue

877: csr_v_balance_name ff_database_items.user_name%TYPE
878: )
879: IS
880: SELECT ue.creator_id
881: FROM ff_user_entities ue
882: ,ff_database_items di
883: WHERE di.user_name = csr_v_balance_name
884: AND ue.user_entity_id = di.user_entity_id
885: AND ue.legislation_code = 'SE'

Line 1631: FROM ff_user_entities u

1627: /* Cursor to retrieve Defined Balance Id */
1628: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1629: IS
1630: SELECT u.creator_id
1631: FROM ff_user_entities u
1632: ,ff_database_items d
1633: WHERE d.user_name = p_user_name
1634: AND u.user_entity_id = d.user_entity_id
1635: AND (u.legislation_code = 'SE')

Line 1639: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

1635: AND (u.legislation_code = 'SE')
1636: AND (u.business_group_id IS NULL)
1637: AND u.creator_type = 'B';
1638:
1639: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1640: BEGIN
1641: IF g_debug
1642: THEN
1643: hr_utility.set_location

Line 1679: FROM ff_user_entities u

1675: /* Cursor to retrieve Defined Balance Id */
1676: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1677: IS
1678: SELECT u.creator_id
1679: FROM ff_user_entities u
1680: ,ff_database_items d
1681: WHERE d.user_name = p_user_name
1682: AND u.user_entity_id = d.user_entity_id
1683: AND (u.legislation_code = 'SE')

Line 1687: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

1683: AND (u.legislation_code = 'SE')
1684: AND (u.business_group_id IS NULL)
1685: AND u.creator_type = 'B';
1686:
1687: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1688: l_return_balance_value NUMBER;
1689: BEGIN
1690: IF g_debug
1691: THEN

Line 1747: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

1743: AND pbd.balance_dimension_id = pd.balance_dimension_id
1744: AND pbd.legislation_code = 'SE'
1745: AND pbd.database_item_suffix = '_PER_LE_YTD';
1746:
1747: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1748: l_return_balance_value NUMBER;
1749: BEGIN
1750: IF p_balance_type_id IS NOT NULL
1751: THEN

Line 1791: FROM ff_user_entities ue

1787: csr_v_balance_name ff_database_items.user_name%TYPE
1788: )
1789: IS
1790: SELECT ue.creator_id
1791: FROM ff_user_entities ue
1792: ,ff_database_items di
1793: WHERE di.user_name = csr_v_balance_name
1794: AND ue.user_entity_id = di.user_entity_id
1795: AND ue.legislation_code = 'SE'