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,
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)
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,
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,
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
454: WHERE PAA.PAYROLL_ACTION_ID = C_PAYROLL_ACTION_ID
455: AND PAA.TAX_UNIT_ID = C_TAX_UNIT_ID
456: AND FAI.CONTEXT1 = TO_CHAR(PAA.ASSIGNMENT_ACTION_ID)
457: AND FAI.USER_ENTITY_ID = C_USER_ENTITY_ID