APPS.PSP_PSPENEXR_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 116: PAY_ELEMENT_TYPES_F PETF

112: SELECT
113: ELEMENT_NAME,
114: 1 ORDER_BY
115: FROM
116: PAY_ELEMENT_TYPES_F PETF
117: WHERE PETF.ELEMENT_TYPE_ID = CF_ELEMENT_NAMEFORMULA.ELEMENT_TYPE_ID
118: AND PETF.EFFECTIVE_START_DATE <= MAX_END_DATE
119: AND PETF.EFFECTIVE_END_DATE >= MIN_START_DATE
120: AND ROWNUM = 1

Line 126: PAY_ELEMENT_TYPES_F PETF

122: SELECT
123: ELEMENT_NAME,
124: 2 ORDER_BY
125: FROM
126: PAY_ELEMENT_TYPES_F PETF
127: WHERE PETF.ELEMENT_TYPE_ID = CF_ELEMENT_NAMEFORMULA.ELEMENT_TYPE_ID
128: AND PETF.EFFECTIVE_START_DATE = (
129: SELECT
130: MAX(PETF2.EFFECTIVE_START_DATE)

Line 132: PAY_ELEMENT_TYPES_F PETF2

128: AND PETF.EFFECTIVE_START_DATE = (
129: SELECT
130: MAX(PETF2.EFFECTIVE_START_DATE)
131: FROM
132: PAY_ELEMENT_TYPES_F PETF2
133: WHERE PETF2.ELEMENT_TYPE_ID = CF_ELEMENT_NAMEFORMULA.ELEMENT_TYPE_ID )
134: ORDER BY
135: 2;
136: L_DUMMY NUMBER;

Line 137: L_ELEMENT_NAME PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;

133: WHERE PETF2.ELEMENT_TYPE_ID = CF_ELEMENT_NAMEFORMULA.ELEMENT_TYPE_ID )
134: ORDER BY
135: 2;
136: L_DUMMY NUMBER;
137: L_ELEMENT_NAME PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
138: BEGIN
139: OPEN ELEMENT_NAME_CUR;
140: FETCH ELEMENT_NAME_CUR
141: INTO L_ELEMENT_NAME,L_DUMMY;