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