APPS.CST_REVENUECOGSMATCH_PVT dependencies on FND_LOOKUPS

Line 5586: l_meaning FND_LOOKUPS.MEANING%TYPE;

5582: l_org_code CST_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
5583: l_cost_type CST_COST_TYPES.COST_TYPE%TYPE;
5584: l_cost_group CST_COST_GROUPS.COST_GROUP%TYPE;
5585: l_period_name CST_PAC_PERIODS.PERIOD_NAME%TYPE;
5586: l_meaning FND_LOOKUPS.MEANING%TYPE;
5587: l_stmt_num number;
5588:
5589: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5590: l_errorLog constant boolean := l_uLog and (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);

Line 5658: fnd_lookups fl

5654: :i_sales_order_date_high sales_order_date_to,
5655: fl.meaning all_lines
5656: from hr_all_organization_units haou,
5657: gl_sets_of_books gsb,
5658: fnd_lookups fl
5659: where haou.organization_id = :i_operating_unit
5660: and gsb.set_of_books_id = :i_ledger_id
5661: and fl.lookup_code = :i_all_lines
5662: and fl.lookup_type = ''YES_NO'''

Line 5690: FROM fnd_lookups

5686: WHERE pac_period_id = TO_NUMBER(i_period_name);
5687:
5688: SELECT meaning
5689: INTO l_meaning
5690: FROM fnd_lookups
5691: WHERE lookup_type = 'YES_NO'
5692: AND lookup_code = i_all_lines;
5693:
5694: open l_ref_cur for 'select :i_cost_method cost_method,