APPS.PAY_SE_FORA dependencies on FF_USER_ENTITIES

Line 434: FROM ff_user_entities ue,

430:
431: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
432: IS
433: SELECT ue.creator_id
434: FROM ff_user_entities ue,
435: ff_database_items di
436: WHERE di.user_name = csr_v_Balance_Name
437: AND ue.user_entity_id = di.user_entity_id
438: AND ue.legislation_code = 'SE'

Line 1672: FROM ff_user_entities u, ff_database_items d

1668: /* Cursor to retrieve Defined Balance Id */
1669: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1670: IS
1671: SELECT u.creator_id
1672: FROM ff_user_entities u, ff_database_items d
1673: WHERE d.user_name = p_user_name
1674: AND u.user_entity_id = d.user_entity_id
1675: AND (u.legislation_code = 'SE')
1676: AND (u.business_group_id IS NULL)

Line 1679: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

1675: AND (u.legislation_code = 'SE')
1676: AND (u.business_group_id IS NULL)
1677: AND u.creator_type = 'B';
1678:
1679: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1680: BEGIN
1681: IF g_debug
1682: THEN
1683: hr_utility.set_location

Line 1717: FROM ff_user_entities u, ff_database_items d

1713: /* Cursor to retrieve Defined Balance Id */
1714: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1715: IS
1716: SELECT u.creator_id
1717: FROM ff_user_entities u, ff_database_items d
1718: WHERE d.user_name = p_user_name
1719: AND u.user_entity_id = d.user_entity_id
1720: AND (u.legislation_code = 'SE')
1721: AND (u.business_group_id IS NULL)

Line 1724: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

1720: AND (u.legislation_code = 'SE')
1721: AND (u.business_group_id IS NULL)
1722: AND u.creator_type = 'B';
1723:
1724: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1725: l_return_balance_value NUMBER;
1726: BEGIN
1727: IF g_debug
1728: THEN