APPS.PAY_SE_HOLIDAY_PAY_DEBT dependencies on FF_USER_ENTITIES

Line 600: FROM ff_user_entities ue, ff_database_items di

596: csr_v_balance_name ff_database_items.user_name%TYPE
597: )
598: IS
599: SELECT ue.creator_id
600: FROM ff_user_entities ue, ff_database_items di
601: WHERE di.user_name = csr_v_balance_name
602: AND ue.user_entity_id = di.user_entity_id
603: AND ue.legislation_code = 'SE'
604: AND ue.business_group_id IS NULL

Line 804: FROM ff_user_entities u, ff_database_items d

800: /* Cursor to retrieve Defined Balance Id */
801: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
802: IS
803: SELECT u.creator_id
804: FROM ff_user_entities u, ff_database_items d
805: WHERE d.user_name = p_user_name
806: AND u.user_entity_id = d.user_entity_id
807: AND (u.legislation_code = 'SE')
808: AND (u.business_group_id IS NULL)

Line 811: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

807: AND (u.legislation_code = 'SE')
808: AND (u.business_group_id IS NULL)
809: AND u.creator_type = 'B';
810:
811: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
812: BEGIN
813: IF g_debug
814: THEN
815: hr_utility.set_location

Line 851: FROM ff_user_entities u, ff_database_items d

847: /* Cursor to retrieve Defined Balance Id */
848: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
849: IS
850: SELECT u.creator_id
851: FROM ff_user_entities u, ff_database_items d
852: WHERE d.user_name = p_user_name
853: AND u.user_entity_id = d.user_entity_id
854: AND (u.legislation_code = 'SE')
855: AND (u.business_group_id IS NULL)

Line 858: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

854: AND (u.legislation_code = 'SE')
855: AND (u.business_group_id IS NULL)
856: AND u.creator_type = 'B';
857:
858: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
859: l_return_balance_value NUMBER;
860: BEGIN
861: IF g_debug
862: THEN

Line 910: FROM ff_user_entities ue, ff_database_items di

906: csr_v_balance_name ff_database_items.user_name%TYPE
907: )
908: IS
909: SELECT ue.creator_id
910: FROM ff_user_entities ue, ff_database_items di
911: WHERE di.user_name = csr_v_balance_name
912: AND ue.user_entity_id = di.user_entity_id
913: AND ue.legislation_code = 'SE'
914: AND ue.business_group_id IS NULL