DBA Data[Home] [Help]

APPS.PAY_ACTION_CONTEXTS_PKG dependencies on FF_CONTEXTS

Line 7: original_entry_id ff_contexts.context_id%type,

3: --
4: -- private global variables
5: --
6: type g_context_ids_type is record (
7: original_entry_id ff_contexts.context_id%type,
8: jurisdiction_code ff_contexts.context_id%type,
9: tax_group ff_contexts.context_id%type);
10:
11: g_context_ids g_context_ids_type;

Line 8: jurisdiction_code ff_contexts.context_id%type,

4: -- private global variables
5: --
6: type g_context_ids_type is record (
7: original_entry_id ff_contexts.context_id%type,
8: jurisdiction_code ff_contexts.context_id%type,
9: tax_group ff_contexts.context_id%type);
10:
11: g_context_ids g_context_ids_type;
12: g_legislation_code pay_legislation_rules.legislation_code%type;

Line 9: tax_group ff_contexts.context_id%type);

5: --
6: type g_context_ids_type is record (
7: original_entry_id ff_contexts.context_id%type,
8: jurisdiction_code ff_contexts.context_id%type,
9: tax_group ff_contexts.context_id%type);
10:
11: g_context_ids g_context_ids_type;
12: g_legislation_code pay_legislation_rules.legislation_code%type;
13:

Line 29: FROM FF_CONTEXTS c3,

25: SELECT c1.context_id original_entry_id,
26: c2.context_id jurisdiction_code,
27: c3.context_id tax_group
28: INTO g_context_ids
29: FROM FF_CONTEXTS c3,
30: FF_CONTEXTS c2,
31: FF_CONTEXTS c1
32: WHERE c1.context_name = 'ORIGINAL_ENTRY_ID'
33: and c2.context_name = 'JURISDICTION_CODE'

Line 30: FF_CONTEXTS c2,

26: c2.context_id jurisdiction_code,
27: c3.context_id tax_group
28: INTO g_context_ids
29: FROM FF_CONTEXTS c3,
30: FF_CONTEXTS c2,
31: FF_CONTEXTS c1
32: WHERE c1.context_name = 'ORIGINAL_ENTRY_ID'
33: and c2.context_name = 'JURISDICTION_CODE'
34: and c3.context_name = 'TAX_GROUP';

Line 31: FF_CONTEXTS c1

27: c3.context_id tax_group
28: INTO g_context_ids
29: FROM FF_CONTEXTS c3,
30: FF_CONTEXTS c2,
31: FF_CONTEXTS c1
32: WHERE c1.context_name = 'ORIGINAL_ENTRY_ID'
33: and c2.context_name = 'JURISDICTION_CODE'
34: and c3.context_name = 'TAX_GROUP';
35: exception