eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYIEP30_XMLP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 8: PAY_ASSIGNMENT_ACTIONS PAA_P30,

4: CURSOR CUR_ARCSTARTDATE(VP_PAYROLL_ACTION_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE) IS
5: SELECT
6: MIN(PPA_ARC.START_DATE) START_DATE
7: FROM
8: PAY_ASSIGNMENT_ACTIONS PAA_P30,
9: PAY_ACTION_INTERLOCKS PAI_P30,
10: PAY_ASSIGNMENT_ACTIONS PAA_ARC,
11: PAY_PAYROLL_ACTIONS PPA_ARC
12: WHERE PAA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID

Line 10: PAY_ASSIGNMENT_ACTIONS PAA_ARC,

6: MIN(PPA_ARC.START_DATE) START_DATE
7: FROM
8: PAY_ASSIGNMENT_ACTIONS PAA_P30,
9: PAY_ACTION_INTERLOCKS PAI_P30,
10: PAY_ASSIGNMENT_ACTIONS PAA_ARC,
11: PAY_PAYROLL_ACTIONS PPA_ARC
12: WHERE PAA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID
13: AND PAA_P30.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKING_ACTION_ID
14: AND PAA_ARC.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKED_ACTION_ID

Line 148: VP_ASSIGNMENT_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE,

144:
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

Line 154: PAY_ASSIGNMENT_ACTIONS PAA_P30,

150: VP_ACTION_CONTEXT_ID IN NUMBER,VP_EFFECTIVE_DATE IN DATE) IS
151: SELECT
152: PACT_YTDBAL.ACTION_INFORMATION4 BALANCE_VALUE
153: FROM
154: PAY_ASSIGNMENT_ACTIONS PAA_P30,
155: PAY_ACTION_INTERLOCKS PAI_P30,
156: PAY_ASSIGNMENT_ACTIONS PAA_ARC,
157: PAY_ACTION_INFORMATION PACT_YTDBAL,
158: PAY_DEFINED_BALANCES PDB_YTDBAL,

Line 156: PAY_ASSIGNMENT_ACTIONS PAA_ARC,

152: PACT_YTDBAL.ACTION_INFORMATION4 BALANCE_VALUE
153: FROM
154: PAY_ASSIGNMENT_ACTIONS PAA_P30,
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,

Line 161: PAY_ASSIGNMENT_ACTIONS PAA_SRC,

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
164: AND PAA_P30.ASSIGNMENT_ID = VP_ASSIGNMENT_ID
165: AND PAA_P30.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKING_ACTION_ID

Line 186: CURSOR CUR_GET_PREV_P30_LOCK_ID(VP_PAYROLL_ACTION_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE,VP_ASSIGNMENT_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE,VP_TAX_START_DATE IN DATE,VP_REPORT_END_DATE IN DATE) IS

182: PACT_YTDBAL.EFFECTIVE_DATE,
183: PACT_YTDBAL.ACTION_CONTEXT_ID,
184: NVL(PACT_YTDBAL.ACTION_INFORMATION5
185: ,0);
186: CURSOR CUR_GET_PREV_P30_LOCK_ID(VP_PAYROLL_ACTION_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE,VP_ASSIGNMENT_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE,VP_TAX_START_DATE IN DATE,VP_REPORT_END_DATE IN DATE) IS
187: SELECT
188: PPA.PAYROLL_ACTION_ID PREV_DATA_LOCK_ID,
189: TO_DATE(SUBSTR(PPA.LEGISLATIVE_PARAMETERS
190: ,INSTR(PPA.LEGISLATIVE_PARAMETERS

Line 196: PAY_ASSIGNMENT_ACTIONS PAA

192: ,10)
193: ,'YYYY/MM/DD')
194: FROM
195: PAY_PAYROLL_ACTIONS PPA,
196: PAY_ASSIGNMENT_ACTIONS PAA
197: WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
198: AND PPA.REPORT_TYPE = 'IEP30_PRGLOCK'
199: AND PAA.ASSIGNMENT_ID = VP_ASSIGNMENT_ID
200: AND PAA.ASSIGNMENT_ACTION_ID = (

Line 208: PAY_ASSIGNMENT_ACTIONS PAA2

204: ,'0') || PAA2.ASSIGNMENT_ACTION_ID)
205: ,16))
206: FROM
207: PAY_PAYROLL_ACTIONS PPA2,
208: PAY_ASSIGNMENT_ACTIONS PAA2
209: WHERE PPA2.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID
210: AND PPA2.REPORT_TYPE = 'IEP30_PRGLOCK'
211: AND PAA2.ASSIGNMENT_ID = VP_ASSIGNMENT_ID
212: AND PPA2.PAYROLL_ACTION_ID <> VP_PAYROLL_ACTION_ID

Line 221: CURSOR GET_ACTION_CONTEXT(VP_PAYROLL_ACTION_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE,VP_ASSIGNMENT_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE) IS

217: ,'YYYY/MM/DD') BETWEEN VP_TAX_START_DATE
218: AND VP_REPORT_END_DATE )
219: ORDER BY
220: PPA.PAYROLL_ACTION_ID;
221: CURSOR GET_ACTION_CONTEXT(VP_PAYROLL_ACTION_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE,VP_ASSIGNMENT_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE) IS
222: SELECT
223: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(PAA_RUN.ACTION_SEQUENCE
224: ,15
225: ,'0') || PACT_YTDBAL.ACTION_CONTEXT_ID)

Line 228: PAY_ASSIGNMENT_ACTIONS PAA_P30,

224: ,15
225: ,'0') || PACT_YTDBAL.ACTION_CONTEXT_ID)
226: ,16))
227: FROM
228: PAY_ASSIGNMENT_ACTIONS PAA_P30,
229: PAY_ACTION_INTERLOCKS PAI_P30,
230: PAY_ASSIGNMENT_ACTIONS PAA_ARC,
231: PAY_ACTION_INFORMATION PACT_YTDBAL,
232: PAY_ACTION_INTERLOCKS PAI_ARC,

Line 230: PAY_ASSIGNMENT_ACTIONS PAA_ARC,

226: ,16))
227: FROM
228: PAY_ASSIGNMENT_ACTIONS PAA_P30,
229: PAY_ACTION_INTERLOCKS PAI_P30,
230: PAY_ASSIGNMENT_ACTIONS PAA_ARC,
231: PAY_ACTION_INFORMATION PACT_YTDBAL,
232: PAY_ACTION_INTERLOCKS PAI_ARC,
233: PAY_ASSIGNMENT_ACTIONS PAA_RUN,
234: PAY_PAYROLL_ACTIONS PPA_RUN

Line 233: PAY_ASSIGNMENT_ACTIONS PAA_RUN,

229: PAY_ACTION_INTERLOCKS PAI_P30,
230: PAY_ASSIGNMENT_ACTIONS PAA_ARC,
231: PAY_ACTION_INFORMATION PACT_YTDBAL,
232: PAY_ACTION_INTERLOCKS PAI_ARC,
233: PAY_ASSIGNMENT_ACTIONS PAA_RUN,
234: PAY_PAYROLL_ACTIONS PPA_RUN
235: WHERE PAA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID
236: AND PAA_P30.ASSIGNMENT_ID = VP_ASSIGNMENT_ID
237: AND PAA_P30.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKING_ACTION_ID