DBA Data[Home] [Help]

APPS.PAY_KR_SPAY_EFILE_FUN_PKG dependencies on FF_USER_ENTITIES

Line 11: ,ff_user_entities fue

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
15: group by fai.context1;

Line 57: ff_user_entities fue1,

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,
61: ff_user_entities fue3,

Line 59: ff_user_entities fue2,

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,
63: ff_user_entities fue4,

Line 61: ff_user_entities fue3,

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,
65: ff_user_entities fue5,

Line 63: ff_user_entities fue4,

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,
67: ff_user_entities fue6,

Line 65: ff_user_entities fue5,

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,
69: ff_user_entities fue7

Line 67: ff_user_entities fue6,

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:
71: where fue1.user_entity_name = 'A_AMOUNT_EXPECTED_ASG_RUN'

Line 69: ff_user_entities fue7

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
73: and fai1.context1 = p_assact

Line 146: ff_user_entities fue1,

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,
150: ff_user_entities fue3,

Line 148: ff_user_entities fue2,

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,
152: ff_user_entities fue4,

Line 150: ff_user_entities fue3,

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,
154: ff_user_entities fue5,

Line 152: ff_user_entities fue4,

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,
156: ff_user_entities fue6,

Line 154: ff_user_entities fue5,

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,
158: ff_user_entities fue7

Line 156: ff_user_entities fue6,

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:
160: where fue1.user_entity_name = 'A_AMOUNT_EXPECTED_NONSTAT_ASG_RUN'

Line 158: ff_user_entities fue7

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
162: and fai1.context1 = p_assact

Line 225: ff_user_entities fue1,

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,
229: ff_user_entities fue3,

Line 227: ff_user_entities fue2,

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,
231: ff_user_entities fue4

Line 229: ff_user_entities fue3,

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'
233: and fue1.user_entity_id = fai1.user_entity_id

Line 231: ff_user_entities fue4

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
235: -- Bug 9247404

Line 289: ff_user_entities fue1,

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,
293: ff_user_entities fue3,

Line 291: ff_user_entities fue2,

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,
295: ff_user_entities fue4

Line 293: ff_user_entities fue3,

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:
297: where fue1.user_entity_name = 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN'

Line 295: ff_user_entities fue4

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
299: and fai1.context1 = p_assact