APPS.PAY_US_MMREF_FUNCTION_PKG dependencies on FF_USER_ENTITIES

Line 436: l_entity_id FF_USER_ENTITIES.USER_ENTITY_ID%TYPE;

432: arch_table arch_infm;
433:
434: l_count number(10) := 0;
435: l_output_value varchar2(100);
436: l_entity_id FF_USER_ENTITIES.USER_ENTITY_ID%TYPE;
437:
438: /*Bug:3092981 */
439:
440: CURSOR GET_ENTITY_ID(C_USER_NAME FF_USER_ENTITIES.USER_ENTITY_NAME%TYPE)

Line 440: CURSOR GET_ENTITY_ID(C_USER_NAME FF_USER_ENTITIES.USER_ENTITY_NAME%TYPE)

436: l_entity_id FF_USER_ENTITIES.USER_ENTITY_ID%TYPE;
437:
438: /*Bug:3092981 */
439:
440: CURSOR GET_ENTITY_ID(C_USER_NAME FF_USER_ENTITIES.USER_ENTITY_NAME%TYPE)
441: IS
442: SELECT USER_ENTITY_ID
443: FROM FF_USER_ENTITIES
444: WHERE USER_ENTITY_NAME = C_USER_NAME;

Line 443: FROM FF_USER_ENTITIES

439:
440: CURSOR GET_ENTITY_ID(C_USER_NAME FF_USER_ENTITIES.USER_ENTITY_NAME%TYPE)
441: IS
442: SELECT USER_ENTITY_ID
443: FROM FF_USER_ENTITIES
444: WHERE USER_ENTITY_NAME = C_USER_NAME;
445:
446: CURSOR GET_ARCHIVED_VALUE
447: (C_PAYROLL_ACTION_ID PAY_ASSIGNMENT_ACTIONS.PAYROLL_ACTION_ID%TYPE,

Line 449: C_USER_ENTITY_ID FF_USER_ENTITIES.USER_ENTITY_ID%TYPE)

445:
446: CURSOR GET_ARCHIVED_VALUE
447: (C_PAYROLL_ACTION_ID PAY_ASSIGNMENT_ACTIONS.PAYROLL_ACTION_ID%TYPE,
448: C_TAX_UNIT_ID PAY_ASSIGNMENT_ACTIONS.TAX_UNIT_ID%TYPE,
449: C_USER_ENTITY_ID FF_USER_ENTITIES.USER_ENTITY_ID%TYPE)
450: IS
451: SELECT SUM(FAI.VALUE),COUNT(FAI.ARCHIVE_ITEM_ID)
452: FROM FF_ARCHIVE_ITEMS FAI,
453: PAY_ASSIGNMENT_ACTIONS PAA