DBA Data[Home] [Help]

APPS.PAY_US_MMREF_FUNCTION_PKG dependencies on FF_ARCHIVE_ITEMS

Line 413: p_archived_value ff_archive_items.value%type);

409: IS
410:
411: TYPE arch_columns IS RECORD(
412: p_user_name ff_database_items.user_name%type,
413: p_archived_value ff_archive_items.value%type);
414:
415: arch_rec arch_columns;
416:
417: TYPE arch_infm IS TABLE OF arch_rec%TYPE

Line 440: FROM FF_ARCHIVE_ITEMS FAI,

436: C_TAX_UNIT_ID PAY_ASSIGNMENT_ACTIONS.TAX_UNIT_ID%TYPE,
437: C_USER_ENTITY_ID FF_USER_ENTITIES.USER_ENTITY_ID%TYPE)
438: IS
439: SELECT SUM(FAI.VALUE),COUNT(FAI.ARCHIVE_ITEM_ID)
440: FROM FF_ARCHIVE_ITEMS FAI,
441: PAY_ASSIGNMENT_ACTIONS PAA
442: WHERE PAA.PAYROLL_ACTION_ID = C_PAYROLL_ACTION_ID
443: AND PAA.TAX_UNIT_ID = C_TAX_UNIT_ID
444: AND FAI.CONTEXT1 = TO_CHAR(PAA.ASSIGNMENT_ACTION_ID)