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;
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,
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,
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,
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,
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
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'
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
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,
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,
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,
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,
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
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'
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
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,
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
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
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
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,
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
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'
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