APPS.PAY_US_MMREF_FUNCTION_PKG dependencies on FF_ARCHIVE_ITEMS

Line 425: p_archived_value ff_archive_items.value%type);

421: IS
422:
423: TYPE arch_columns IS RECORD(
424: p_user_name ff_database_items.user_name%type,
425: p_archived_value ff_archive_items.value%type);
426:
427: arch_rec arch_columns;
428:
429: TYPE arch_infm IS TABLE OF arch_rec%TYPE

Line 452: FROM FF_ARCHIVE_ITEMS FAI,

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
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)