DBA Data[Home] [Help]

APPS.PJI_PMV_PROFITABILITY dependencies on PJI_LOOKUPS

Line 463: FROM pji_lookups

459: ** Populate Report Labels
460: */
461: SELECT meaning
462: INTO l_label_rev
463: FROM pji_lookups
464: WHERE lookup_type = 'PJI_PROFITABILITY_MEASURES'
465: AND lookup_code = 'REVENUE';
466:
467: SELECT meaning

Line 469: FROM pji_lookups

465: AND lookup_code = 'REVENUE';
466:
467: SELECT meaning
468: INTO l_label_cost
469: FROM pji_lookups
470: WHERE lookup_type = 'PJI_PROFITABILITY_MEASURES'
471: AND lookup_code = 'COST';
472:
473: SELECT meaning

Line 475: FROM pji_lookups

471: AND lookup_code = 'COST';
472:
473: SELECT meaning
474: INTO l_label_margin
475: FROM pji_lookups
476: WHERE lookup_type = 'PJI_PROFITABILITY_MEASURES'
477: AND lookup_code = 'MARGIN';
478:
479: SELECT meaning

Line 481: FROM pji_lookups

477: AND lookup_code = 'MARGIN';
478:
479: SELECT meaning
480: INTO l_label_mgnpct
481: FROM pji_lookups
482: WHERE lookup_type = 'PJI_PROFITABILITY_MEASURES'
483: AND lookup_code = 'MARGIN_PERCENT';
484:
485: