APPS.PAY_US_SQWL_ARCHIVE dependencies on FF_CONTEXTS

Line 1797: from ff_contexts

1793: l_arch_gre_step := 10;
1794:
1795: select context_id
1796: into l_tax_context_id
1797: from ff_contexts
1798: where context_name = 'TAX_UNIT_ID';
1799:
1800: /* Get the context_id for 'JURISDICTION_CODE' */
1801:

Line 1806: from ff_contexts

1802: l_arch_gre_step := 20;
1803:
1804: select context_id
1805: into l_jursd_context_id
1806: from ff_contexts
1807: where context_name = 'JURISDICTION_CODE';
1808:
1809:
1810: /* get the state code for the state abbrev */

Line 2548: FROM ff_contexts

2544: hr_utility.trace('Archived the adjusted OH Taxable');
2545:
2546: SELECT context_id
2547: INTO l_context_id_tax_unit_id
2548: FROM ff_contexts
2549: WHERE context_name = 'TAX_UNIT_ID';
2550:
2551: INSERT INTO ff_archive_item_contexts
2552: (archive_item_id,sequence_no,context,context_id)

Line 2557: FROM ff_contexts

2553: VALUES (ff_archive_items_s.CURRVAL,1,taxunitid,l_context_id_tax_unit_id);
2554:
2555: SELECT context_id
2556: INTO l_context_id_jurisdiction_code
2557: FROM ff_contexts
2558: WHERE context_name = 'JURISDICTION_CODE';
2559:
2560: INSERT INTO ff_archive_item_contexts
2561: (archive_item_id,sequence_no,context,context_id)

Line 2836: FROM ff_contexts

2832: hr_utility.trace('Archived the adjusted AR Taxable');
2833:
2834: SELECT context_id
2835: INTO l_context_id_tax_unit_id
2836: FROM ff_contexts
2837: WHERE context_name = 'TAX_UNIT_ID';
2838:
2839: INSERT INTO ff_archive_item_contexts
2840: (archive_item_id,sequence_no,context,context_id)

Line 2845: FROM ff_contexts

2841: VALUES (ff_archive_items_s.CURRVAL,1,taxunitid,l_context_id_tax_unit_id);
2842:
2843: SELECT context_id
2844: INTO l_context_id_jurisdiction_code
2845: FROM ff_contexts
2846: WHERE context_name = 'JURISDICTION_CODE';
2847:
2848: INSERT INTO ff_archive_item_contexts
2849: (archive_item_id,sequence_no,context,context_id)

Line 3039: FROM ff_contexts

3035: hr_utility.trace('Archived the adjusted FL Taxable');
3036:
3037: SELECT context_id
3038: INTO l_context_id_tax_unit_id
3039: FROM ff_contexts
3040: WHERE context_name = 'TAX_UNIT_ID';
3041:
3042: INSERT INTO ff_archive_item_contexts
3043: (archive_item_id,sequence_no,context,context_id)

Line 3048: FROM ff_contexts

3044: VALUES (ff_archive_items_s.CURRVAL,1,taxunitid,l_context_id_tax_unit_id);
3045:
3046: SELECT context_id
3047: INTO l_context_id_jurisdiction_code
3048: FROM ff_contexts
3049: WHERE context_name = 'JURISDICTION_CODE';
3050:
3051: INSERT INTO ff_archive_item_contexts
3052: (archive_item_id,sequence_no,context,context_id)

Line 3063: FROM ff_contexts

3059: l_quarter_end := ADD_MONTHS(TRUNC(p_effective_date, 'Q'),3) - 1;
3060:
3061: SELECT context_id
3062: INTO l_context_id_assignment_id
3063: FROM ff_contexts
3064: WHERE context_name = 'ASSIGNMENT_ID';
3065:
3066: /* l_user_entity_id, l_context_id_date_earned, l_context_id_assignment_id,
3067: can be declared as global variables, then there will be no need