APPS.PAY_KR_NONSTAT_SPAY_EFILE_FUN dependencies on FF_ARCHIVE_ITEMS

Line 15: from ff_Archive_items fai

11: cursor csr_get_prev_emp_count
12: is
13: select
14: nvl(count(fue.user_entity_id),0) prev_emp_count
15: from ff_Archive_items fai
16: ,ff_user_entities fue
17: where fue.user_entity_id = fai.user_entity_id
18: and fue.user_entity_name = 'X_KR_PREV_BP_NUMBER'
19: and fai.context1 = p_assignment_action_id