APPS.PA_DISPLAY_PERIOD_MASKS dependencies on PA_LOOKUPS

Line 20: g_preceeding pa_lookups.meaning%TYPE := NULL;

16: -- Bug Fix 3671424.
17: -- Removing the hard coded string proeceeding and succeding in the code
18: -- with the appropriate lookup meanings which 'll be translated.
19:
20: g_preceeding pa_lookups.meaning%TYPE := NULL;
21: g_succeeding pa_lookups.meaning%TYPE := NULL;
22: g_to pa_lookups.meaning%TYPE := NULL;
23:
24:

Line 21: g_succeeding pa_lookups.meaning%TYPE := NULL;

17: -- Removing the hard coded string proeceeding and succeding in the code
18: -- with the appropriate lookup meanings which 'll be translated.
19:
20: g_preceeding pa_lookups.meaning%TYPE := NULL;
21: g_succeeding pa_lookups.meaning%TYPE := NULL;
22: g_to pa_lookups.meaning%TYPE := NULL;
23:
24:
25:

Line 22: g_to pa_lookups.meaning%TYPE := NULL;

18: -- with the appropriate lookup meanings which 'll be translated.
19:
20: g_preceeding pa_lookups.meaning%TYPE := NULL;
21: g_succeeding pa_lookups.meaning%TYPE := NULL;
22: g_to pa_lookups.meaning%TYPE := NULL;
23:
24:
25:
26: /* get_current_period_start_date() will get the current periods start date

Line 435: l_lookup_type PA_LOOKUPS.LOOKUP_TYPE%TYPE ;

431:
432: -- Bug Fix 3671424.
433: -- removing the hard coded strings.
434:
435: l_lookup_type PA_LOOKUPS.LOOKUP_TYPE%TYPE ;
436:
437: l_prec PA_LOOKUPS.LOOKUP_CODE%TYPE ;
438: l_succ PA_LOOKUPS.LOOKUP_CODE%TYPE ;
439: l_to PA_LOOKUPS.LOOKUP_CODE%TYPE ;

Line 437: l_prec PA_LOOKUPS.LOOKUP_CODE%TYPE ;

433: -- removing the hard coded strings.
434:
435: l_lookup_type PA_LOOKUPS.LOOKUP_TYPE%TYPE ;
436:
437: l_prec PA_LOOKUPS.LOOKUP_CODE%TYPE ;
438: l_succ PA_LOOKUPS.LOOKUP_CODE%TYPE ;
439: l_to PA_LOOKUPS.LOOKUP_CODE%TYPE ;
440:
441: CURSOR get_preceeding_csr IS

Line 438: l_succ PA_LOOKUPS.LOOKUP_CODE%TYPE ;

434:
435: l_lookup_type PA_LOOKUPS.LOOKUP_TYPE%TYPE ;
436:
437: l_prec PA_LOOKUPS.LOOKUP_CODE%TYPE ;
438: l_succ PA_LOOKUPS.LOOKUP_CODE%TYPE ;
439: l_to PA_LOOKUPS.LOOKUP_CODE%TYPE ;
440:
441: CURSOR get_preceeding_csr IS
442: SELECT meaning

Line 439: l_to PA_LOOKUPS.LOOKUP_CODE%TYPE ;

435: l_lookup_type PA_LOOKUPS.LOOKUP_TYPE%TYPE ;
436:
437: l_prec PA_LOOKUPS.LOOKUP_CODE%TYPE ;
438: l_succ PA_LOOKUPS.LOOKUP_CODE%TYPE ;
439: l_to PA_LOOKUPS.LOOKUP_CODE%TYPE ;
440:
441: CURSOR get_preceeding_csr IS
442: SELECT meaning
443: FROM pa_lookups

Line 443: FROM pa_lookups

439: l_to PA_LOOKUPS.LOOKUP_CODE%TYPE ;
440:
441: CURSOR get_preceeding_csr IS
442: SELECT meaning
443: FROM pa_lookups
444: WHERE lookup_type = l_lookup_type
445: AND lookup_code = l_prec ;
446:
447: CURSOR get_succeeding_csr IS

Line 449: FROM pa_lookups

445: AND lookup_code = l_prec ;
446:
447: CURSOR get_succeeding_csr IS
448: SELECT meaning
449: FROM pa_lookups
450: WHERE lookup_type = l_lookup_type
451: AND lookup_code = l_succ ;
452:
453: CURSOR get_to_csr IS

Line 455: FROM pa_lookups

451: AND lookup_code = l_succ ;
452:
453: CURSOR get_to_csr IS
454: SELECT meaning
455: FROM pa_lookups
456: WHERE lookup_type = l_lookup_type
457: AND lookup_code = l_to ;
458:
459:

Line 754: l_start_period pa_lookups.meaning%TYPE;

750: -- periods or succeeding periods.
751: -- so making it longer than 15 by changing it to lookups meaning %type.
752:
753: --l_start_period gl_periods.period_name%TYPE;
754: l_start_period pa_lookups.meaning%TYPE;
755:
756: CURSOR get_period_mask_details_csr IS
757: SELECT from_anchor_start
758: ,from_anchor_end

Line 830: l_end_period pa_lookups.meaning%TYPE;

826: -- so making it longer than 15 by changing it to lookups meaning %type.
827:
828:
829: --l_end_period gl_periods.period_name%TYPE;
830: l_end_period pa_lookups.meaning%TYPE;
831:
832: CURSOR get_period_mask_details_csr IS
833: SELECT from_anchor_start
834: ,from_anchor_end