APPS.PAY_SE_ALECTA dependencies on FF_USER_ENTITIES

Line 533: FROM ff_user_entities ue

529: csr_v_balance_name ff_database_items.user_name%TYPE
530: )
531: IS
532: SELECT ue.creator_id
533: FROM ff_user_entities ue
534: ,ff_database_items di
535: WHERE di.user_name = csr_v_balance_name
536: AND ue.user_entity_id = di.user_entity_id
537: AND ue.legislation_code = 'SE'

Line 888: FROM ff_user_entities u

884: /* Cursor to retrieve Defined Balance Id */
885: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
886: IS
887: SELECT u.creator_id
888: FROM ff_user_entities u
889: ,ff_database_items d
890: WHERE d.user_name = p_user_name
891: AND u.user_entity_id = d.user_entity_id
892: AND (u.legislation_code = 'SE')

Line 896: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

892: AND (u.legislation_code = 'SE')
893: AND (u.business_group_id IS NULL)
894: AND u.creator_type = 'B';
895:
896: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
897: BEGIN
898: IF g_debug
899: THEN
900: hr_utility.set_location

Line 941: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

937: AND db.balance_dimension_id = bd.balance_dimension_id
938: AND bd.database_item_suffix = p_dimension
939: AND bd.legislation_code = 'SE';
940:
941: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
942: l_return_balance_value NUMBER;
943: BEGIN
944: IF p_balance_type_id IS NOT NULL
945: THEN

Line 982: FROM ff_user_entities ue

978: csr_v_balance_name ff_database_items.user_name%TYPE
979: )
980: IS
981: SELECT ue.creator_id
982: FROM ff_user_entities ue
983: ,ff_database_items di
984: WHERE di.user_name = csr_v_balance_name
985: AND ue.user_entity_id = di.user_entity_id
986: AND ue.legislation_code = 'SE'