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_PAYROLL_ACTIONS

Line 4: CURSOR CUR_ARCSTARTDATE(VP_PAYROLL_ACTION_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE) IS

1: PACKAGE BODY PAY_PAYIEP30_XMLP_PKG AS
2: /* $Header: PAYIEP30B.pls 120.2 2008/03/26 12:54:10 amakrish noship $ */
3: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
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,

Line 11: PAY_PAYROLL_ACTIONS PPA_ARC

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
15: AND PPA_ARC.PAYROLL_ACTION_ID = PAA_ARC.PAYROLL_ACTION_ID;

Line 16: CURSOR CUR_ENDDATE(VP_PAYROLL_ACTION_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE) IS

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
15: AND PPA_ARC.PAYROLL_ACTION_ID = PAA_ARC.PAYROLL_ACTION_ID;
16: CURSOR CUR_ENDDATE(VP_PAYROLL_ACTION_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE) IS
17: SELECT
18: SUBSTR(PPA_P30.LEGISLATIVE_PARAMETERS
19: ,INSTR(PPA_P30.LEGISLATIVE_PARAMETERS
20: ,'END_DATE=') + 9

Line 23: PAY_PAYROLL_ACTIONS PPA_P30

19: ,INSTR(PPA_P30.LEGISLATIVE_PARAMETERS
20: ,'END_DATE=') + 9
21: ,10) END_DATE
22: FROM
23: PAY_PAYROLL_ACTIONS PPA_P30
24: WHERE PPA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID;
25: CURSOR CUR_GET_START_DATE(VP_REPORT_END_DATE IN DATE) IS
26: SELECT
27: TO_DATE(RULE_MODE || '/' || TO_CHAR(VP_REPORT_END_DATE

Line 147: CURSOR YTD_BALANCES(VP_PAYROLL_ACTION_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE,

143: END P_BUSINESS_GROUP_IDVALIDTRIGGE;
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

Line 162: PAY_PAYROLL_ACTIONS PPA_SRC

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
166: AND PAA_ARC.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKED_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 195: PAY_PAYROLL_ACTIONS PPA,

191: ,'END_DATE=') + 9
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

Line 207: PAY_PAYROLL_ACTIONS PPA2,

203: ,15
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

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 234: PAY_PAYROLL_ACTIONS PPA_RUN

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
238: AND PAA_ARC.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKED_ACTION_ID