DBA Data[Home] [Help]

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 46: from ff_Archive_items fai1,

42:
43: cursor csr_sep_amounts is
44: select fai1.value amount_expected,
45: fai2.value receivable_sep_pay
46: from ff_Archive_items fai1,
47: ff_user_entities fue1,
48: ff_Archive_items fai2,
49: ff_user_entities fue2
50: where fue1.user_entity_name = 'A_AMOUNT_EXPECTED_ASG_RUN'

Line 48: ff_Archive_items fai2,

44: select fai1.value amount_expected,
45: fai2.value receivable_sep_pay
46: from ff_Archive_items fai1,
47: ff_user_entities fue1,
48: ff_Archive_items fai2,
49: ff_user_entities fue2
50: where fue1.user_entity_name = 'A_AMOUNT_EXPECTED_ASG_RUN'
51: and fue1.user_entity_id = fai1.user_entity_id
52: and fai1.context1 = p_assact