DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on FND_LOOKUPS

Line 5702: l_meaning FND_LOOKUPS.MEANING%TYPE;

5698: l_org_code CST_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
5699: l_cost_type CST_COST_TYPES.COST_TYPE%TYPE;
5700: l_cost_group CST_COST_GROUPS.COST_GROUP%TYPE;
5701: l_period_name CST_PAC_PERIODS.PERIOD_NAME%TYPE;
5702: l_meaning FND_LOOKUPS.MEANING%TYPE;
5703: l_stmt_num number;
5704:
5705: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);
5706: l_errorLog constant boolean := l_uLog and (fnd_log.LEVEL_ERROR >= G_LOG_LEVEL);

Line 5774: fnd_lookups fl

5770: fl.meaning all_lines,
5771: :i_amt_tolerance tolerance_amount
5772: from hr_all_organization_units haou,
5773: gl_sets_of_books gsb,
5774: fnd_lookups fl
5775: where haou.organization_id = :i_operating_unit
5776: and gsb.set_of_books_id = :i_ledger_id
5777: and fl.lookup_code = :i_all_lines
5778: and fl.lookup_type = ''YES_NO'''

Line 5807: FROM fnd_lookups

5803: WHERE pac_period_id = TO_NUMBER(i_period_name);
5804:
5805: SELECT meaning
5806: INTO l_meaning
5807: FROM fnd_lookups
5808: WHERE lookup_type = 'YES_NO'
5809: AND lookup_code = i_all_lines;
5810:
5811: open l_ref_cur for 'select :i_cost_method cost_method,