DBA Data[Home] [Help]

APPS.PAY_PAYIEP30_XMLP_PKG dependencies on PAY_BALANCE_TYPES

Line 149: VP_BALANCE_NAME IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,VP_DIMENSION_NAME IN VARCHAR2,

145: FUNCTION CF_CALCULATE_TOTAL_PRSIFORMULA(REPORT_ID IN NUMBER
146: ,ASSIGNMENT_ID IN NUMBER) RETURN NUMBER IS
147: CURSOR YTD_BALANCES(VP_PAYROLL_ACTION_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE,
148: VP_ASSIGNMENT_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE,
149: VP_BALANCE_NAME IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,VP_DIMENSION_NAME IN VARCHAR2,
150: VP_ACTION_CONTEXT_ID IN NUMBER,VP_EFFECTIVE_DATE IN DATE) IS
151: SELECT
152: PACT_YTDBAL.ACTION_INFORMATION4 BALANCE_VALUE
153: FROM

Line 159: PAY_BALANCE_TYPES PBT_YTDBAL,

155: PAY_ACTION_INTERLOCKS PAI_P30,
156: PAY_ASSIGNMENT_ACTIONS PAA_ARC,
157: PAY_ACTION_INFORMATION PACT_YTDBAL,
158: PAY_DEFINED_BALANCES PDB_YTDBAL,
159: PAY_BALANCE_TYPES PBT_YTDBAL,
160: PAY_BALANCE_DIMENSIONS PBD_YTDBAL,
161: PAY_ASSIGNMENT_ACTIONS PAA_SRC,
162: PAY_PAYROLL_ACTIONS PPA_SRC
163: WHERE PAA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID