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_KR_SPAY_EFILE_FUN_PKG dependencies on FF_ARCHIVE_ITEMS

Line 10: from ff_Archive_items fai

6: l_prev_emp_count NUMBER(4);
7: cursor csr_get_prev_emp_count is
8: select
9: nvl(count(fue.user_entity_id),0) prev_emp_count
10: from ff_Archive_items fai
11: ,ff_user_entities fue
12: where fue.user_entity_id = fai.user_entity_id
13: and fue.user_entity_name = 'X_KR_PREV_BP_NUMBER'
14: and fai.context1 = p_assignment_action_id

Line 56: from ff_Archive_items fai1,

52: fai4.value,
53: fai5.value,
54: fai6.value,
55: fai7.value
56: from ff_Archive_items fai1,
57: ff_user_entities fue1,
58: ff_Archive_items fai2,
59: ff_user_entities fue2,
60: ff_Archive_items fai3,

Line 58: ff_Archive_items fai2,

54: fai6.value,
55: fai7.value
56: from ff_Archive_items fai1,
57: ff_user_entities fue1,
58: ff_Archive_items fai2,
59: ff_user_entities fue2,
60: ff_Archive_items fai3,
61: ff_user_entities fue3,
62: ff_Archive_items fai4,

Line 60: ff_Archive_items fai3,

56: from ff_Archive_items fai1,
57: ff_user_entities fue1,
58: ff_Archive_items fai2,
59: ff_user_entities fue2,
60: ff_Archive_items fai3,
61: ff_user_entities fue3,
62: ff_Archive_items fai4,
63: ff_user_entities fue4,
64: ff_Archive_items fai5,

Line 62: ff_Archive_items fai4,

58: ff_Archive_items fai2,
59: ff_user_entities fue2,
60: ff_Archive_items fai3,
61: ff_user_entities fue3,
62: ff_Archive_items fai4,
63: ff_user_entities fue4,
64: ff_Archive_items fai5,
65: ff_user_entities fue5,
66: ff_Archive_items fai6,

Line 64: ff_Archive_items fai5,

60: ff_Archive_items fai3,
61: ff_user_entities fue3,
62: ff_Archive_items fai4,
63: ff_user_entities fue4,
64: ff_Archive_items fai5,
65: ff_user_entities fue5,
66: ff_Archive_items fai6,
67: ff_user_entities fue6,
68: ff_Archive_items fai7,

Line 66: ff_Archive_items fai6,

62: ff_Archive_items fai4,
63: ff_user_entities fue4,
64: ff_Archive_items fai5,
65: ff_user_entities fue5,
66: ff_Archive_items fai6,
67: ff_user_entities fue6,
68: ff_Archive_items fai7,
69: ff_user_entities fue7
70:

Line 68: ff_Archive_items fai7,

64: ff_Archive_items fai5,
65: ff_user_entities fue5,
66: ff_Archive_items fai6,
67: ff_user_entities fue6,
68: ff_Archive_items fai7,
69: ff_user_entities fue7
70:
71: where fue1.user_entity_name = 'A_AMOUNT_EXPECTED_ASG_RUN'
72: and fue1.user_entity_id = fai1.user_entity_id

Line 145: from ff_Archive_items fai1,

141: fai4.value,
142: fai5.value,
143: fai6.value,
144: fai7.value
145: from ff_Archive_items fai1,
146: ff_user_entities fue1,
147: ff_Archive_items fai2,
148: ff_user_entities fue2,
149: ff_Archive_items fai3,

Line 147: ff_Archive_items fai2,

143: fai6.value,
144: fai7.value
145: from ff_Archive_items fai1,
146: ff_user_entities fue1,
147: ff_Archive_items fai2,
148: ff_user_entities fue2,
149: ff_Archive_items fai3,
150: ff_user_entities fue3,
151: ff_Archive_items fai4,

Line 149: ff_Archive_items fai3,

145: from ff_Archive_items fai1,
146: ff_user_entities fue1,
147: ff_Archive_items fai2,
148: ff_user_entities fue2,
149: ff_Archive_items fai3,
150: ff_user_entities fue3,
151: ff_Archive_items fai4,
152: ff_user_entities fue4,
153: ff_Archive_items fai5,

Line 151: ff_Archive_items fai4,

147: ff_Archive_items fai2,
148: ff_user_entities fue2,
149: ff_Archive_items fai3,
150: ff_user_entities fue3,
151: ff_Archive_items fai4,
152: ff_user_entities fue4,
153: ff_Archive_items fai5,
154: ff_user_entities fue5,
155: ff_Archive_items fai6,

Line 153: ff_Archive_items fai5,

149: ff_Archive_items fai3,
150: ff_user_entities fue3,
151: ff_Archive_items fai4,
152: ff_user_entities fue4,
153: ff_Archive_items fai5,
154: ff_user_entities fue5,
155: ff_Archive_items fai6,
156: ff_user_entities fue6,
157: ff_Archive_items fai7,

Line 155: ff_Archive_items fai6,

151: ff_Archive_items fai4,
152: ff_user_entities fue4,
153: ff_Archive_items fai5,
154: ff_user_entities fue5,
155: ff_Archive_items fai6,
156: ff_user_entities fue6,
157: ff_Archive_items fai7,
158: ff_user_entities fue7
159:

Line 157: ff_Archive_items fai7,

153: ff_Archive_items fai5,
154: ff_user_entities fue5,
155: ff_Archive_items fai6,
156: ff_user_entities fue6,
157: ff_Archive_items fai7,
158: ff_user_entities fue7
159:
160: where fue1.user_entity_name = 'A_AMOUNT_EXPECTED_NONSTAT_ASG_RUN'
161: and fue1.user_entity_id = fai1.user_entity_id

Line 224: from ff_Archive_items fai1,

220: select fai1.value,
221: fai2.value,
222: fai3.value,
223: fai4.value
224: from ff_Archive_items fai1,
225: ff_user_entities fue1,
226: ff_Archive_items fai2,
227: ff_user_entities fue2,
228: ff_Archive_items fai3,

Line 226: ff_Archive_items fai2,

222: fai3.value,
223: fai4.value
224: from ff_Archive_items fai1,
225: ff_user_entities fue1,
226: ff_Archive_items fai2,
227: ff_user_entities fue2,
228: ff_Archive_items fai3,
229: ff_user_entities fue3,
230: ff_Archive_items fai4,

Line 228: ff_Archive_items fai3,

224: from ff_Archive_items fai1,
225: ff_user_entities fue1,
226: ff_Archive_items fai2,
227: ff_user_entities fue2,
228: ff_Archive_items fai3,
229: ff_user_entities fue3,
230: ff_Archive_items fai4,
231: ff_user_entities fue4
232: where fue1.user_entity_name = 'A_RECEIVABLE_NON_STAT_SEP_PAY_ASG_RUN'

Line 230: ff_Archive_items fai4,

226: ff_Archive_items fai2,
227: ff_user_entities fue2,
228: ff_Archive_items fai3,
229: ff_user_entities fue3,
230: ff_Archive_items fai4,
231: ff_user_entities fue4
232: where fue1.user_entity_name = 'A_RECEIVABLE_NON_STAT_SEP_PAY_ASG_RUN'
233: and fue1.user_entity_id = fai1.user_entity_id
234: and fai1.context1 = p_assact

Line 288: from ff_Archive_items fai1,

284: fai2.value,
285: fai3.value,
286: fai4.value
287:
288: from ff_Archive_items fai1,
289: ff_user_entities fue1,
290: ff_Archive_items fai2,
291: ff_user_entities fue2,
292: ff_Archive_items fai3,

Line 290: ff_Archive_items fai2,

286: fai4.value
287:
288: from ff_Archive_items fai1,
289: ff_user_entities fue1,
290: ff_Archive_items fai2,
291: ff_user_entities fue2,
292: ff_Archive_items fai3,
293: ff_user_entities fue3,
294: ff_Archive_items fai4,

Line 292: ff_Archive_items fai3,

288: from ff_Archive_items fai1,
289: ff_user_entities fue1,
290: ff_Archive_items fai2,
291: ff_user_entities fue2,
292: ff_Archive_items fai3,
293: ff_user_entities fue3,
294: ff_Archive_items fai4,
295: ff_user_entities fue4
296:

Line 294: ff_Archive_items fai4,

290: ff_Archive_items fai2,
291: ff_user_entities fue2,
292: ff_Archive_items fai3,
293: ff_user_entities fue3,
294: ff_Archive_items fai4,
295: ff_user_entities fue4
296:
297: where fue1.user_entity_name = 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN'
298: and fue1.user_entity_id = fai1.user_entity_id