DBA Data[Home] [Help]

APPS.PAY_US_MMREF_FUNCTION_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 435: (C_PAYROLL_ACTION_ID PAY_ASSIGNMENT_ACTIONS.PAYROLL_ACTION_ID%TYPE,

431: FROM FF_USER_ENTITIES
432: WHERE USER_ENTITY_NAME = C_USER_NAME;
433:
434: CURSOR GET_ARCHIVED_VALUE
435: (C_PAYROLL_ACTION_ID PAY_ASSIGNMENT_ACTIONS.PAYROLL_ACTION_ID%TYPE,
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)

Line 436: C_TAX_UNIT_ID PAY_ASSIGNMENT_ACTIONS.TAX_UNIT_ID%TYPE,

432: WHERE USER_ENTITY_NAME = C_USER_NAME;
433:
434: CURSOR GET_ARCHIVED_VALUE
435: (C_PAYROLL_ACTION_ID PAY_ASSIGNMENT_ACTIONS.PAYROLL_ACTION_ID%TYPE,
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,

Line 441: PAY_ASSIGNMENT_ACTIONS PAA

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)
445: AND FAI.USER_ENTITY_ID = C_USER_ENTITY_ID